demo.txt 851 B

12345678910111213141516171819
  1. QXlsx::Document xlsxW;
  2. if (!xlsxW.addSheet(action)) {
  3. LH_WRITE_COMMON(action+"导出,创建表格失败!");
  4. return;
  5. }
  6. // 写入导出列名称,第一行第一列开始
  7. for (int i = 0; i < exportColsName.count(); ++i) {
  8. xlsxW.write(1, i + 1, exportColsName.at(i));
  9. }
  10. // 写入内容信息,第二行第一列开始
  11. for (int i = 0; i < outPutDataList.count(); ++i) {
  12. for (int j = 0; j < outPutDataList.at(i).count(); ++j) {
  13. xlsxW.write(2 + i, j + 1, outPutDataList.at(i).at(j));
  14. }
  15. progressValue = std::ceil(double(i+1)/double(outPutDataList.count())*100.0);
  16. emit setProgressValue(progressValue);
  17. QThread::msleep(10);
  18. };
  19. xlsxW.saveAs(saveFilePath);