1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
|
# QXlsx Examples
## [HelloWorld](https://github.com/QtExcel/QXlsx/tree/master/HelloWorld)
- Hello world example
```cpp
// 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);
// [1] Writing excel file(*.xlsx)
QXlsx::Document xlsxW;
xlsxW.write("A1", "Hello Qt!"); // write "Hello Qt!" to cell(A,1). it's shared string.
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
{
int row = 1; int col = 1;
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](https://github.com/QtExcel/QXlsx/tree/master/TestExcel)
- :zap: Basic examples (based on QtXlsx examples)
- calendar
- chart
- chart sheet
- data validation
- demo
- document property
- extract data
- formula
- hyperlink
- image
- merge cells
- number format
- page margins
- read style
- richtext
- row column
- style
- worksheet operations
## [HelloAndroid](https://github.com/QtExcel/QXlsx/tree/master/HelloAndroid)
- See 'HelloAndroid' example using QML and native C++.
- Qt 5.11.1 / QtCreator 4.6.2 / gcc 4.9 / Android x86 (using Emulator [Android Oreo]) / Android Studio 3.1.3 (Android NDK 17.1)
## [WebServer](https://github.com/QtExcel/QXlsx/tree/master/WebServer)
- Load xlsx file and display on Web.
- Connect to `http://127.0.0.1:3001`
- C++ 14 is required. Old compilers is not supported.(based on recurse)
## [ShowConsole](https://github.com/QtExcel/QXlsx/tree/master/ShowConsole)
- Load xlsx file and display in console.
- [Usage] ShowConsole *.xlsx
- C++ 11 is required. Old compilers is not supported. (based on libfort)
## [ReadColor](https://github.com/QtExcel/QXlsx/tree/master/ReadColor)
- Read cell color
## XlsxFactory
- Load xlsx file and display on Qt widgets.
- Moved to personal repository for advanced app.
|
