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

Merged cells treated differently in .ods and .xls files #193

Open
pedrohasantiago opened this issue Feb 10, 2020 · 0 comments
Open

Merged cells treated differently in .ods and .xls files #193

pedrohasantiago opened this issue Feb 10, 2020 · 0 comments

Comments

@pedrohasantiago
Copy link

I'm using the get_data() function from pyexcel_xls and pyexcel_odsr with .xls and .ods tables similar to this:

One Two Three Four
One Two and three Four

pyexcel_xls.get_data() reads the table as follows, with an empty string in the second row:

[['One', 'Two', 'Three', 'Four']
['One', 'Two and three', '', 'Four']]

On the other hand, pyexcel_ods.get_data() reads the table as follows, with no empty string:

[['One', 'Two', 'Three', 'Four']
['One', 'Two and three', 'Four']]

ie, there is no way to acknowledge the existence of a merged cell in the second row.

Is there any way to make both libraries behave the same way?

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

1 participant