Excel.ExcelReaderFactory cannot open some files

Question

I'm getting this error trying to open some xls files using the Excel.ExcelReaderFactory (http://exceldatareader.codeplex.com/)

IExcelDataReader excelReader = ExcelReaderFactory.CreateBinaryReader(stream);

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

Error: Neither stream 'Workbook' nor 'Book' was found in file

The error occures when you call CreateBinaryReader

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

Similar question on their site (http://exceldatareader.codeplex.com/discussions/461766)

I did a compare between a file that works and a file that doesn't. The file that doesn't work has the following right at the bottom: Crystal Decisions Powered by Crystal — Peter Munnings
– Peter Munnings, Commented Oct 10, 2013 at 12:17
It would be wise to post your question in there discussion forum — Rohit
– Rohit, Commented Oct 10, 2013 at 12:18

Peter Munnings · Accepted Answer · 2013-10-29 04:35:15Z

2

This is from http://exceldatareader.codeplex.com/discussions/461766#post1113133 thought I'd post it here:

Same problem, same exception with crystal report xls file. This because 'Excel Data Reader' defines block strings as "Workbook" and "Book", instead Crystal Report as "WORKBOOK": you have to do a case insensitive comparison!

open "Excel\Core\BinaryFormat\XlsRootDirectory.cs" and replace line 75

if (e.EntryName == EntryName)

with

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

for me it solved.

have a nice day, marco

answered Oct 29, 2013 at 4:35

Peter Munnings

3,3291 gold badge33 silver badges43 bronze badges

Sign up to request clarification or add additional context in comments.

3 Comments

Peter Munnings Over a year ago

Getting a new exception now: BIFF Stream error: Buffer size is less than entry length. on line 32 in XlsBiffRecord.cs

Peter Munnings Over a year ago

Added ReadOption.Loose to the CreateBinaryReader parameters _excelReader = ExcelReaderFactory.CreateBinaryReader(stream, ReadOption.Loose); and now it works 100%

Ronak Patel Over a year ago

one of my client try to upload excel and I found "BIFF Stream error: Buffer size is less than entry length" entry in my log DB, so I want to know when this error occurred ? (it's working fine for all other file).

Collectives™ on Stack Overflow

Excel.ExcelReaderFactory cannot open some files

1 Answer 1

3 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

3 Comments

Your Answer

Sign up or log in

Post as a guest

Related