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
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
|
## How to setup QXlsx project
> *Read this in other languages: [English](HowToSetProject.md), :kr: [한국어](HowToSetProject.ko.md)*
- Here's an easy way to apply QXlsx.
- Describes when to apply to Windows.
- The method of applying it on Linux or Mac is similar, and I will write help if there is an additional request.
- * Hi! I'm j2doll. My native language is not English and my English is not fluent. Please understand. :-)
## Steps to set
:one: Clone source code from github
```sh
git clone https://github.com/j2doll/QXlsx.git
```
<br /><br />
:two: Execute QtCreator
* If you don't know use QtCreator, see Qt Company site. [https://www.qt.io/qt-features-libraries-apis-tools-and-ide/](https://www.qt.io/qt-features-libraries-apis-tools-and-ide/)
<br /><br />
:three: Create your own Qt Project.
<br /><br />
:four: Sample is console application.
<br /><br />
:five: Set project name. Current project name is HelloQXlsx.
<br /><br />
:six: HelloQXlsx project has been created.
<br /><br />
:seven: Current directory for project
<br /><br />
:eight: Copy QXlsx code to your app project
```cmd
xcopy c:\workspace\github\QXlsx\QXlsx c:\workspace\HelloQXlsx /s /e
```
<br /><br />
:nine: Current directories and files for project
<br /><br />
:keycap_ten: Append code for QXlxs library on your Qt project(*.pro)
```qmake
# QXlsx code for Application Qt project
QXLSX_PARENTPATH=./ # current QXlsx path is . (. means curret directory)
QXLSX_HEADERPATH=./header/ # current QXlsx header path is ./header/
QXLSX_SOURCEPATH=./source/ # current QXlsx source path is ./source/
include(./QXlsx.pri)
```
<br /><br />
:one::one: Set heaer files and namespace for sample. Then append hello world code.
```cpp
// main.cpp
#include <QCoreApplication>
#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 a(argc, argv);
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'
return 0;
// return a.exec();
}
```
<br /><br />
:one::two: Build and Run a project
<br /><br />
:one::three: A execute file(*.exe) and a excel file(xlsx) is created.
<br /><br />
|
