QXlsx
QXlsx copied to clipboard
QtExcel
Excel file(*.xlsx) reader/writer library using Qt 5 or 6. Descendant of QtXlsxWriter.
When editing an existing Excel file with QXlsx, where there are no modified cells, the original formula is lost and "#DIV/0!" appears. 当使用QXlsx编辑现有Excel文件，其中没有修改的单元格，原始公式将丢失，并出现“#DIV/0!”
Hello Jay Two, My name is V. [remove personal Info] When the content contains Chinese, the automatic column width function is not ideal. The function I am using is： _autosizeColumnWidth(void);_...
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...
Bonjour, J'essaie d'utiliser QXlsx avec des macros. Pour cela, j'enregistre mon classeur avec : `classeur.saveAs("mon_classeur.xlsm")` ou `classeur.saveAs("mon_classeur.xltm")` Mais en essayant d'ouvrir le classeur, j'obtiens toujours : "_impossible d'ouvrir le fichier...
When reading data in excel, I read the value of 0.0524. No matter what format is set in excel, the data obtained is 5.2400000000000002E-2. the code is : QXlsx::Document xlsx("book1.xlsx");...
https://github.com/QtExcel/QXlsx/blob/499901003f02da34f7fbc1ec214a24e4dc128b74/QXlsx/source/xlsxzipreader.cpp#L28 At this moment code `Document xlsxR("table.xls");` produce warning _QZip: not a zip file!_ I suggest add extra message. 1) Someone try open .xls file 2) Program write "warning xls...
The code below doesn't work properly: **sup** and **sub** tags are ignored ``` QXlsx::Document xlsx; QXlsx::RichString rich; rich.setHtml( "m2") xlsx.write("A1", rich); xlsx.saveAs("richtext1.xlsx"); ```
  我使用Python pandas to_excel 生成的表格 使用WPS正常打开 可能是兼容问题吗 我做了一些修改 
The mysql database data size is 40909 rows and 50 colums, when use the code to export these data as blew the computer memery will be reached to 800Mb. the...
When can the Excel protected (password) feature be added? 1、Protected Worksheet? 2、Protected Workbook?
