XLSB Read error #1044

Closed
opened 2018-03-19 21:18:46 +00:00 by gustavosimil · 3 comments
gustavosimil commented 2018-03-19 21:18:46 +00:00 (Migrated from github.com)

I'm trying to read a simple xlsb (Excel binary) file.
When I try to upload the file, I get the following error: Error: Unexpected record 3072.

I have attached the xlsb file and the SheetJs demo can be used to simulate the issue (http://oss.sheetjs.com/).

Book1.zip

I'm trying to read a simple xlsb (Excel binary) file. When I try to upload the file, I get the following error: Error: Unexpected record 3072. I have attached the xlsb file and the SheetJs demo can be used to simulate the issue (http://oss.sheetjs.com/). [Book1.zip](https://github.com/SheetJS/js-xlsx/files/1827007/Book1.zip)
SheetJSDev commented 2018-03-19 21:25:47 +00:00 (Migrated from github.com)

@gustavosimil Thank you very much ! Coincidentally we found this issue earlier today and are preparing for the next release.

The 0x0c00 record type is not specified in MS-XLSB but the best guess is that it represents the underspecified "BrtUid" record. We already reported the spec error to Microsoft: https://social.msdn.microsoft.com/Forums/en-US/880eb3f3-395a-4097-ad01-8e0878d0b436/xlsb-brtuid-record-type-not-defined?forum=os_binaryfile .

We will release 0.12.6 soon with the fix.

@gustavosimil Thank you very much ! Coincidentally we found this issue earlier today and are preparing for the next release. The `0x0c00` record type is not specified in MS-XLSB but the best guess is that it represents the underspecified `"BrtUid"` record. We already reported the spec error to Microsoft: https://social.msdn.microsoft.com/Forums/en-US/880eb3f3-395a-4097-ad01-8e0878d0b436/xlsb-brtuid-record-type-not-defined?forum=os_binaryfile . We will release 0.12.6 soon with the fix.
SheetJSDev commented 2018-03-19 22:48:19 +00:00 (Migrated from github.com)

After pushing out the update, this appears to work. Thanks a lot!

After pushing out the update, this appears to work. Thanks a lot!
gustavosimil commented 2018-03-19 23:42:47 +00:00 (Migrated from github.com)

Yes, it is working now. Thanks!

Yes, it is working now. Thanks!
Sign in to join this conversation.
No Milestone
No Assignees
1 Participants
Notifications
Due Date
The due date is invalid or out of range. Please use the format 'yyyy-mm-dd'.

No due date set.

Dependencies

No dependencies set.

Reference: sheetjs/sheetjs#1044
No description provided.