// .pro

INCLUDEPATH += $$PWD/3rd/openxlsx
LIBS += -L$$PWD/3rd -lOpenXLSX

// .h

#include "OpenXLSX.hpp"
using namespace OpenXLSX;

// .cpp

// 創建Excel文檔
XLDocument doc;
doc.create("./m_xlsx.xlsx", XLForceOverwrite);
auto wks = doc.workbook().worksheet("Sheet1");

wks.cell("A1").value() = 3.14159265358979323846;
wks.cell("B1").value() = 42;
wks.cell("C1").value() = std::string("護具");
wks.cell("D1").value() = QString("74946hdiaohdjoajdodjsaopdjapjdapojdpoasjda").toStdString();


QList<QString> str_list = {"123","123", "456","456", "sada", "sadadsasa","121212asa"};
for(int i=1;i<str_list.size();i++)
{
    wks.cell(i,1).value() = str_list.at(i).toStdString();
}

// 保存Excel文件
doc.save();
doc.close();