Unsupported ptgList when reading XLSB file #3059

New Issue

NenadC2 · 2024-01-18T03:15:05Z

NenadC2 commented

2024-01-18 03:15:05 +00:00

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!

sheetjs commented

2024-01-18 03:22:14 +00:00

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.

sheetjs referenced this issue from a commit

2024-03-20 03:13:34 +00:00

remove flow array comment workarounds

sheetjs closed this issue

2024-03-20 03:13:34 +00:00

Sign in to join this conversation.