REPORT zsmw0010.
*&---------------------------------------------------------------------*
*& Include
*&---------------------------------------------------------------------*
INCLUDE officeintegrationinclude.
*">> Data Define
DATA: i TYPE i VALUE 2.
CONSTANTS: l_object_id(250) TYPE c VALUE 'ZTEST',
l_dest TYPE rlgrap-filename VALUE 'C:TEST.XLS'.
*">> Internal table
DATA: lt_data_table LIKE w3mime OCCURS 0 WITH HEADER LINE.
DATA: BEGIN OF it_tab OCCURS 0.
DATA: kunnr LIKE kna1-kunnr,
lifnr LIKE lfa1-lifnr,
bukrs LIKE bkpf-bukrs,
telno(20) TYPE c.
DATA: END OF it_tab.
*">> STRUCTURES
DATA : ls_key LIKE wwwdatatab.
*&---------------------------------------------------------------------*
*& Object
*&---------------------------------------------------------------------*
DATA : excel TYPE ole2_object,
books TYPE ole2_object,
book TYPE ole2_object,
sheet TYPE ole2_object,
cell TYPE ole2_object.
*&---------------------------------------------------------------------*
*& Start-of-selection
*&---------------------------------------------------------------------*
START-OF-SELECTION.
*">> 임의 데이터
it_tab-kunnr = '00000A1000'.
it_tab-lifnr = '00000B1000'.
it_tab-bukrs = 'A000'.
it_tab-telno = '010-3333-3333'.
APPEND it_tab.
it_tab-kunnr = '00000C1000'.
it_tab-lifnr = '00000D1000'.
it_tab-bukrs = 'B000'.
it_tab-telno = '011-3333-3333'.
APPEND it_tab.
*">> Data Check
CALL FUNCTION 'SAP_OI_LOAD_MIME_DATA'
EXPORTING
object_id = l_object_id
TABLES
data_table = lt_data_table
EXCEPTIONS
object_not_found = 1
internal_error = 2
OTHERS = 3.
IF sy-subrc <> 0.
MESSAGE ID sy-msgid TYPE sy-msgty NUMBER sy-msgno
WITH sy-msgv1 sy-msgv2 sy-msgv3 sy-msgv4.
ENDIF.
ls_key-relid = 'MI'. "// IMPORT
ls_key-objid = l_object_id.
CALL FUNCTION 'DOWNLOAD_WEB_OBJECT'
EXPORTING
key = ls_key
destination = l_dest. " 저장위치
CREATE OBJECT EXCEL 'EXCEL.APPLICATION'.
SET PROPERTY OF EXCEL 'VISIBLE' = 1.
댓글 0
번호 | 제목 | 글쓴이 | 날짜 | 조회 수 |
---|---|---|---|---|
410 | REPORT z02_15. | sapjoy | 2012.07.30 | 1619 |
409 | REPORT z02_14. | sapjoy | 2012.07.30 | 1535 |
408 | REPORT z02_13. | sapjoy | 2012.07.30 | 1688 |
407 | REPORT z02_12. | sapjoy | 2012.07.30 | 1613 |
406 | REPORT z02_11. | sapjoy | 2012.07.30 | 1714 |
405 | REPORT z02_10. | sapjoy | 2012.07.30 | 1606 |
404 | REPORT z02_09. | sapjoy | 2012.07.30 | 1582 |
403 | REPORT z02_08. | sapjoy | 2012.07.30 | 1840 |
402 | REPORT z02_07. | sapjoy | 2012.07.30 | 1784 |
401 | REPORT z02_06. | sapjoy | 2012.07.30 | 1655 |
400 | REPORT z02_05. | sapjoy | 2012.07.30 | 1860 |
399 | REPORT z02_04. | sapjoy | 2012.07.30 | 1950 |
398 | REPORT z02_03 | sapjoy | 2012.07.30 | 1796 |
397 | REPORT z02_01. | sapjoy | 2012.07.30 | 1776 |
396 | REPORT Z_WHEREUSEDLIST [4] | sapjoy | 2011.03.28 | 3215 |
395 | Z_EXPORT_GRAPHIC_FROM_SE78 [1] | sapjoy | 2011.03.28 | 4443 |
394 | REPORT zfalv_011. | sapjoy | 2011.02.16 | 3624 |
393 | report zsaptip_009 [1] | sapjoy | 2010.12.10 | 3852 |
392 | REPORT Z_3DGRAPH. [1] | sapjoy | 2010.10.17 | 3659 |
» | REPORT zsmw0010 | sapjoy | 2010.10.11 | 4313 |