mirror of
https://github.com/QtExcel/QXlsx.git
synced 2025-01-16 04:42:53 +08:00
db608768a3
This project has no standard on coding style, some files use tab, others space, and new Merge Requests usually break the current formatting with this clang-format we can easy this.
73 lines
1.9 KiB
C++
73 lines
1.9 KiB
C++
// main.cpp
|
|
// QXlsx // MIT License // https://github.com/j2doll/QXlsx
|
|
//
|
|
|
|
#include <iostream>
|
|
|
|
#include <QCoreApplication>
|
|
#include <QDebug>
|
|
#include <QDir>
|
|
#include <QVariant>
|
|
#include <QtCore>
|
|
#include <QtGlobal>
|
|
using namespace std;
|
|
|
|
// [0] include QXlsx headers
|
|
#include "xlsxcellrange.h"
|
|
#include "xlsxchart.h"
|
|
#include "xlsxchartsheet.h"
|
|
#include "xlsxdocument.h"
|
|
#include "xlsxrichstring.h"
|
|
#include "xlsxworkbook.h"
|
|
using namespace QXlsx;
|
|
|
|
int main(int argc, char *argv[])
|
|
{
|
|
QCoreApplication app(argc, argv);
|
|
|
|
//--------------------------------------
|
|
// [1] Writing excel file(*.xlsx)
|
|
|
|
QXlsx::Document xlsxW;
|
|
|
|
int row = 1;
|
|
int col = 1; //
|
|
|
|
// xlsxW.write("A1", "Hello Qt!"); // write "Hello Qt!" to cell(A,1). it's shared string.
|
|
QVariant writeValue = QString("Hello Qt!");
|
|
xlsxW.write(row, col, writeValue);
|
|
|
|
if (xlsxW.saveAs("Test.xlsx")) // save the document as 'Test.xlsx'
|
|
{
|
|
qDebug() << "[debug] success to write xlsx file";
|
|
} else {
|
|
qDebug() << "[debug][error] failed to write xlsx file";
|
|
exit(-1);
|
|
}
|
|
|
|
qDebug() << "[debug] current directory is " << QDir::currentPath();
|
|
|
|
//--------------------------------------
|
|
// [2] Reading excel file(*.xlsx)
|
|
|
|
Document xlsxR("Test.xlsx");
|
|
if (xlsxR.load()) // load excel file
|
|
{
|
|
qDebug() << "[debug] success to load xlsx 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() << "[debug] cell(1,1) is " << var; // Display value. It is 'Hello Qt!'.
|
|
} else {
|
|
qDebug() << "[debug][error] cell(1,1) is not set.";
|
|
exit(-2);
|
|
}
|
|
} else {
|
|
qDebug() << "[debug][error] failed to load xlsx file.";
|
|
}
|
|
|
|
return 0;
|
|
}
|