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
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
|
// main.cpp
#include <iostream>
#include <QtGlobal>
#include <QObject>
#include <QVector>
#include <QList>
#include "recurse.hpp"
#include "xlsxdocument.h"
#include "xlsxchartsheet.h"
#include "xlsxcellrange.h"
#include "xlsxchart.h"
#include "xlsxrichstring.h"
#include "xlsxworkbook.h"
#include "xlsxabstractsheet.h"
#include "xlsxcelllocation.h"
#include "xlsxcell.h"
using namespace QXlsx;
QString getHtml(QString strFilename);
bool loadXlsx(QString fileName, QString& strHtml);
QString g_htmlDoc;
int main(int argc, char *argv[])
{
g_htmlDoc = getHtml(":/test.xlsx"); // convert from xlsx to html
Recurse::Application app(argc, argv);
app.use([](auto &ctx)
{
ctx.response.send(g_htmlDoc);
});
quint16 listenPort = 3001; // default port
auto result = app.listen( listenPort );
if ( result.error() )
{
qDebug() << "error upon listening:" << result.lastError();
return (-1);
}
std::cout << " listening port: " << listenPort << std::endl;
return 0;
}
QString getHtml(QString strFilename)
{
QString ret;
ret = ret + QString("<html>\n");
ret = ret + QString("<head>\n");
ret = ret + QString("<title>") + strFilename + QString("</title>\n");
ret = ret + QString("<meta http-equiv='Content-Type' content='text/html;charset=UTF-8'>\n" );
ret = ret + QString("</head>\n");
ret = ret + QString("<body>\n");
QString strTableStyle = \
"<style>\n"\
" table { border-collapse: collapse; } \n"\
" td, th { border: 1px solid black; } \n"\
"</style>\n";
ret = ret + strTableStyle;
if (!loadXlsx(strFilename, ret))
return QString("");
ret = ret + QString("</body>\n");
ret = ret + QString("</html>\n");
qDebug() << ret << "\n";
return ret;
}
bool loadXlsx(QString fileName, QString& strHtml)
{
// tried to load xlsx using temporary document
QXlsx::Document xlsxTmp( fileName );
if ( !xlsxTmp.isLoadPackage() )
{
return false; // failed to load
}
// load new xlsx using new document
QXlsx::Document xlsxDoc( fileName );
xlsxDoc.isLoadPackage();
int sheetIndexNumber = 0;
foreach( QString curretnSheetName, xlsxDoc.sheetNames() )
{
QXlsx::AbstractSheet* currentSheet = xlsxDoc.sheet( curretnSheetName );
if ( NULL == currentSheet )
continue;
// get full cells of sheet
int maxRow = -1;
int maxCol = -1;
currentSheet->workbook()->setActiveSheet( sheetIndexNumber );
Worksheet* wsheet = (Worksheet*) currentSheet->workbook()->activeSheet();
if ( NULL == wsheet )
continue;
QString strSheetName = wsheet->sheetName(); // sheet name
strHtml = strHtml + QString("<b>") + strSheetName + QString("</b><br>\n"); // UTF-8
strHtml = strHtml + QString("<table>");
QVector<CellLocation> clList = wsheet->getFullCells( &maxRow, &maxCol );
QVector< QVector<QString> > cellValues;
for (int rc = 0; rc < maxRow; rc++)
{
QVector<QString> tempValue;
for (int cc = 0; cc < maxCol; cc++)
{
tempValue.push_back(QString(""));
}
cellValues.push_back(tempValue);
}
for ( int ic = 0; ic < clList.size(); ++ic )
{
// cell location
CellLocation cl = clList.at(ic);
int row = cl.row - 1;
int col = cl.col - 1;
QSharedPointer<Cell> ptrCell = cl.cell; // cell pointer
// value of cell
QVariant var = cl.cell.data()->value();
QString str = var.toString();
cellValues[row][col] = str;
}
QString strTableRecord;
for (int rc = 0; rc < maxRow; rc++)
{
strTableRecord = strTableRecord + QString("<tr>");
for (int cc = 0; cc < maxCol; cc++)
{
QString strTemp = cellValues[rc][cc];
strTableRecord = strTableRecord + QString("<td>");
strTableRecord = strTableRecord + strTemp; // UTF-8
strTableRecord = strTableRecord + QString("</td>");
}
strTableRecord = strTableRecord + QString("</tr>\n");
}
strHtml = strHtml + strTableRecord;
strHtml = strHtml + QString("</table>\n");
sheetIndexNumber++;
}
return true;
}
|
