Qt读取Excel之QAxObject

QAxObject * excel = NULL;
QAxObject * workbooks = NULL;
QAxObject * workbook = NULL;
excel = new QAxObject(this);
excel -> setControl("Excel.Application");
if (!excel) {
    QMessageBox:: critical(NULL, "错误信息", "EXCEL对象丢失");
    return;
}
excel -> dynamicCall("SetVisible(bool)", false);
workbooks = excel -> querySubObject("WorkBooks");
workbook = workbooks -> querySubObject("Open(const QString&)", path);
QAxObject * worksheet = workbook -> querySubObject("WorkSheets(int)", 1); // 获取第一个工作sheet  
QAxObject * usedrange = worksheet -> querySubObject("UsedRange");//获取该sheet的使用范围对象  
QAxObject * rows = usedrange -> querySubObject("Rows");
QAxObject * columns = usedrange -> querySubObject("Columns");
/*获取行数和列数*/
int intCols = columns -> property("Count").toInt();
int intRows = rows -> property("Count").toInt();
int intRowStart = usedrange -> property("Row").toInt();
int intColStart = usedrange -> property("Column").toInt();
ui.tableWidget -> setRowCount(intRows);
/*获取excel内容*/
for (int i = intRowStart; i < intRowStart + intRows; i++)  //行
{
    for (int j = intColStart; j < intColStart + intCols; j++)
    {
        QAxObject * cell = worksheet -> querySubObject("Cells(int,int)", i, j);
        QString value = cell -> dynamicCall("Value2()").toString();
        setItemValue(i - 1, j - 1, value);
        delete cell;
    }
}
// 关闭excel
workbook -> dynamicCall("Close(Boolean)", true);
excel -> dynamicCall("Quit(void)");
delete excel;
excel = NULL;