image.png

    1. QString strFilePathName = QFileDialog::getOpenFileName(this,QStringLiteral("选择Excel文件"),"",tr("Exel file(*.xls *.xlsx)"));
    2.     if(strFilePathName.isNull())
    3.     {
    4.         return ;
    5.     }
    6.     QAxObject *excel = new QAxObject(this);    //连接Excel控件
    7.     if (excel->setControl("Excel.Application"))
    8.     {
    10.     }
    11.     else
    12.     {
    13.         excel->setControl("ket.Application");  //连接Excel控件
    14.     }
    15.     excel->setProperty("Visible", false);  //不显示窗体
    16.     QAxObject* workbooks = excel->querySubObject("WorkBooks");  //获取工作簿集合
    17.     workbooks->dynamicCall("Open(const QString&)", strFilePathName); //打开打开已存在的工作簿
    18.     QAxObject* workbook = excel->querySubObject("ActiveWorkBook"); //获取当前工作簿
    19.     QAxObject* sheets = workbook->querySubObject("Sheets");  //获取工作表集合，Sheets也可换用WorkSheets
    20.     QAxObject* sheet = workbook->querySubObject("WorkSheets(int)", 1);//获取工作表集合的工作表1，即sheet1
    21.     QAxObject* range = sheet->querySubObject("UsedRange"); //获取该sheet的使用范围对象
    22.     QVariant var = range->dynamicCall("Value");
    23.     delete range;
    24.     QVariantList varRows = var.toList();  //得到表格中的所有数据
    25.     if(varRows.isEmpty())
    26.     {
    27.         return;
    28.     }
    29.     const int rowCount = varRows.size();
    30.     QStringList column1,column2,column3;
    31.     for(int i = 0; i < rowCount; ++i)   //
    32.     {
    33.         QVariantList rowData = varRows[i].toList();
    34.         column1<<rowData[0].toString();
    35.         column2<<rowData[1].toString();
    36.         column3<<rowData[2].toString();
    37.     }
    39.     qDebug() << "-----column1-------";
    40.     for (auto &iter1:column1)
    41.     {
    42.         qDebug() << iter1;
    43.     }
    45.     qDebug() << "-----column2-------";
    46.     for (auto &iter2:column2)
    47.     {
    48.         qDebug() << iter2;
    49.     }
    51.     qDebug() << "-----column3-------";
    52.     for (auto &iter3:column3)
    53.     {
    54.         qDebug() << iter3;
    55.     }