Excel.ExcelReaderFactory cannot open some files

Question

I get this error while trying to open some xls files using Excel.ExcelReaderFactory ( http://exceldatareader.codeplex.com/ )

IExcelDataReader excelReader = ExcelReaderFactory.CreateBinaryReader(stream);

excelReader.IsFirstRowAsColumnNames = false;
DataSet spreadsheetDocument = excelReader.AsDataSet();

Error: neither the Workbook thread nor the Book was found in the file

An error occurs when calling CreateBinaryReader

Some files work 100%, but others provide this exception. Does anyone have any idea?

A similar question on their website ( http://exceldatareader.codeplex.com/discussions/461766 )

Answer 1

http://exceldatareader.codeplex.com/discussions/461766#post1113133 , :

, xls . , "Excel Data Reader" - " " "", Crystal Report - "WORKBOOK": !

"Excel\Core\BinaryFormat\XlsRootDirectory.cs" 75

if (e.EntryName == EntryName)

if (string.Equals(e.EntryName, EntryName, StringComparison.CurrentCultureIgnoreCase))

.

,