Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Unable to get data when the first column is empty #3

Closed
Paliking opened this issue Nov 23, 2017 · 3 comments
Closed

Unable to get data when the first column is empty #3

Paliking opened this issue Nov 23, 2017 · 3 comments

Comments

@Paliking
Copy link

Hi,
thanks for the library.
It works well when the first column is not empty.

INPUT

wb = pyxlsb.open_workbook(xlsb_file)
sheet = wb.get_sheet(sheet_name)
print(sheet.dimension)
for row in sheet.rows():
    do something

OUTPUT

dimension(r=0, c=1, h=3, w=2)
File "...packages\pyxlsb\worksheet.py", line 71, in rows
    row[item[1].c] = Cell._make([row_num, item[1].c, item[1].v])
IndexError: list assignment index out of range

I'm using 64-bit python 3 on Windows 10.
pyxlsb v1.0.2
Do you have the same issue?
Thank you

@willtrnr
Copy link
Owner

willtrnr commented Nov 23, 2017

Oh that's interesting, it seems I never had a case with an empty first column.

With those dimension numbers I assume you have columns B and C filled, right?

@willtrnr
Copy link
Owner

Fixed in 1.0.3

@Paliking
Copy link
Author

yes, exactly.
thx for your fast fix.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

2 participants