QXlsx

Read this in other languages: English, 🇰🇷 한국어

Excel(xlsx) reader/writer library

• 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 5.x)
  • You don't need to use static library or dynamic shared object using QXlsx.

License

• QXlsx is licensed under the MIT License https://opensource.org/licenses/MIT
• QtXlsx License (See Debao Zhang (2014) site) : https://github.com/dbzhang800/QtXlsxWriter
• Qt License (See Qt Company site) : https://www.qt.io/

Sample (Hello excel)

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()) { // failed to load excel 		
	return;
}
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 ...)
qint32 styleNo = cell->styleNumber(); // read cell style number
if ( styleNo >= 0 )
	qDebug() << row << " " << var << " , style:" << styleNo;
else
	qDebug() << row << " " << var;

How to build

• Install Qt 5 from Qt Company (2017-)
• Clone github source code

  git clone https://github.com/j2doll/QXlsx.git

• Build QXlsx project

  cd QXlsx
  qmake QXlsx.pro
  make debug (you may use 'make release'.)

• Build TestExcel (You can use QXlsx.pri. then you need not to build QXlsx.pro. See TestExcel.pro)

  cd TestExcel
  qmake TestExcel.pro
  make

• Run TestExcel

 ./TestExcel

Test environment

Test Environment is below.

• Qt 5.10.1 (MingW/Windows 32bit)
• Qt 5.9.2 (MingW/Windows 32bit)
• Qt 5.9.1 (Visual Studio 2017/Windows 64bit)
• Qt 5.9.1 (Visual Studio 2017/Windows 32bit)
• Qt 5.9.1 (MingW/Windows 32bit)
• Qt 5.9.1 (Ubuntu 16/Linux x64)
• Qt 5.6.0 (MingW/Windows 32bit)
• Qt 5.5.1 (MingW/Windows 32bit)
• Qt 5.5.0 (Ubuntu 17/Linux i686)
• Qt 5.2.0 (Ubuntu 14/Linux x64)
• Qt 5.0.1 (MingW/Windows 32bit)

To Test

The following tests should be performed.

• Microsoft Excel
• Google Spreadsheet
• LibreOffice Calc Spreasheet

Contacts

• https://github.com/j2doll/QXlsx
• 📧 [email protected]
• Hi! I'm j2doll. My native language is not English and my English is not fluent. Please, use EASY English. :-)