16,201
社区成员
发帖
与我相关
我的任务
分享
QAxObject* pExcelApp = new QAxObject("Excel.Application"); // 创建EXCEL对象,启动Excel.exe进程
if (NULL == pExcelApp)
{
OnShowTempMsg("Excel Program Is Not Installed", 5000);
return;
}
pExcelApp->setProperty("DisplayAlerts", false); // 保存时不提示覆盖
//pExcelApp->setProperty("Visible", true); // 操作时可以看见EXCEL窗口,调试用
// 打开测试报告模板
QString strFilePath = QCoreApplication::applicationDirPath() + "/Report/TestReportTemplate.xlsx";
QAxObject* pWorkBooks = pExcelApp->querySubObject("WorkBooks");
pWorkBooks->dynamicCall("Open(const QString&)", strFilePath);
QAxObject* pWorkBook = pExcelApp->querySubObject("ActiveWorkBook");
if (NULL == pWorkBook)
{
OnShowTempMsg("Can Not Open TestReportTemplate.xlsx File, Path Is " + strFilePath, 5000);
return;
}