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

bug in read specific xlsx data #175

Closed
assalyn opened this issue Dec 28, 2017 · 5 comments
Closed

bug in read specific xlsx data #175

assalyn opened this issue Dec 28, 2017 · 5 comments

Comments

@assalyn
Copy link

assalyn commented Dec 28, 2017

Description
reading error if xlsx file has the data below (tealeg is ok).

e.g. data.xlsx
a 2 row 5 column xlsx file. where col1,2,5 in row2 is empty (write nil just to format code)

INT INT INT INT INT
nil nil a b nil

when xlsx.GetRows, it returns a len(6) row, the 6th cell is "". If all cell has value it's right, return a len(5) row.

@xuri
Copy link
Member

xuri commented Jan 3, 2018

Thanks for your issue. In order to ensure compatibility, excelize will auto-fill all cells according to the largest row and column, and verify the cell contents before reading or writing to the worksheet, the cell contains the empty string will be included in the completion of the range.

@assalyn
Copy link
Author

assalyn commented Jan 4, 2018

@xuri auto-fill is ok. what make me confused is a max 5 column xlsx, return a 6 column data, with all the 6th column "".

@xuri
Copy link
Member

xuri commented Jan 4, 2018

I have tested and it works well, please provides file attachments if you can.

@assalyn
Copy link
Author

assalyn commented Jan 5, 2018

test.xlsx
that's it

@xuri xuri added the confirmed This issue can be reproduced label Jan 5, 2018
@xuri
Copy link
Member

xuri commented Jan 6, 2018

I have fixed it. Please try upgrade library to the last version.

@assalyn assalyn closed this as completed Jan 6, 2018
@xuri xuri removed the confirmed This issue can be reproduced label Jan 6, 2018
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