sheetjs/sheetjs
34
Fork 33
Code Issues 183 Pull Requests 13 Wiki Activity

XLSB Read error #1044

New Issue
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)
Copy Link

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)
Copy Link

@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.
🎉 1
SheetJSDev commented 2018-03-19 22:48:19 +00:00 (Migrated from github.com)
Copy Link

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)
Copy Link

Yes, it is working now. Thanks!

Yes, it is working now. Thanks!
👍 2 🎉 2
Sign in to join this conversation.
No Branch/Tag Specified
Branches Tags
Labels
Clear labels   
DBF

   
Dates

   
Defined Names

   
Features

   
Formula

   
HTML

   
Images

   
Infrastructure

   
Integration

   
International

   
ODS

   
Operations

   
Performance

   
PivotTables

   
Pro

   
Protection

   
Read Bug

   
SSF

   
SYLK

   
Style

   
Write Bug

   
good first issue
No Label
DBF
Dates
Defined Names
Features
Formula
HTML
Images
Infrastructure
Integration
International
ODS
Operations
Performance
PivotTables
Pro
Protection
Read Bug
SSF
SYLK
Style
Write Bug
good first issue
Milestone
Clear milestone
No items
No Milestone
Assignees
Clear assignees
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.
Delete Branch "%!s()"

Deleting a branch is permanent. Although the deleted branch may continue to exist for a short time before it actually gets removed, it CANNOT be undone in most cases. Continue?