ABAP内表写数据到Excel并在SAP展示生成统计图形Word文件下载.docx
- 文档编号:17569760
- 上传时间:2022-12-07
- 格式:DOCX
- 页数:19
- 大小:329.34KB
ABAP内表写数据到Excel并在SAP展示生成统计图形Word文件下载.docx
《ABAP内表写数据到Excel并在SAP展示生成统计图形Word文件下载.docx》由会员分享,可在线阅读,更多相关《ABAP内表写数据到Excel并在SAP展示生成统计图形Word文件下载.docx(19页珍藏版)》请在冰豆网上搜索。
GR_CONTAINERTYPEREFTOCL_GUI_CONTAINER,
GR_SPLITTER
CL_GUI_SPLITTER_CONTAINER,
GR_CONTROL
I_OI_CONTAINER_CONTROL,
GR_DOCUMENT
I_OI_DOCUMENT_PROXY,
GR_SPREADSHEET
I_OI_SPREADSHEET.
*
business
document
system
GR_BDS_DOCUMENTSTYPEREFTOCL_BDS_DOCUMENT_SET,
G_CLASSNAME
SBDST_CLASSNAME,
G_CLASSTYPE
SBDST_CLASSTYPE,
G_OBJECTKEY
SBDST_OBJECT_KEY,
G_DOC_COMPONENTS
SBDST_COMPONENTS,
G_DOC_SIGNATURE
SBDST_SIGNATURE.
template
url
GT_BDS_URISTYPESBDST_URI,
GS_BDS_URL
LIKE
LINE
OF
GT_BDS_URIS,
G_TEMPLATE_URL(256)
C.
OK_CODETYPESY-UCOMM,
SAVE_OK
OK_CODE.
output
internale
table
*DATA:
BEGIN
GS_SPFLI,
CARRID
SPFLI-CARRID,
CONNID
SPFLI-CONNID,
CITYFROM
SPFLI-CITYFROM,
CITYTO
SPFLI-CITYTO,
END
GS_SPFLI.
GT_SPFLI
STANDARD
TABLE
TYPES:
BEGINOFTY_MAIN,
COL1TYPECHAR10,
COL2TYPECHAR10,
ENDOFTY_MAIN.
GT_MAIN1TYPETABLEOFTY_MAIN,
GS_MAIN1
GT_MAIN1.
GT_MAIN2TYPETABLEOFTY_MAIN,
GS_MAIN2
GT_MAIN2.
Required
for
writing
data
to
Excel
GT_RANGESTYPESOI_RANGE_LIST,
GS_RANGE
SOI_RANGE_ITEM,
GT_CONTENTS
SOI_GENERIC_TABLE,
GS_CONTENT
SOI_GENERIC_ITEM.
SELECTION-SCREENBEGINOFBLOCKB1WITHFRAMETITLETEXT-FT1.
PARAMETERS:
R1TYPECRADIOBUTTONGROUPG1DEFAULT'
X'
R2
C
RADIOBUTTON
GROUP
G1
.
SELECTION-SCREENENDOFBLOCKB1.
INITIALIZATION.
=
'
HRFPM_EXCEL_STANDARD'
OT'
YBTEST_ITAB2EXCEL'
START-OF-SELECTION.
PERFORM
GET_DATA.
CALL
SCREEN
100.
DEFINE
WRITE_CONTENT_CELL.
GS_CONTENT-ROW
&
1.
GS_CONTENT-COLUMN
2.
GS_CONTENT-VALUE
3.
APPEND
GT_CONTENTS.
CLEAR
GS_CONTENT.
END-OF-DEFINITION.
Form
get_data
text
*----------------------------------------------------------------------*
FORMGET_DATA.
SELECT
FROM
SPFLI
INTO
CORRESPONDING
FIELDS
UP
10
ROWS.
GS_MAIN1-COL1
100'
.
GS_MAIN1-COL2
10'
400'
40'
200'
20'
300'
30'
500'
50'
800'
80'
900'
90'
600'
60'
700'
70'
1000'
GS_MAIN2-COL1
GS_MAIN2-COL2
ENDFORM."
get_container
FORMGET_CONTAINER.
CREATE
OBJECT
GR_CUSTOM_CONTAINER
EXPORTING
CONTAINER_NAME
CONTAINER1'
create_container_control
FORMCREATE_CONTAINER_CONTROL.
create
container
control
METHOD
C_OI_CONTAINER_CONTROL_CREATOR=>
GET_CONTAINER_CONTROL
IMPORTING
CONTROL
GR_CONTROL.
initialize
IF
R1
GR_CONTROL->
INIT_CONTROL
INPLACE_ENABLED
X
INPLACE_SCROLL_DOCUMENTS
REGISTER_ON_CLOSE_EVENT
REGISTER_ON_CUSTOM_EVENT
R3_APPLICATION_NAME
DOI演示文件名'
parent
gr_container.
PARENT
GR_CUSTOM_CONTAINER..
"
固定大小生成的容器
ELSE.
GR_CONTAINER.
动态大小生成的容器
gr_custom_container.
ENDIF.
GR_CUSTOM_CONTAINER.
get_template_url
FORMGET_TEMPLATE_URL.
LS_DOC_SIGNATURE
G_DOC_SIGNATURE.
G_PROP_VALUE
BAPISIGNAT-PROP_VALUE
VALUE
GR_BDS_DOCUMENTS.
CL_BDS_DOCUMENT_SET=>
GET_INFO
CLASSNAME
G_CLASSNAME
CLASSTYPE
G_CLASSTYPE
OBJECT_KEY
G_OBJECTKEY
CHANGING
COMPONENTS
G_DOC_COMPONENTS
SIGNATURE
用来确定节点下的EXCEL模板
LS_DOC_SIGNATURE-PROP_NAME
DESCRIPTION'
signature中的DESCRIPTION属性
LS_DOC_SIGNATURE-PROP_VALUE
G_PROP_VALUE.
DESCRIPTION属性的值
GET_WITH_URL
URIS
GT_BDS_URIS
FREE
READ
GT_BDS_URIS
INDEX
G_TEMPLATE_URL
GS_BDS_URL-URI.
open_excel_doc
FORMOPEN_EXCEL_DOCUSINGPV_SHEET.
GET_DOCUMENT_PROXY
DOCUMENT_TYPE
Excel.Sheet'
NO_FLUSH
REGISTER_CONTAINER
DOCUMENT_PROXY
GR_DOCUMENT.
GR_DOCUMENT->
OPEN_DOCUMENT
OPEN_INPLACE
open_inplace
弹出Excel显示
DOCUMENT_URL
G_TEMPLATE_URL.
AVAILABLE
I.
HAS_SPREADSHEET_INTERFACE
IS_AVAILABLE
AVAILABLE.
GET_SPREADSHEET_INTERFACE
SHEET_INTERFACE
GR_SPREADSHEET.
GR_SPREADSHEET->
SELECT_SHEET
NAME
PV_SHEET
Sheet名称
fill_ranges
FORMFILL_RANGESUSINGITAB_NAME.
LINE_COUNT
I
0,
COL_COUNT
0.
获取内表的行列数
READ_ITAB_STRUCTURE
USING
ITAB_NAME
COL_COUNT.
fill
gt_ranges[]
GS_RANGE.
GT_RANGES[].
GS_RANGE-NAME
CELL'
GS_RANGE-ROWS
LINE_COUNT.
GS_RANGE-COLUMNS
GS_RANGE-CODE
4.
GS_R
- 配套讲稿:
如PPT文件的首页显示word图标,表示该PPT已包含配套word讲稿。双击word图标可打开word文档。
- 特殊限制:
部分文档作品中含有的国旗、国徽等图片,仅作为作品整体效果示例展示,禁止商用。设计者仅对作品中独创性部分享有著作权。
- 关 键 词:
- ABAP 内表写 数据 Excel SAP 展示 生成 统计 图形
![提示](https://static.bdocx.com/images/bang_tan.gif)