[Qt]导入导出Excel

Qt对Excel的导入导出，有备无患

void onImportExcel(QString filePath)

{
 
 

    QAxObject excel("Excel.Application");

    excel.setProperty("Visible", false);

    QAxObject *work_books = excel.querySubObject("WorkBooks");

    work_books->dynamicCall("Open (const QString&)", filePath);

    QAxObject *work_book = excel.querySubObject("ActiveWorkBook");

    QAxObject *work_sheets = work_book->querySubObject("Sheets");  //Sheets也可换用WorkSheets

    int sheet_count = work_sheets->property("Count").toInt();  //获取工作表数目

    if(sheet_count > 0)

    {
 
 

        QAxObject *work_sheet = work_book->querySubObject("Sheets(int)", 1);

        QAxObject *used_range = work_sheet->querySubObject("UsedRange");