使用QAxObject获取excel的值

[sheath]

QApplication a(argc, argv);
QAxObject* excel = new QAxObject("Excel.Application");
excel->setProperty("Visible", true);
QAxObject* workbooks = excel->querySubObject("WorkBooks");
workbooks->dynamicCall("Open (const QString&)", QString("d:\\projects\\QT\\ninja\\a.xls"));
QAxObject* workbook = excel->querySubObject("ActiveWorkBook");
QAxObject* worksheets = workbook->querySubObject("WorkSheets");

QAxObject* worksheet = workbook->querySubObject("Worksheets(int)", 1);
QAxObject* usedrange = worksheet->querySubObject("UsedRange");
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();
for (int i = intRowStart; i < intRowStart + intRows; i++)
{
for (int j = intColStart; j < intColStart + intCols; j++)
{
QAxObject * range = worksheet->querySubObject("Cells(int,int)", i, j );
qDebug() << i << j << range->property("Value");
}
}
excel->setProperty("DisplayAlerts", 0);
workbook->dynamicCall("Save(void)");
workbook->dynamicCall("Close (Boolean)", false);
excel->setProperty("DisplayAlerts",1);


delete excel;


myxls w;
w.show();
return a.exec();








参考各种各样的资料,完整代码就是这样了.上面的代码基本没什么问题.就是
qDebug() << i << j << range->property("Value");
这里获取不到内容.输出的结果是1 1 QVariant(QVariant, ) .我装的是office2010.觉得应该不是office的问题.求解答

[vv_cool]

你装的office2010什么版本？专业版的话，应该跟office没关系。其它版本貌似是不行的。读取office方法还是很是有其他的，如odbc，你网上搜搜，很容易找到。

[a103176270]

我的情况跟楼主一样，不知怎么办呢！

[人到中年琐事多]

range->property("Value");
改成:
range->dynamicCall("Value2()");