Empty cell values

Apr 22, 2014 at 9:40 PM
I've used ExcelDataReader previously with great success on both .xls and .xlsx files. I am trying to use it on a new project, but am running into an issue where when I call AsDataSet and then iterate over rows in one of the DataTables, all of the cell values are either empty string or DBNull. What can cause this to occur? The file is an .xls that says its 97-2003 file format.

Thanks for the great library!
Developer
Apr 23, 2014 at 10:32 AM
  1. Are you using the latest version from nuget?
  2. Download the source code and try the TestApp project and point it at your file. If it is still coming out empty then that particular sheet probably has some oddity that needs debugging in the library. You could either, a) do this yourself, b) post an issue and a sample file that has the problem here and I will attempt to take a look at it.
Your fastest route to a solution though is to try and debug it yourself, as I am maxed out at the moment. If you do debug it yourself and spot a bug in the library then please post the fix, so I can try and incorporate it into the library when I have time.

Cheers
Ian