Excel Object in asp.net

Question

Hi I have a serious issue. I am using excel object for opening the excel file it works fine i my PC. when i make application as a website and running the page and uploading it gives the error "'C:\Documents and Settings\Administrator\Desktop\Work\SABRE MSO Mapping Request Template.xlsx' could not be found. Check the spelling of the file name, and verify that the file location is correct. If you are trying to open the file from your list of most recently used files, make sure that the file has not been renamed, moved, or deleted. ".

I think it taking server path...but i want to open client excel file before saving the file to the server.

Plz help.

Answer 1

have you tried server.mappath() method ?? Do you have proper permissions setup to access the folder??

Answer 2

Are you passing complete file path to the excel for opening the file? Please try this:

    if (fileUpload.HasFile)
    {
        string fileName = "PATH_RELATIVE_TO_YOUR_SITE" + "FILE_NAME";
        fileUpload.PostedFile.SaveAs(fileName);
        //NOW open excel using fileName;
    }

also you need write permissions to the path (folder) you are writing file to.