CODEWITHSUNDEEP
excelconsole-application.net-corexlsepplus
san
san

Reputation: 1859

.Net core read xls files

I am trying to read .XLS file in my .NetCore console application which will hosted in Azure environment. I am using EPPlus.Core (version 1.3.2) and getting the below error

"EPPlus can not open the package. Package is an OLE compound document. If this is an encrypted package, please supply the password"

I think XLS file is not supported by EPPlus core

Please suggest me a solution to resolve this issue.

Upvotes: 2

Views: 5987

Answers (1)

Pete
Pete

Reputation: 1867

.xls isn't supported by EPPlus at all - it only deals with .xlsx and they have no plans to support the older file format.

I use the ExcelDataReader package on NuGet / GitHub with .Net 4.5 - they've been talking about releasing a .Net Core version for a while now, so you may have some luck there.

Clarification: I use EPPlus for everything related to .xlsx files - I use ExcelDataReader solely for reading .xls files.

Upvotes: 7

Related Questions