IndexError: list index out of range
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:
- x.xlsb (works)
- 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
Can you please share the sample files so I can also check?
Can you please share the sample files so I can also check?
Sure, i've attached it here (anonymized test_file.zip
).
Bump any updates on this? May I can assist with anything?