利用QAxObject类调用EXCEL组件,将数据保存为EXCEL格式文件。
核心代码:
QAxObject *excel;
QAxObject *workBooks;
QAxObject *workBook;
QAxObject *workSheets;
QAxObject *workSheet;
int n;
//创建Excel Application对象
excel = new QAxObject("Excel.Application");
//调试true,观察运行情况。发布false,让程序后台运行
excel->setProperty("Visible", true);
excel->setProperty("Caption", "DataToExcel");
//获取WorkBooks对象
workBooks = excel->querySubObject("WorkBooks");
//添加工作簿,并获取对象
workBook=workBooks->querySubObject("Add");
//获取所有工作表
workSheets = workBook