QXlsx icon indicating copy to clipboard operation
QXlsx copied to clipboard

Published 20 hours ago • verified publisher icon QtExcel

QXlsx after loading file cannot access cells on some files

Open skatz1971 opened this issue 8 months ago • 1 comments

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 avatar Oct 19 '23 12:10 skatz1971

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.

skatz1971 avatar Oct 19 '23 17:10 skatz1971