封装一个Qt C++类,用于操作Excel表格,在Qt中操作excel需在.pro中增加CONFIG+=qaxcontainer配置。
1、打开Excel:objExcel = new QAxObject(“Excel.Application”);
2、创建工作表:workSheet->dynamicCall(“Add”);
3、打开工作表:workExcel->dynamicCall(“Open (const QString&)”, file);
4、建立表头:pExcelCell->setProperty(“Value”, QVariant(strTemp));
5、写入数据:pExcelCell->setProperty(“Value”, QVariant(sLTestMsg.at(i-1)));
6、保存:workExcel->dynamicCall(“SaveAs (const QString&)”, saveFile);
7、退出:objExcel->dynamicCall(“Quit (void)”).
/* Copyrignt (C). 2013-2016. TECHNOLOGIES LTD. */
/**
*Copyrignt (C). 2013-2016. TECHNOLOGIES LTD.
*@file qexcel.h
*@brief Operate Excel
*@author lichenglong
*@version 1.0
*@date 2013/8/10
*@History:
/* Copyrignt (C). 2013-2016. LTD. */
/**
*Copyrignt (C). 2013-2016. LTD.
*@file qexcel.cpp
*@brief Operate Excel
*@author lichenglong
*@version 1.0
*@date 2013/8/10
*@History: