You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
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.)
The text was updated successfully, but these errors were encountered:
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.
hxbb00
added a commit
to hxbb00/QXlsx
that referenced
this issue
Jul 29, 2024
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.)
The text was updated successfully, but these errors were encountered: