Qt操作excel
来源:互联网 发布:潮潮淘宝又拍 编辑:程序博客网 时间:2024/05/04 04:56
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 );
#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();}
- QT操作Excel
- Qt操作excel类
- Qt操作excel
- QT EXCEL 操作
- QT操作Excel
- QT操作Excel
- QT操作Excel 二
- Qt操作excel
- Qt操作excel
- Qt操作excel
- QT 操作excel
- Qt之操作Excel
- Qt操作Excel文件
- Qt批量操作Excel
- Qt之操作Excel
- Qt之操作Excel
- QT 操作excel
- Qt QAxObject 操作Excel
- arcpagelistarclist列表分页
- spring获取webapplicationcontext,applicationcontext几种方法详解
- 四边形不等式DP基本总结
- 在Vim中使用python让Opencv函数自动补全
- 多线程的 Python 教程——“贪吃蛇”
- Qt操作excel
- Linux使用O_ASYNC实现异步IO
- autochannel 指定栏目
- STL赏析——pair
- stdcall与cdecl以及fastcall区别(转载+整理)
- 标准IO与系统IO(转载+整理)
- Immutable Data Structure
- dwr.xml详解
- jni学习