Why close xml does not support .xls formated excel file?

c# closedxml
Shriram Sapate picture Shriram Sapate · Dec 18, 2013 · Viewed 11.3k times · Source

During accessing ".xls" formated excel file using "closed xml" dll following exception is occurred

Exception : Excel may contain corrupted data...

Answer

Brad Bruce picture Brad Bruce · Dec 18, 2013

As stated by others, ClosedXML only works with the newer format.

NPOI works with older versions as well. If you use NPOI, make sure that you download the beta from their site. As of Dec 18, 2013 the NuGet download ONLY supports XLS. The beta supports XLS and XLSX

Related questions

Reading from Excel File using ClosedXML

My Excel file is not in tabular data. I am trying to read from an excel file. I have sections within my excel file that are tabular. I need to loop through rows 3 to 20 which are tabular and read the …

Read More
Download file with ClosedXML

All How can I download a file so the user sees that it is downloading (like with a stream?) I am currently using ClosedXML, but if I use the SaveAs method, I have to give a hard-coded URL, and if …

Read More
How to make Excel wrap text in formula cell with ClosedXml

The problem is that the cell content is not wrapped, when that cell contains a formula referring to a cell with some long string. On CodePlex I found a thread on this issue and a simple code to see the …

Read More