Unsupported ptgList when reading XLSB file #3059

Open
opened 2024-01-18 03:15:05 +00:00 by NenadC2 · 1 comment

Hi!

So, I've stumbled on a problem and can't seem to find anything (anywhere except SheetJS code) related to it.

I am trying to create a small proof of concept of how an XSLB file would be process on the front-end side.
Almost all the files that I've tested it against did work! But I've stumbled upon an xlsb file which cannot be read. The message is just "unsupported ptgList", and nothing else.

I've cleansed the whole file. and there is just one empty sheet left inside, and it does not matter, it cannot be processed.

From looking at the SheetJS code, there is a switch case clause during parsing which throws an exception if this "ptgList" is found. But I am not sure if this can be circumvented in any way? I've tried different reading options, but no luck. Raw, bookSheets, bookProps, and with no success... As I said, it happens even when the file has been cleansed.

I hope there is something I can do...

Best regards!

Hi! So, I've stumbled on a problem and can't seem to find anything (anywhere except SheetJS code) related to it. I am trying to create a small proof of concept of how an XSLB file would be process on the front-end side. Almost all the files that I've tested it against did work! But I've stumbled upon an xlsb file which cannot be read. The message is just "unsupported ptgList", and nothing else. I've cleansed the whole file. and there is just one empty sheet left inside, and it does not matter, it cannot be processed. From looking at the SheetJS code, there is a switch case clause during parsing which throws an exception if this "ptgList" is found. But I am not sure if this can be circumvented in any way? I've tried different reading options, but no luck. Raw, bookSheets, bookProps, and with no success... As I said, it happens even when the file has been cleansed. I hope there is something I can do... Best regards!
Owner

Can you share a sample file?

If you can't, feel free to join our chat and we can go over how to diagnose the error and figure out the correct workaround.

Can you share a sample file? If you can't, feel free to [join our chat](https://discord.gg/sheetjs) and we can go over how to diagnose the error and figure out the correct workaround.
Sign in to join this conversation.
No Milestone
No Assignees
2 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#3059
No description provided.