QXlsx Examples
HelloWorld
- Hello world example
// main.cpp
#include <QtGlobal>
#include <QCoreApplication>
#include <QtCore>
#include <QVariant>
#include <QDebug>
#include <iostream>
using namespace std;
// [0] include QXlsx headers
#include "xlsxdocument.h"
#include "xlsxchartsheet.h"
#include "xlsxcellrange.h"
#include "xlsxchart.h"
#include "xlsxrichstring.h"
#include "xlsxworkbook.h"
using namespace QXlsx;
int main(int argc, char *argv[])
{
QCoreApplication app(argc, argv);
int row = 1; int col = 1;
// [1] Writing excel file(*.xlsx)
QXlsx::Document xlsxW;
QVariant writeValue = QString("Hello Qt!");
xlsxW.write(row, col, writeValue); // write "Hello Qt!" to cell(A,1).
xlsxW.saveAs("Test.xlsx"); // save the document as 'Test.xlsx'
// [2] Reading excel file(*.xlsx)
Document xlsxR("Test.xlsx");
if (xlsxR.load()) // load excel file
{
Cell* cell = xlsxR.cellAt(row, col); // get cell pointer.
if ( cell != NULL )
{
QVariant var = cell->readValue(); // read cell value (number(double), QDateTime, QString ...)
qDebug() << var; // display value. it is 'Hello Qt!'.
}
}
return 0;
}
TestExcel
- Basic examples (based on QtXlsx examples)
HelloAndroid
-
See ‘HelloAndroid’ example using QML and native C++.
- Qt 5.11.1 / gcc 4.9 / QtCreator 4.6.2
- Android x86 (using Emulator <Android Oreo / API 26>)
- Android Studio 3.1.3 (Android NDK 17.1)
WebServer
- Load xlsx file and display on Web.
- Connect to
http://127.0.0.1:3001
- Connect to
- C++ 14(17) is required. Old compilers is not supported.
ShowConsole
- Load xlsx file and display in console.
- [Usage] ShowConsole *.xlsx
- C++ 11 is required. Old compilers is not supported.
ReadColor
- Read cell color
XlsxFactory
- Load xlsx file and display on Qt widgets.
- Moved to personal repository for advanced app.
- https://j2doll.tistory.com/654
- The source code of this program cannot be released because it contains a commercial license.