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

Empty cells are ignored #17

Closed
sirio81 opened this issue Sep 30, 2020 · 3 comments
Closed

Empty cells are ignored #17

sirio81 opened this issue Sep 30, 2020 · 3 comments

Comments

@sirio81
Copy link

sirio81 commented Sep 30, 2020

Hi, the get_data() method returns a list for each row.
The list contains only the values of non empty cells.
When parsing a table it may be necessary to know if a cell was empty.
I suggest to add and option the get_data() method so to include an empty string (or None value) for empty cells into the returned lists.

@chfw
Copy link
Member

chfw commented Sep 30, 2020

yes, the trailing empty cells are ignored: https://github.com/pyexcel/pyexcel-io/blob/dev/pyexcel_io/sheet.py#L88. but an option to toggle this behaviour can be added in pyexcel-io v0.6.0, the next release.

@sirio81
Copy link
Author

sirio81 commented Sep 30, 2020

Look forward for it!

@chfw
Copy link
Member

chfw commented Oct 8, 2020

pyexcel-io 0.6.0 was released. Please give it a go!

@kaittodesk has help verify the fix.

pyexcel/pyexcel#228

@chfw chfw closed this as completed Oct 8, 2020
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