解决QtQAxBase: Error calling IDispatch member SaveAs: Exception thrown by server

最新推荐文章于 2023-09-21 11:35:45 发布

豆浆D油条

最新推荐文章于 2023-09-21 11:35:45 发布

阅读量6.2k

点赞数

分类专栏： QT excel

本文链接：https://blog.csdn.net/doujianyoutiao/article/details/107349304

版权

QT 同时被 2 个专栏收录

13 篇文章 1 订阅

订阅专栏

excel

1 篇文章 0 订阅

订阅专栏

workbook->dynamicCall(“SaveAs (const QString &)”, file);file是不能用’/’，如果调QCoreApplication::applicationDirPath()等QT的API获取路径的，都需要调replace(’/’, ‘\’)把’/‘替换成’\’，或者自行把’/‘替换成’\’。

注：workbook的来源

QAxObject *excel = nullptr;   
QAxObject *workbooks = nullptr
QAxObject *workbook = nullptr;
excel = new QAxObject("Excel.Application");

1、通过ActiveWorkBook新建工作簿

workbook = excel->querySubObject("ActiveWorkBook");

2、通过Open打开工作簿

workbooks = excel->querySubObject("WorkBooks");
//workbook  = workbooks->querySubObject("Open(QString&)", path);或
workbook = workbooks->querySubObject("Open(QString, QVariant)",sXlsFile,QVariant(0));