Excel Data Reader library
I try to import excel file.
With code like this
FileStream stream = File.Open(filePath, FileMode.Open, FileAccess.Read); //1. Reading from a binary Excel file ('97-2003 format; *.xls) IExcelDataReader excelReader = ExcelReaderFactory.CreateBinaryReader(stream); //... //2. Reading from a OpenXml Excel file (2007 format; *.xlsx) IExcelDataReader excelReader = ExcelReaderFactory.CreateOpenXmlReader(stream); //... //3. DataSet - The result of each spreadsheet will be created in the result.Tables DataSet result = excelReader.AsDataSet();
I've got an exceptionIndexOutOfRangeException
on some files.
SolutionWhat've I found out by experimental way: problem files was in old Excel 5-7 format.
"save as" problem files in "excel 97-2003" format and reimport them.