search

QtExcel / QXlsx

Excel file(*.xlsx) reader/writer library using Qt 5 or 6. Descendant of QtXlsxWriter.
https://qtexcel.github.io/QXlsx/
MIT License
1.12k stars 352 forks source link

can't detect sheets in some files #164

Open mmjvox opened 3 years ago

mmjvox commented 3 years ago

Hi. Thank you for your efforts.

I can't open and read some xlsx files, But ms excel and libreoffice calc can open and read them. After save again as a new file, Qxlsx can open.

Acording to my logs Qxlsx can't open sheet by name or even can't get sheet names ( .sheetNames() returns emty list ). for example: Datalistsss.xlsx

mmjvox commented 3 years ago

I thought these files are incomplete but many libraries in other languages ​​can open them.

akaDzen commented 3 years ago

I think problem with tags etc. But it is not so.

j2doll commented 3 years ago

Dear @mmjvox

Can I see the full example code that is publicly available? project Please Pull request to https://github.com/JayTwoLab/qxlsx-issues-164

Sorry for the late reply. Because I currently work in a place where there is no internet, I am sometimes exposed to the benefits of civilization.

akaDzen commented 3 years ago

The problem is in the file itself. For example different in _rels/.rels Target="/xl/workbook.xml" - can't open Target="xl/workbook.xml" - can open Next more problems.

akaDzen commented 3 years ago

In which program, library it was done?

mmjvox commented 3 years ago

In which program, library it was done?

I tested with openpyxl in pythone and js-xlsx in javascript and Poi in java js_python_example.zip