qt读取excel表格中的数据

在Qt中，可以使用QAxObject类来读取Excel表格中的数据。下面是一个简单的示例代码：

#include <QAxObject>
#include <QDebug>

void readExcelData()
{
    QAxObject* excel = new QAxObject("Excel.Application", nullptr);
    excel->setProperty("Visible", false);

    QAxObject* workbooks = excel->querySubObject("Workbooks");
    QAxObject* workbook = workbooks->querySubObject("Open(const QString&)", "path/to/your/excel/file.xlsx");

    QAxObject* sheets = workbook->querySubObject("Worksheets");
    QAxObject* sheet = sheets->querySubObject("Item(int)", 1); // 读取第一个工作表

    QAxObject* usedRange = sheet->querySubObject("UsedRange");
    QAxObject* rows = usedRange->querySubObject("Rows");
    QAxObject* columns = usedRange->querySubObject("Columns");

    int rowCount = rows->property("Count").toInt();
    int columnCount = columns->property("Count").toInt();

    for (int row = 1; row <= rowCount; ++row) {
        for (int column = 1; column <= columnCount; ++column) {
            QAxObject* cell = sheet->querySubObject("Cells(int,int)", row, column);
            QVariant value = cell->property("Value");
            qDebug() << "Cell(" << row << "," << column << "):" << value.toString();
            cell->clear();
            delete cell;
        }
    }

    delete rows;
    delete columns;
    delete usedRange;
    delete sheet;
    delete sheets;
    workbook->dynamicCall("Close()");
    delete workbook;
    workbooks->dynamicCall("Close()");
    delete workbooks;
    excel->dynamicCall("Quit()");
    delete excel;
}

int main(int argc, char *argv[])
{
    QCoreApplication a(argc, argv);
    readExcelData();
    return a.exec();
}

上述代码使用了Qt的ActiveX模块，需要在.pro文件中添加`QT += axcontainer`来启用该模块。在代码中，首先创建了Excel应用程序对象，然后打开指定的Excel文件。接着获取第一个工作表，并通过UsedRange属性获取表格的行数和列数。最后使用Cells方法遍历每个单元格，并读取其值。

请注意，使用QAxObject类需要安装Microsoft Office软件，并且需要在项目的.pro文件中添加`LIBS += -lole32`来链接OLE库。