一.QAxObject
1.在工程文件(pro文件)中加入
CONFIG += qaxcontainer
2.添加头文件
#include
3.读取文件代码
QAxObject excel("Excel.Application");
excel.setProperty("Visible", false); //隐藏打开的excel文件界面
QAxObject *workbooks = excel.querySubObject("WorkBooks");
QAxObject *workbook = workbooks->querySubObject("Open(QString, QVariant)", "文件名"); //打开文件
QAxObject * worksheet = workbook->querySubObject("WorkSheets(int)", 1); //访问第一个工作表
QAxObject * usedrange = worksheet->querySubObject("UsedRange");
QAxObject * rows = usedrange->querySubObject("Rows");
int intRows = rows->property("Count").toInt(); //行数
QString Range = "A1:B" +QString::number(intRows);
QAxObject *allEnvData = worksheet->querySubObject("Range(QStri