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

QXlsx after loading file cannot access cells on some files #310

Open
skatz1971 opened this issue Oct 19, 2023 · 1 comment
Open

QXlsx after loading file cannot access cells on some files #310

skatz1971 opened this issue Oct 19, 2023 · 1 comment

Comments

@skatz1971
Copy link

I have some public excel files (possibly created by openpyxl).
Document::load returns true on them.
But after that dimension is in default state (negative values) and CellAt(row,col) returns NULL;
If i resave file in Excel (with no changes), it opens normally.
Example file:
SGAREA100URI_2023_10_16.xlsx

Can any one make suggestion how to open them.
(Files are downloaded from government site and I need to process them programmatically without manual interventions.)

@skatz1971
Copy link
Author

skatz1971 commented Oct 19, 2023

I Found problem - in /xl/_rels/workbook.xml.rels sheet relationship with Target="/xl/worksheets/sheet1.xml"
reader considers path as releative and produces "xl/xl/worksheets/sheet1.xml", which cannot be found.
As I see xlxs reader never considers absolute paths.

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