QAxObjec创建excel表格并且设置标题和内容然后选择地址保存的程序
时间: 2024-02-15 22:03:47 浏览: 19
以下是使用QAxObject创建Excel表格并设置标题和内容,最后让用户选择保存地址并保存的示例程序:
```c++
#include <QAxObject>
#include <QApplication>
#include <QFileDialog>
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", "内容");
// 选择保存地址并保存文件
QString fileName = QFileDialog::getSaveFileName(NULL, "保存Excel文件", ".", "Excel 文件(*.xlsx)");
workbook->dynamicCall("SaveAs(const QString&)", fileName);
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();
}
```
在这个示例程序中,我们使用了QFileDialog来让用户选择文件保存地址,并使用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)