qt c++获取本地excel文件某一列的数据

使用Qt中的QAxObject类可以操作Excel文件。以下是获取本地Excel文件某一列数据的示例代码：

#include <QAxObject>
#include <QDebug>

void readExcelColumn(QString filePath, QString sheetName, int columnNumber)
{
    //创建Excel应用程序对象
    QAxObject excel("Excel.Application");
    excel.setProperty("Visible", false);

    //打开Excel文件
    QAxObject *workbooks = excel.querySubObject("Workbooks");
    QAxObject *workbook = workbooks->querySubObject("Open(const QString&)", filePath);

    //获取工作表
    QAxObject *sheets = workbook->querySubObject("Worksheets");
    QAxObject *sheet = sheets->querySubObject("Item(const QString&)", sheetName);

    //获取列数据
    QAxObject *usedRange = sheet->querySubObject("UsedRange");
    QAxObject *column = usedRange->querySubObject("Columns(int)", columnNumber);
    QVariant columnData = column->dynamicCall("Value");

    //转换为QStringList
    QStringList dataList;
    for(int i = 1; i <= columnData.toList().size(); i++)
    {
        QVariant data = columnData.toList().at(i-1).toList().at(0);
        dataList << data.toString();
    }
    qDebug() << dataList;

    //释放资源
    delete column;
    delete usedRange;
    delete sheet;
    delete sheets;
    workbook->dynamicCall("Close()");
    delete workbook;
    delete workbooks;
    excel.dynamicCall("Quit()");
}

int main(int argc, char *argv[])
{
    QApplication a(argc, argv);

    QString filePath = "D:/test.xlsx";
    QString sheetName = "Sheet1";
    int columnNumber = 1;
    readExcelColumn(filePath, sheetName, columnNumber);

    return a.exec();
}

其中，filePath是Excel文件的路径，sheetName是工作表名称，columnNumber是要获取数据的列编号，从1开始。函数中使用QVariant存储Excel中的数据，然后转换为QStringList进行输出。最后释放资源，关闭Excel文件。