SAP ABAP如何将内表的数据导出到EXCEL
来源:互联网 发布:网络直销 编辑:程序博客网 时间:2024/05/17 21:38
将内表的数据导出到EXCEL
REPORT ZTEST08.
DATA: BEGIN OF MY_DATA,
MANDT LIKE USR02-MANDT,
BNAME LIKE USR02-BNAME,
ERDAT LIKE USR02-ERDAT,
LTIME LIKE USR02-LTIME,
END OF MY_DATA.
DATA: IT_DATA LIKE MY_DATA OCCURS 0.
SELECT USR02~MANDT USR02~BNAME USR02~ERDAT USR02~LTIME
APPENDING TABLE IT_DATA
FROM USR02
UP to 100 rows.
*排序
SORT IT_DATA BY BNAME.
INCLUDE OLE2INCL. "定义OLE变量
DATA: EXCEL TYPE OLE2_OBJECT,
SHEET TYPE OLE2_OBJECT,
CELL TYPE OLE2_OBJECT,
WORKBOOK TYPE OLE2_OBJECT,
XLSNAME TYPE STRING VALUE 'C:\sap_usr02.xls',
LINE TYPE I VALUE 0. "行号
CREATE OBJECT EXCEL 'EXCEL.APPLICATION'."启动Excel
IF SY-SUBRC NE 0.
WRITE: / '启动Excel失败。'.
STOP.
ENDIF.
CALL METHOD OF EXCEL 'WORKBOOKS' = WORKBOOK.
SET PROPERTY OF EXCEL 'VISIBLE' = 1. "使excel 可视
SET PROPERTY OF EXCEL 'SHEETSINNEWWORKBOOK' = 1. "如果是读取excel文件中的内容 则是直接打开工作簿第一页
CALL METHOD OF WORKBOOK 'ADD'. "例如:CALL METHOD OF EXCEL 'WORKSHEETS' = SHEET EXPORTING #1 = 1.
LOOP AT IT_DATA INTO MY_DATA.
LINE = LINE + 1. "Excel 中行号从1开始
CALL METHOD OF EXCEL 'CELLS' = CELL EXPORTING #1 = LINE #2 = 1. "指定单元格,
SET PROPERTY OF CELL 'VALUE' = MY_DATA-MANDT. "写入值
CALL METHOD OF EXCEL 'CELLS' = CELL EXPORTING #1 = LINE #2 = 2. "指定单元格,
SET PROPERTY OF CELL 'VALUE' = MY_DATA-BNAME. "写入值
CALL METHOD OF EXCEL 'CELLS' = CELL EXPORTING #1 = LINE #2 = 3. "指定单元格,
SET PROPERTY OF CELL 'VALUE' = MY_DATA-ERDAT. "写入值
CALL METHOD OF EXCEL 'CELLS' = CELL EXPORTING #1 = LINE #2 = 4. "指定单元格,
SET PROPERTY OF CELL 'VALUE' = MY_DATA-LTIME. "写入值
ENDLOOP.
GET PROPERTY OF EXCEL 'ACTIVESHEET' = SHEET. "激活工作簿
GET PROPERTY OF EXCEL 'ACTIVEWORKBOOK' = WORKBOOK. "激活工作区
CALL METHOD OF WORKBOOK 'SAVEAS' EXPORTING #1 = XLSNAME #2 = 1. "将excel文件保存
CALL METHOD OF WORKBOOK 'CLOSE'. "关闭工作区
CALL METHOD OF EXCEL 'QUIT'. "退出excel
*WRITE:/ XLSNAME,'DONE'. "退出成功,输出done
FREE OBJECT SHEET. "释放操作
FREE OBJECT WORKBOOK.
FREE OBJECT EXCEL.
- SAP ABAP如何将内表的数据导出到EXCEL
- SAP ABAP如何将内表的数据导出到EXCEL
- SAP 将内表的数据导出到本地xls文件 abap实例 INCLUDE OLE2INCL
- SAP ABAP 如何读取EXCEL数据到内表
- SAP ABAP 如何读取EXCEL数据到内表
- SAP ABAP编程 数据库内容导出到excel
- SAP ABAP将内表数据导出到TXT和从TXT读取到内表
- SAP ABAP将内表数据导出到TXT和从TXT读取到内表
- SAP ABAP OLE 输出数据到 Excel 无法自动保存的解决
- SAP ABAP OLE 输出数据到 Excel 无法自动保存的解决
- [转帖]ABAP实践学习--ABAP中将SAP数据按格式保存到EXCEL(OLE)
- [转帖]ABAP实践学习--ABAP中将SAP数据按格式保存到EXCEL(OLE)
- 如何将form里面的数据导出到excel中
- ABAP 写数据到SAP服务器文件
- ABAP 写数据到SAP服务器文件
- ABAP 内表导出到excel
- ABAP 导出到EXCEL(模板一)
- SAP中如何把屏幕数据复制到excel中
- Js 基于localStorage 制作的 "我的便签本"
- oracle-tnsping命令
- 解决PhoneGap(Cordova)在iOS中启动画面闪动的问题 - 技术博客
- 在Ubuntu上下载、编译和安装Android最新源代码
- 浅谈利用Android NDK编译C/C++文件的经历
- SAP ABAP如何将内表的数据导出到EXCEL
- 资源的多位置上传与管理
- notepad++ 杂记
- 故事再美,还是会有结局:物是人非的空间日志
- 数据库的导入导出命令
- 在Ubuntu上下载、编译和安装Android最新内核源代码(Linux Kernel)
- embed标签的使用(在网页中播放各种音频视频的插件的使用)
- 从Klocwork中.net检测项说说代码书写
- POJ 2689 Prime Distance