Qt操作excel

 

QAxWidget excel("Excel.Application");
1) 显示当前窗口：
excel.setProperty("Visible", true);
2) 更改 Excel 标题栏：
excel.setProperty("Caption", "Invoke Microsoft Excel");
3) 添加新工作簿：
QAxObject * workbooks = excel.querySubObject("WorkBooks");
workbooks->dynamicCall("Add");
4) 打开已存在的工作簿：
workbooks->dynamicCall("Open (const QString&)", QString("c:/test.xls"));
5) 获取活动工作簿：
QAxObject * workbook = excel.querySubObject("ActiveWorkBook");
6) 获取所有的工作表：
QAxObject * worksheets = workbook->querySubObject("WorkSheets");
7) 获取工作表数量：
int intCount = worksheets->property("Count").toInt();
8) 获取第一个工作表：
QAxObject * worksheet = workbook->querySubObject("Worksheets(int)", 1);
9) 获取cell的值：
QAxObject * range = worksheet->querySubObject("Cells(int,int)", 1, 1 );

 

 

示例代码：

 

[cpp] view plain copy print ?

1. #include <QtGui>   
2. #include <QAxObject>   
3. #include <QAxWidget>   
4. #include <qaxselect.h>   
5. int main(int argc, char **argv)  
6. {  
7.     QApplication a(argc, argv);  
8.     QAxSelect select;  
9.     select.show();  
10.     QAxWidget excel("Excel.Application");  
11.     excel.setProperty("Visible", true);  
12.     QAxObject * workbooks = excel.querySubObject("WorkBooks");  
13.     workbooks->dynamicCall("Open (const QString&)", QString("c:/test.xls"));  
14.     QAxObject * workbook = excel.querySubObject("ActiveWorkBook");  
15.     QAxObject * worksheets = workbook->querySubObject("WorkSheets");  
16.     int intCount = worksheets->property("Count").toInt();  
17.     for (int i = 1; i <= intCount; i++)  
18.     {  
19.         int intVal;  
20.         QAxObject * worksheet = workbook->querySubObject("Worksheets(int)", i);  
21.         qDebug() << i << worksheet->property("Name").toString();  
22.         QAxObject * range = worksheet->querySubObject("Cells(1,1)");  
23.         intVal = range->property("Value").toInt();  
24.         range->setProperty("Value", QVariant(intVal+1));  
25.         QAxObject * range2 = worksheet->querySubObject("Range(C1)");  
26.         intVal = range2->property("Value").toInt();  
27.         range2->setProperty("Value", QVariant(intVal+1));  
28.     }  
29.     QAxObject * worksheet = workbook->querySubObject("Worksheets(int)", 1);  
30.     QAxObject * usedrange = worksheet->querySubObject("UsedRange");  
31.     QAxObject * rows = usedrange->querySubObject("Rows");  
32.     QAxObject * columns = usedrange->querySubObject("Columns");  
33.     int intRowStart = usedrange->property("Row").toInt();  
34.     int intColStart = usedrange->property("Column").toInt();  
35.     int intCols = columns->property("Count").toInt();  
36.     int intRows = rows->property("Count").toInt();  
37.     for (int i = intRowStart; i < intRowStart + intRows; i++)  
38.     {  
39.         for (int j = intColStart; j <= intColStart + intCols; j++)  
40.         {  
41.             QAxObject * range = worksheet->querySubObject("Cells(int,int)", i, j );  
42.             qDebug() << i << j << range->property("Value");  
43.         }  
44.     }  
45.     excel.setProperty("DisplayAlerts", 0);  
46.     workbook->dynamicCall("SaveAs (const QString&)", QString("c:/xlsbyqt.xls"));  
47.     excel.setProperty("DisplayAlerts", 1);  
48.     workbook->dynamicCall("Close (Boolean)", false);  
49.     excel.dynamicCall("Quit (void)");  
50.     return a.exec();  
51. }  

#include <QtGui> #include <QAxObject> #include <QAxWidget> #include <qaxselect.h> int main(int argc, char **argv) { QApplication a(argc, argv); QAxSelect select; select.show(); QAxWidget excel("Excel.Application"); excel.setProperty("Visible", true); QAxObject * workbooks = excel.querySubObject("WorkBooks"); workbooks->dynamicCall("Open (const QString&)", QString("c:/test.xls")); QAxObject * workbook = excel.querySubObject("ActiveWorkBook"); QAxObject * worksheets = workbook->querySubObject("WorkSheets"); int intCount = worksheets->property("Count").toInt(); for (int i = 1; i <= intCount; i++) { int intVal; QAxObject * worksheet = workbook->querySubObject("Worksheets(int)", i); qDebug() << i << worksheet->property("Name").toString(); QAxObject * range = worksheet->querySubObject("Cells(1,1)"); intVal = range->property("Value").toInt(); range->setProperty("Value", QVariant(intVal+1)); QAxObject * range2 = worksheet->querySubObject("Range(C1)"); intVal = range2->property("Value").toInt(); range2->setProperty("Value", QVariant(intVal+1)); } 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("SaveAs (const QString&)", QString("c:/xlsbyqt.xls")); excel.setProperty("DisplayAlerts", 1); workbook->dynamicCall("Close (Boolean)", false); excel.dynamicCall("Quit (void)"); return a.exec(); }

 转自：http://blog.csdn.net/tingsking18/article/details/5677353

原作者： tingsking18