==================================================================================
void TestReadExcel::readExcel()
{
QAxObject *excel = NULL;
QAxObject *workbooks = NULL;
QAxObject *workbook = NULL;
excel = new QAxObject("Excel.Application");
if (!excel)
{
QMessageBox::critical(this, "错误信息", "EXCEL对象丢失");
return;
}
excel->dynamicCall("SetVisible(bool)", false);
workbooks = excel->querySubObject("WorkBooks");
workbook = workbooks->querySubObject("Open(QString, QVariant)", QString(tr("d:\\test.xls")));
QAxObject * worksheet = workbook->querySubObject("WorkSheets(int)", 1);//打开第一个sheet
//QAxObject * worksheet = workbook->querySubObject("WorkSheets");//获取sheets的集合指针
//int intCount = worksheet->property("Count").toInt();//获取sheets的数量
QAxObject * usedrange = worksheet->querySubObject("UsedRange");//获取该sheet的使用范围对象
QAxObject * rows = usedrange->querySubObject("Rows");
QAxObject * columns = usedrange->querySubObject("Columns");
/*获取行数和列数*/
int intRowStart = usedrange->property("Row").toInt();
int intColStart = usedrange->property("Column").toInt();
int intCols = columns->property("Count").toInt();
int intRows = rows->property("Count").toInt();
/*获取excel内容*/
for (int i = intRowStart; i < intRowStart + intRows; i++) //行
{
for (int j = intColStart; j < intColStart + intCols; j++) //列
{
QAxObject * cell = worksheet->querySubObject("Cells(int,int)", i, j ); //获取单元格
// qDebug() << i << j << cell->property("Value"); //*****************************出问题!!!!!!
qDebug() << i << j <<cell->dynamicCall("Value2()").toString(); //正确
}
}
workbook->dynamicCall("Close (Boolean)", false);
//同样,设置值,也用dynamimcCall("SetValue(const QVariant&)", QVariant(QString("Help!")))这样才成功的。。
//excel->dynamicCall("Quit (void)");
delete excel;//一定要记得删除,要不线程中会一直打开excel.exe
}
==================================================================================
都是一些代码,我用的是VS2008+Qt,按照一般网上说的直接就找不到头文件
添加了头文件
#include <QAxObject>
但是提示找不到<QAxObject>头文件,自己随便转到定义,确实可以转到qaxbase.h的头文件,QAxBase类里面声明了QAxObject,于是打开了包含qaxbase.h的文件,在里面找到了一个qaxobject.h的文件,里面定义了QAxObject类,最终添加了 #include <ActiveQt/qaxobject.h>
#include <ActiveQt/qaxobject.h>
QAxObject *pApplication;
QAxObject *pWorkBooks;
QAxObject *pWorkBook;
QAxObject *pSheets;
QAxObject *pSheet;
QAxWidget *pWord;
pApplication = NULL;
pWorkBooks = NULL;
pWorkBook = NULL;
pSheets = NULL;
pSheet = NULL;
pWord = NULL;
pApplication = new QAxObject();
pApplication->setControl("Excel.Application");//连接Excel控件
pApplication->dynamicCall("SetVisible(bool)", true);//false不显示窗体
pApplication->setProperty("DisplayAlerts", false);//不显示任何警告信息。
pWorkBooks = pApplication->querySubObject("Workbooks");
QString fileName = "./data.xls";
QFile file(fileName);
if (file.exists())
{
pWorkBook = pWorkBooks->querySubObject("Open(const QString &)", fileName);
}
else
{
pWorkBooks->dynamicCall("Add");
pWorkBook = pApplication->querySubObject("ActiveWorkBook");
}
pSheets = pWorkBook->querySubObject("Sheets");
pSheet = pSheets->querySubObject("Item(int)", 1);
确实可以用了,但是运行代码提示无法解析的外部符号之类的,就是所谓的setControl、dynamicCall这些库函数
查了一个上午才知道如果是:
QtCreate创建的工程:在pro 文件中添加一行 CONFIG += qaxcontainer就可以
如果是vs+qt,如果创建工程的时候没有勾选ActiveQt Container库,就要在项目属性--Qt Project Settings--Qt Modules界面中勾选ActiveQt container,添加动态库连接
CONFIG += qaxcontainer 也就是链接一些操作COM组件的动态库
遇到的问题:
1.隐藏文件夹ActiveQT的添加:新建一个QT工程,在初始的时候将这个勾上,然后找到文件夹,将头文件等复制到目标处;
2.使用#include <ActiveQt/QAxBase>#include <ActiveQt/QAxObject>
需要在链接器中添加QTcontainer.lib