ABAP操作Excel
来源:互联网 发布:疯狂石头游戏知乎 编辑:程序博客网 时间:2024/05/18 03:05
REPORT YGL_MYOLE.
INCLUDE OLE2INCL.
* OLE OBJECT
DATA:
MYEXCEL TYPE OLE2_OBJECT,
MYSHEET TYPE OLE2_OBJECT,
MYCELL TYPE OLE2_OBJECT,
MYWORKBOOK TYPE OLE2_OBJECT.
.................................
*创建excel进程
CREATE OBJECT MYEXCEL 'EXCEL.APPLICATION'."EXCEL
INCLUDE OLE2INCL.
* OLE OBJECT
DATA:
.................................
*创建excel进程
CREATE OBJECT MYEXCEL 'EXCEL.APPLICATION'."EXCEL
CREATE OBJECT MYEXCEL 'ET.APPLICATION'. "WPS
* 创建工作表
CALL METHOD OF MYEXCEL 'WORKBOOKS' = MYWORKBOOK.
* 创建sheet并添加到工作表
SET PROPERTY OF MYEXCEL 'SHEETSINNEWWORKBOOK' = 1.
CALL METHOD OF MYWORKBOOK 'ADD'.
* 选中excel中的cell,第一行的第二列。
CALL METHOD OF MYEXCEL 'CELLS' = MYCELL EXPORTING #1 = 1 #2 = 2.
* 设置被选中的cell的值
SET PROTERTY OF MYCELL 'VALUE' = 'HELLO WORD'. "你要输出的内容
GET PROPERTY OF MYEXCEL 'ACTIVESHEET' = MYSHEET.
GET PROPERTY OF MYEXCEL 'ACTIVEWORKBOOK' = MYWORKBOOK.
* 保存文件
CALL METHOD OF MYWORKBOOK 'SAVEAS' EXPORTING #1 = 'C:\TMP\AA.XLS' #2 = 1.
CALL METHOD OF MYWORKBOOK 'CLOSE'.
* 推出excel
CALL METHOD OF MYEXCEL 'QUIT'.
* 释放对象
FREE OBJECT MYSHEET.
FREE OBJECT MYWORKBOOK.
FREE OBJECT MYEXCEL.
* 创建工作表
CALL METHOD OF MYEXCEL 'WORKBOOKS' = MYWORKBOOK.
* 创建sheet并添加到工作表
SET PROPERTY OF MYEXCEL 'SHEETSINNEWWORKBOOK' = 1.
CALL METHOD OF MYWORKBOOK 'ADD'.
* 选中excel中的cell,第一行的第二列。
CALL METHOD OF MYEXCEL 'CELLS' = MYCELL EXPORTING #1 = 1 #2 = 2.
* 设置被选中的cell的值
SET PROTERTY OF MYCELL 'VALUE' = 'HELLO WORD'. "你要输出的内容
GET PROPERTY OF MYEXCEL 'ACTIVESHEET' = MYSHEET.
GET PROPERTY OF MYEXCEL 'ACTIVEWORKBOOK' = MYWORKBOOK.
* 保存文件
CALL METHOD OF MYWORKBOOK 'SAVEAS' EXPORTING #1 = 'C:\TMP\AA.XLS' #2 = 1.
CALL METHOD OF MYWORKBOOK 'CLOSE'.
* 推出excel
CALL METHOD OF MYEXCEL 'QUIT'.
* 释放对象
FREE OBJECT MYSHEET.
FREE OBJECT MYWORKBOOK.
FREE OBJECT MYEXCEL.
0 0
- EXCEL 操作ABAP
- ABAP操作Excel
- ABAP Windows Excel实例操作
- SAP ABAP OLE 操作EXCEL小结
- SAP ABAP OLE 操作EXCEL小结
- 三步搞定ABAP DOI操作EXCEL
- abap excel
- abap excel
- abap excel
- ABAP: Excel
- ABAP: Excel
- ABAP: Excel
- ABAP: Excel
- SAP官方关于ABAP操作EXCEL的例子
- SAP ABAP OLE 操作上传的EXCEL模板(转)
- abap输出excel
- abap对excel处理
- ABAP DOI EXCEL
- SpinnerWheel滚轮控件
- 改进erlang版本的protobuf
- OLE简单操作
- 数据结构应该怎么学
- XML与你相识
- ABAP操作Excel
- 博客测试
- vsftpd-2.3.4服务器在ok6410开发板上的移植
- android进程间通信学习一
- 开发网络爬虫应该怎样选择爬虫框架?
- 在Cocos2d-x中使用SQLlite数据库
- 笔记:Java程序性能优化
- 虚拟机Error:"This virtual machine appears to be in use"
- UVA - 264 - Count on Cantor (Cantor的数表!)