mysql通过qt导出excel文件

#include <QCoreApplication>
#include <QSqlDatabase>
#include <QSqlQuery>
#include <QSqlError>
#include <QFile>
#include <QTextStream>
#include <QAxObject>

void exportToExcel(const QString &filePath) {
    QSqlDatabase db = QSqlDatabase::addDatabase("QMYSQL");
    db.setHostName("localhost");
    db.setDatabaseName("your_database");
    db.setUserName("your_username");
    db.setPassword("your_password");

    if (!db.open()) {
        qDebug() << "Database error:" << db.lastError().text();
        return;
    }

    QSqlQuery query("SELECT * FROM your_table");
    if (!query.exec()) {
        qDebug() << "Query error:" << query.lastError().text();
        return;
    }

    QFile file(filePath);
    if (!file.open(QIODevice::WriteOnly | QIODevice::Text)) {
        qDebug() << "File error:" << file.errorString();
        return;
    }

    QTextStream out(&file);
    out << "Column1,Column2,Column3\n"; // 根据实际列名修改

    while (query.next()) {
        out << query.value(0).toString() << ","
            << query.value(1).toString() << ","
            << query.value(2).toString() << "\n"; // 根据实际列数修改
    }

    file.close();

    // 使用QAxObject创建Excel文件
    QAxObject *excel = new QAxObject("Excel.Application", this);
    excel->setProperty("Visible", false);
    QAxObject *workbooks = excel->querySubObject("Workbooks");
    QAxObject *workbook = workbooks->querySubObject("Add");
    QAxObject *sheets = workbook->querySubObject("Sheets");
    QAxObject *sheet = sheets->querySubObject("Item(1)");

    QFile excelFile(filePath + ".xlsx");
    if (!excelFile.open(QIODevice::WriteOnly)) {
        qDebug() << "Excel file error:" << excelFile.errorString();
        return;
    }

    QTextStream excelOut(&excelFile);
    excelOut << out.readAll();

    excelFile.close();

    workbook->dynamicCall("SaveAs(const QString&)", filePath + ".xlsx");
    workbook->dynamicCall("Close()");
    excel->dynamicCall("Quit()");
}

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

    exportToExcel("output");

    return a.exec();
}