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

Sheet is incorrectly shown as 1x1 #222

Open
Keno opened this issue Jan 30, 2023 · 2 comments
Open

Sheet is incorrectly shown as 1x1 #222

Keno opened this issue Jan 30, 2023 · 2 comments

Comments

@Keno
Copy link

Keno commented Jan 30, 2023

In this Excel file from https://journals.plos.org/ploscompbiol/article?id=10.1371/journal.pcbi.1005697#sec020, all sheets are shown as 1x1, even though they are 17x16:

MUestimates_all_locations_1.xlsx

@felipenoris
Copy link
Owner

@Keno, please see #216 (comment).
The read_worksheet_dimension function reads the dimension tag from the worksheet XML file. This tag is optional (see section 18.3.1.35 - dimension, from the specs). It is not guaranteed that the software writing the workbook fills this attribute, and it may also fill it incorrectly.

In the case of the attached file, the tag reads:

<dimension ref="A1"/>

Hence the result 1x1, as far as I could check your issue.

@felipenoris
Copy link
Owner

felipenoris commented Jan 30, 2023

@Keno, if you just open this file using Microsoft Excel and save it, the tag will be fixed: <dimension ref="A1:P17"/>.

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