1.在工程文件中添加 qaxcontainer
CONFIG += c++11 qaxcontainer
2.使用的头文件
#include <QMessageBox>
3.代码实现
MainWindow::MainWindow(QWidget *parent)
: QMainWindow(parent)
, ui(new Ui::MainWindow)
{
ui->setupUi(this);
QAxObject* excel = new QAxObject(this);
QString filePath="D:/qt_project/build-variable_tool-Desktop_Qt_5_13_1_MinGW_32_bit-Debug/text.xls";//文件路径
if(excel->setControl("Excel,Application")) //office excel形式
{}else{
excel->setControl("ket.Application"); //wps形式
}
excel->dynamicCall("SetVisible (bool Visible)", "false"); // 不显示窗体
excel->setProperty("DisplayAlerts", false);//不显示警告信息
QAxObject* workbooks = excel->querySubObject("WorkBooks");
workbooks->dynamicCall("Open (const QString&)", filePath);
QAxObject *work_book = excel->querySubObject("ActiveWorkBook");
QAxObject *work_sheets = work_book->querySubObject("Sheets");
QAxObject *work_sheet = work_book->querySubObject("Sheets(int)", 1);
QAxObject *used_range = work_sheet->querySubObject("UsedRange");
QAxObject *rows = used_range->querySubObject("Rows");
int sheet_count = work_sheets->property("Count").toInt(); //获取工作表数目
if(sheet_count > 0)
{
int row_count = rows->property("Count").toInt(); //获取行数
int i = 2;
int j = 1;
while (i <= row_count)
{
QAxObject* cell = work_sheet->querySubObject("Cells(int, int)", i, j);//获取单元格
QString varible = cell->dynamicCall("Value2()").toString();
i++;
}
qDebug() << row_count;
work_book->dynamicCall("Close(Boolean)", false); //关闭文件
excel->dynamicCall("Quit(void)"); //退出
}
}