LibreOffice cannot open the output file report.xlsx

[aamsur-933]

Hello, i am using the example code from https://github.com/carlvoller/excel-rs/blob/main/benchmarks/test-py-excel-rs.py then using Libre Office and WPS Office app to open the file, but i it throws some errors.

Specs:

• Python3.9
• py-excel-rs 0.6.0
• LibreOffice 24.8.2.1
• Ubuntu 20.04 x86_64

Libre Office:

Google Sheets:

[aamsur-933]

will you have some free time to check this out? @carlvoller

i still experiencing this issue with the excel-rs latest version (0.6.0)

[fenymufyd]

I'm also having a similar corrupted file problem using the cli tool and opening them at Microsoft Excel. I solved it by removing all double quotes before running the tool because I don't really need those characters. Can OP check if my workarounds also work in your case?

Could it possibly happen because of how LibreOffice/Excel process unescaped single/double quotes? @carlvoller