pyxlsb2 icon indicating copy to clipboard operation
pyxlsb2 copied to clipboard

IndexError: list index out of range

Open Hyperrick opened this issue 4 years ago • 3 comments

Hello,

I want to use pyxlsb2 for reading an .xlsb file. I found some files which doesn't seem to open while other work. Opening with pyxlsb works, pyxlsb2 not.

I have two files:

  1. x.xlsb (works)
  2. y.xlsb (doesn't work)

Source code:

from pyxlsb2 import open_workbook

with open_workbook("y.xlsb") as wb:
    for sheet in wb.sheets:
        print(sheet)

I can't find any difference in the files. Their both are .xlsb. files. I need to see if the files have any hidden worksheets. This is not possible with pyxlsb only with pyxlsb2 as I know so far.

Best regards

Patrick

Hyperrick avatar Feb 26 '21 13:02 Hyperrick

Can you please share the sample files so I can also check?

DissectMalware avatar Feb 28 '21 21:02 DissectMalware

Can you please share the sample files so I can also check?

Sure, i've attached it here (anonymized test_file.zip

).

Hyperrick avatar Mar 01 '21 10:03 Hyperrick

Bump any updates on this? May I can assist with anything?

Hyperrick avatar Mar 20 '21 19:03 Hyperrick