qt打开xls文件_Qt中打开excel文件

qt中打开excel文件有两种方法

第一种，用QAxObject,在使用QAxObject，要在.pro文件中添加QT += axcontainer，同时在调用文件中添加#include

打开文件代码如下：

void newExcel(QString &fileName)

{

QAxObject *pApplication = NULL;

QAxObject *pWorkBooks = NULL;

QAxObject *pWorkBook = NULL;

QAxObject *pSheets = NULL;

QAxObject *pSheet = NULL;

pApplication = new QAxObject();

pApplication->setControl("Excel.Application");

pApplication->dynamicCall("SetVisible(bool)", true);

pApplication->setProperty("DisplayAlerts", false);

pWorkBooks = pApplication->querySubObject("Workbooks");

QFile file(fileName);

if (file.exists()) {

pWorkBook = pWorkBooks->querySubObject("Open(const QString &)", fileName);

}

pShe