Read this in other languages: English, 🇰🇷 한국어
![](https://github.com/j2doll/QXlsx/raw/master/markdown.data/QXlsx-Desktop.png?raw=true)
![](https://raw.githubusercontent.com/LevaYin/QXlsx/master/markdown.data/qxlsx-badge1.png)
- QXlsx is excel file(*.xlsx) reader/writer library.
- Because QtXlsx is no longer supported(2014), I created a new project that is based on QtXlsx. (2017-)
- Development language of QXlsx is C++. (with Qt)
- You don't need to use static library or dynamic shared object using QXlsx.
- See examples
- TestExcel : basic samples based on QtXlsx samples
- HelloAndroid : read xlsx on Android using QML
- Copycat : load xlsx file and display on widget. print xlsx file. (TODO: save xlsx)
1️⃣ Writing excel file(*.xlsx)
QXlsx::Document xlsx;
xlsx.write("A1", "Hello Qt!"); // write "Hello Qt!" to cell(A,1). it's shared string.
xlsx.saveAs("Test.xlsx"); // save the document as 'Test.xlsx'
2️⃣ Reading excel file(*.xlsx)
Document xlsx("Test.xlsx"); // load excel file
if (!xlsx.isLoadPackage()) {
return; // failed to load excel
}
int row = 1; int col = 2;
Cell* cell = xlsx.cellAt(row, col); // get cell pointer. (row is 1. column is 2.)
if ( cell == NULL )
continue; // cell vaule is not set
QVariant var = cell->readValue(); // read cell value (number(double), QDateTime, QString ...)
qDebug() << var; // display value
- The following tests should be performed.
- Microsoft Excel, Google Spreadsheet, LibreOffice Calc Spreasheet
- Unicode test (filename ☁️, filepath ☁️, data value ☀️)
- Develop the encryption function of xlsx
- Hi! I'm j2doll (aka Jay Two). My name is Korean and it is difficult for foreigners to pronounce it. Call me j2doll.
- Leave me a issue. https://github.com/j2doll/QXlsx/issues
- If you are interested in participating in the project, please contact us by issue.
- My native language is not English and my English is not fluent. Please, use EASY English. :-)
![](https://github.com/j2doll/Qxlnt/raw/master/markdown-data/Concept-QXlnt.jpg?raw=true)
- Qxlnt is a helper project that allows xlnt to be used in Qt.
- xlnt is a excellent C++ library for using xlsx Excel files. 👍
- I was looking for a way to make it easy to use in Qt. Of course, cmake is compatible with Qt, but it is not convenient to use. So I created Qxlnt.
![](https://github.com/j2doll/Qlibxlsxwriter/raw/master/markdown.data/logo.png?raw=true)
- Qlibxlsxwriter is a helper project that allows libxlsxwriter to be used in Qt.
- libxlsxwriter is a C library for creating Excel XLSX files.
- Use SimpleXlsxWriter in Qt.
- SimpleXlsxWriter is C++ library for creating XLSX files for MS Excel 2007 and above.