Error while uploading .xlsx file using ExcelDataReader

Question

I am working on asp.net MVC project.

I use ExcelDataReader component to read excel file records.

Now when I published my project to server and upload a .xlsx file with uploader I get below mentioned exception message. There are no errors with local deployment but server.

Access to the path '\Microsoft Corporation\Internet Information Services\7.5.7600.16385' is denied.

and code where I am getting error is:

if (personsFile.FileExtension == ".xls")
{
     Stream st = new MemoryStream(personsFile.FileArray);
     reader = ExcelReaderFactory.CreateBinaryReader(st);
}
else if (personsFile.FileExtension == ".xlsx")
{
     Stream st = new MemoryStream(personsFile.FileArray);
     //exception occured on under line
     reader = ExcelReaderFactory.CreateOpenXmlReader(st);
}

But when I upload a .xls file, I dont have any error.

How to resolve issue with .xlsx extenstion?

@PankajKapare personsFile is a object that has 2 property , one, FileExtension that is string and two, FileArray that is byte array — Mahdi Radi, Dec 17 '16 at 15:34
Have you tried CreateReader or CreateBinaryReader instead of CreateOpenXmlReader? — Pankaj Kapare, Dec 17 '16 at 15:41
@PankajKapare yes, and throw exception. and if you see the example of component creator will see that use CreateOpenXmlReader for xlsx extenstion. furthermore i don't have error in my local — Mahdi Radi, Dec 17 '16 at 18:05

score 0 · Answer 1 · answered Jul 07 '17 at 20:18

0

This is most likely due to ExcelDataReader 2.x extracting the xlsx archive to %TEMP% before processing it. The current pre-alpha of 3.0 no longer does this. See https://github.com/ExcelDataReader/ExcelDataReader/releases.

answered Jul 07 '17 at 20:18

Johan Appelgren

331
1
5

Error while uploading .xlsx file using ExcelDataReader

1 Answers1