QAxObject excel("Excel.Application");
excel.setProperty("Visible",false);
std::shared_ptr<void*> noUsed(NULL, [&](void*)
{
excel.dynamicCall("Quit(void)"); //退出
});
QAxObject *workbooks = excel.querySubObject("WorkBooks");
workbooks->dynamicCall("Add");
QAxObject *workbook = excel.querySubObject("ActiveWorkBook");//获取活动工作簿
std::shared_ptr<void*> noUsed2(NULL, [&](void*)
{
workbook->dynamicCall("Close(Boolean)", false);
});
QAxObject *worksheet = workbook->querySubObject("WorkSheets(int)", 1);
QAxObject* cellObj = worksheet->querySubObject("Cells(int,int)", 1, 1);
cellObj->setProperty("Value2", "姓名");
workbook->dynamicCall("SaveAs(const QString&)", "c:/test.xls");
QT生成excel文件
最新推荐文章于 2024-08-12 21:05:18 发布