请问Qt通过COM组件如何再EXCEL中新建和删除表？

[weixin_38098470]

excel = new QAxObject( "Excel.Application",this );    excel->dynamicCall("SetVisible(bool)",true);    workbooks = excel->querySubObject( "Workbooks" );    workbook = workbooks->querySubObject( "Open(const QString&)",                                                     "d:\\mysheet.xls" );    sheets = workbook->querySubObject( "Sheets" );    StatSheet = sheets->querySubObject( "Item(const QVariant&)",                                                    QVariant(QString::fromLocal8Bit("sheet1"))                                                  );    StatSheet->dynamicCall( "Select()" );        请问如何执行删除sheet1，新建sheet1的操作？

[weixin_38112450]

你在excel中找菜单中的开启宏录制功能，然后你进行相关的操作（添加、删除工作表），然后停止宏录制，然后你看看对应的VBA脚本，就知道怎么用了。