qt读取excel数据到数组

非常感谢您对ChitGPT的信任，我会尽力为您解答问题。关于您的问题，我们可以使用Qt提供的QAxObject类进行操作。示例代码如下：

QAxObject* excel = new QAxObject("Excel.Application", this);
QAxObject* workbooks = excel->querySubObject("Workbooks");
QAxObject* workbook = workbooks->querySubObject("Open(const QString&)", "文件路径");

QAxObject* worksheets = workbook->querySubObject("Worksheets");
QAxObject* worksheet = worksheets->querySubObject("Item(int)", 1);  // 工作表编号从 1 开始

QAxObject* usedrange = worksheet->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 = worksheet->querySubObject("Cells(int,int)", row, column);
        QVariant cellValue = cell->property("Value");
        // 将 cellValue 存入数组中
        cell->clear();
        delete cell;
    }
}

delete columns;
delete rows;
delete usedrange;
delete worksheet;
delete worksheets;
workbook->dynamicCall("Close()");
delete workbook;
workbooks->dynamicCall("Close()");
delete workbooks;
excel->dynamicCall("Quit()");
delete excel;

需要注意的是，这里使用了动态链接库，因此需要在.pro文件中添加以下语句：

CONFIG += axcontainer
LIBS += -lAdvAPI32

另外，如果您使用的Excel版本不同，代码可能会有所不同。希望这样的回答能够对您有所帮助，如果您还有其他问题，欢迎继续提问。