Error: Buffer size is less than minimum BIFF record size.

[redflowIT]

HI all,
I get the exception "Error: Buffer size is less than minimum BIFF record size." when I try to access data of the attached file with this simple code:
excelReader = ExcelReaderFactory.CreateBinaryReader(stream, true);
excelReader.IsFirstRowAsColumnNames = true;
DataSet result = excelReader.AsDataSet(true);

I could open the file with Excel without problem.

I tried also the testapp application with same result (exception on line 20 of XlsBiffRecord.cs)

What's wrong in my code ?

Regards
Domenico

BNLI CC 1 01_2016_20160830_1622043310.zip

[wizardgsz]

Could you kindly double check Buffer size is less than minimum BIFF record size #45?
Please let us know if it solves your issue.

Verify also the usage of ReadOption.Loose flag calling the constructor. Thanks.

[redflowIT]

No even with this fix I have the same exception: it never use the "new" code with my file.

[appel1]

Looks like it is because the record immediately after BOF is DIMENSIONS and because of that the current code skips it.

[wizardgsz]

Just guessing...
Are you sure it's BIFF8 or later?

This is another file without ROW records and only LABELSST (as #111).
It uses EXTERNSHEET record, isn't it available only for earlier BIFF2-BIFF5 files?

[redflowIT]

I'm still having the same problem. A lot of Excel files generated from an ERP that I couldn't process. Is there a new version on the road to fix this issue ?

Exception System.ArgumentException
Message BIFF Stream error: Buffer size is less than entry length.
StackTrace
at Excel.Core.BinaryFormat.XlsBiffRecord..ctor(Byte[] bytes, UInt32 offset, ExcelBinaryReader reader)
at Excel.Core.BinaryFormat.XlsBiffRecord.GetRecord(Byte[] bytes, UInt32 offset, ExcelBinaryReader reader)
at Excel.Core.BinaryFormat.XlsBiffStream.Read()
at Excel.ExcelBinaryReader.readWorkSheetGlobals(XlsWorksheet sheet, XlsBiffIndex& idx, XlsBiffRow& row)
at Excel.ExcelBinaryReader.readWholeWorkSheet(XlsWorksheet sheet)
at Excel.ExcelBinaryReader.AsDataSet(Boolean convertOADateTime)