QAxObject将Excel表格转换为QVariantList类型

可以使用以下代码将Excel表格转换为QVariantList类型：

QAxObject *excel = new QAxObject("Excel.Application", this);
QAxObject *workbooks = excel->querySubObject("Workbooks");
QAxObject *workbook = workbooks->querySubObject("Open(const QString&)", "path/to/your/excel/file.xlsx");
QAxObject *worksheets = workbook->querySubObject("Worksheets");
QAxObject *worksheet = worksheets->querySubObject("Item(int)", 1); // 1 is the index of the worksheet you want to read
QAxObject *used_range = worksheet->querySubObject("UsedRange");
QVariantList rows;

int row_count = used_range->property("Rows").toInt();
int column_count = used_range->property("Columns").toInt();

for (int row = 1; row <= row_count; row++) {
    QVariantList row_data;
    for (int column = 1; column <= column_count; column++) {
        QAxObject *cell = used_range->querySubObject("Item(int,int)", row, column);
        QVariant cell_value = cell->property("Value");
        row_data.append(cell_value);
        cell->clear();
        delete cell;
    }
    rows.append(row_data);
}

used_range->clear();
worksheet->clear();
worksheets->clear();
workbook->clear();
workbooks->dynamicCall("Close()");
excel->dynamicCall("Quit()");

delete used_range;
delete worksheet;
delete worksheets;
delete workbook;
delete workbooks;
delete excel;

// rows now contains the data from the Excel worksheet as a QVariantList of QVariantLists

这段代码使用QAxObject读取Excel文件，将每一行的数据存储在QVariantList中，最后将所有行的QVariantList存储在一个大的QVariantList中。