QAxObjec创建excel表格并且设置标题和内容然后保存的程序
时间: 2024-02-15 07:03:43 浏览: 17
以下是使用QAxObject创建Excel表格并设置标题和内容,最后保存的示例程序:
```c++
#include <QAxObject>
#include <QApplication>
int main(int argc, char *argv[])
{
QApplication a(argc, argv);
QAxObject *excel = new QAxObject("Excel.Application");
excel->setProperty("Visible", false);
QAxObject *workbooks = excel->querySubObject("Workbooks");
QAxObject *workbook = workbooks->querySubObject("Add()");
QAxObject *worksheets = workbook->querySubObject("Worksheets()");
QAxObject *worksheet = worksheets->querySubObject("Item(int)", 1);
// 设置标题
QAxObject *cell_1 = worksheet->querySubObject("Cells(int,int)", 1, 1);
cell_1->setProperty("Value", "标题");
// 设置内容
QAxObject *cell_2 = worksheet->querySubObject("Cells(int,int)", 2, 1);
cell_2->setProperty("Value", "内容");
// 保存文件
workbook->dynamicCall("SaveAs(const QString&)", "test.xlsx");
workbook->dynamicCall("Close()");
excel->dynamicCall("Quit()");
delete cell_1;
delete cell_2;
delete worksheet;
delete worksheets;
delete workbook;
delete workbooks;
delete excel;
return a.exec();
}
```
在这个示例程序中,我们使用了QAxObject来创建Excel应用程序,并创建一个新的工作簿和工作表。然后,我们使用querySubObject()方法获取单元格对象,并使用setProperty()方法设置单元格的值。最后,我们使用dynamicCall()方法保存并关闭工作簿,退出Excel应用程序。
相关推荐
![](https://csdnimg.cn/download_wenku/file_type_ask_c1.png)
![](https://csdnimg.cn/download_wenku/file_type_ask_c1.png)
![](https://csdnimg.cn/download_wenku/file_type_ask_c1.png)
![](https://csdnimg.cn/download_wenku/file_type_ask_c1.png)
![](https://csdnimg.cn/download_wenku/file_type_ask_c1.png)
![zip](https://img-home.csdnimg.cn/images/20210720083736.png)
![zip](https://img-home.csdnimg.cn/images/20210720083736.png)
![zip](https://img-home.csdnimg.cn/images/20210720083736.png)
![zip](https://img-home.csdnimg.cn/images/20210720083736.png)