12345678910111213141516171819 |
- QXlsx::Document xlsxW;
- if (!xlsxW.addSheet(action)) {
- LH_WRITE_COMMON(action+"导出,创建表格失败!");
- return;
- }
- // 写入导出列名称,第一行第一列开始
- for (int i = 0; i < exportColsName.count(); ++i) {
- xlsxW.write(1, i + 1, exportColsName.at(i));
- }
- // 写入内容信息,第二行第一列开始
- for (int i = 0; i < outPutDataList.count(); ++i) {
- for (int j = 0; j < outPutDataList.at(i).count(); ++j) {
- xlsxW.write(2 + i, j + 1, outPutDataList.at(i).at(j));
- }
- progressValue = std::ceil(double(i+1)/double(outPutDataList.count())*100.0);
- emit setProgressValue(progressValue);
- QThread::msleep(10);
- };
- xlsxW.saveAs(saveFilePath);
|