ExcelReaderFactory.CreateOpenXmlReader creates empty Dataset if more than 100 columns

Aug 10, 2013 at 9:40 AM
Your library works without Problems unless I have a .xlsx file with more than 100 columns. In such a case the generated Dataset using the method .excelReader.AsDataSet() is empty. If I reduce the columns in the same file then everything works ok.
Is this a bug or do I have to configuer somting in order to Import files with more than 100 columns?
Thank you for your help!
Aug 12, 2013 at 9:07 AM
I tried to debug the source code. _workbook.Sheets.Count within excelReader is 0.

The strange Thing is that if I add a scond Workbook-Sheet with only a few columns then _workbook.Sheets.Count is 2 and the Dataset is not empty anymore but contains correctly 2 DataTables.
Aug 12, 2013 at 4:34 PM
I guess you can ignore my issue. I had an Excel file which was generated through the open XML sdk and was probably not 100% valid...