EPPLUS Exception while using .xls

Nov 16, 2011 at 5:27 AM

Hi All,

I am not able to import excel(.xls) sheet using EPPLUS 2.9.0.1, but can able to import .xlsx smoothly.

While importing .xls it is throwing exception in this line:

using (var package = new ExcelPackage(existingFile)) -- exception : "Can not open the package. Package is an OLE compound document. If this is an encrypted package, please supply the password"
{

....

}

File name is in this formate : "b8ec0b0a-03f5-4796-b376-61a44a3a1457_1.xls"

can anyone tell me that EPPLUS 2.9.0.1 will support .xls? if yes, then any simple example.

Regards

Madhusudhan

 

 

 

Developer
Nov 16, 2011 at 7:48 AM

EPPlus does not support the xls format. Checkout the NPOI project (on Codeplex) to read xls files.

Nov 16, 2011 at 8:09 AM

Thanks for your reply swmal