Data를 excel file 형식으로 출력시키는 법

excel에 자신이 출력 하고자 하는 표를 그린다.

 

INCLUDE OLE2INCL.

DATA : EXCEL    TYPE  OLE2_OBJECT,
       BOOKS    TYPE  OLE2_OBJECT,
       CELL     TYPE  OLE2_OBJECT.

  CREATE  OBJECT  EXCEL  'EXCEL.APPLICATION'.
  SET PROPERTY OF EXCEL  'VISIBLE'    =  1  .
  CALL METHOD  OF EXCEL  'WORKBOOKS'  =  BOOKS.
  CALL METHOD  OF BOOKS  'OPEN' EXPORTING #1 = 'TEST.XLS'.

 PERFORM FILL_CELL USING :  3  2 NAME1,
                            3  6 VALUE1,
                            4  2 VALUE2,
                            4  6 VALUE3,
                            5  2 VALUE4. 
                            
                            
FORM FILL_CELL USING   I J  VAL.
  CALL METHOD OF EXCEL 'CELLS' = CELL EXPORTING  #1 = I  #2 = J.
  SET PROPERTY OF CELL 'VALUE' = VAL.
ENDFORM.                    " FILL_CELL