qt C++将tablewidget中5w行的数据导出为excel文件

需要使用QAxObject库来实现将tablewidget中的数据导出为excel文件。以下是一个简单的示例：

#include <QAxObject>
#include <QFileDialog>
#include <QTableWidget>

void exportToExcel(QTableWidget* tableWidget)
{
    QString fileName = QFileDialog::getSaveFileName(nullptr, "Export to Excel", QString(), "Excel Files (*.xlsx)");
    if (fileName.isEmpty())
        return;
    
    QAxObject* excel = new QAxObject("Excel.Application");
    excel->setProperty("Visible", false);
    QAxObject* workbooks = excel->querySubObject("Workbooks");
    QAxObject* workbook = workbooks->querySubObject("Add");
    QAxObject* sheets = workbook->querySubObject("Worksheets");
    QAxObject* sheet = sheets->querySubObject("Item(int)", 1);

    int rowCount = tableWidget->rowCount();
    int columnCount = tableWidget->columnCount();

    // Write table headers
    for (int col = 0; col < columnCount; ++col)
    {
        QAxObject* cell = sheet->querySubObject("Cells(int, int)", 1, col + 1);
        cell->setProperty("Value", tableWidget->horizontalHeaderItem(col)->text());
        delete cell;
    }

    // Write table data
    for (int row = 0; row < rowCount; ++row)
    {
        for (int col = 0; col < columnCount; ++col)
        {
            QAxObject* cell = sheet->querySubObject("Cells(int, int)", row + 2, col + 1);
            cell->setProperty("Value", tableWidget->item(row, col)->text());
            delete cell;
        }
    }

    // Save and close workbook
    workbook->dynamicCall("SaveAs(const QString&)", fileName);
    workbook->dynamicCall("Close()");
    excel->dynamicCall("Quit()");
    delete sheet;
    delete sheets;
    delete workbook;
    delete workbooks;
    delete excel;
}

在函数中，我们首先弹出一个保存文件对话框，让用户选择导出文件的路径和文件名。然后创建一个Excel应用程序实例，创建一个新的工作簿，获取第一个工作表，然后将tablewidget中的数据逐行写入到Excel工作表中。最后，保存工作簿，关闭Excel应用程序并删除所有QAxObject实例。

注意：该示例仅导出tablewidget中的数据，不包括任何格式或样式。如果需要更复杂的导出，需要进一步修改代码。