EXCEL - ABAP @ ウィキ

Under Construction

EXCEL FORMAT DOWNLOAD.

1.TYPE-POOLS:OLE
2.(Definition) DATA: AP TYPE OLE2_OBJECT.
3.CREATE OBJECT AP 'excel.application'.
4.CALL METHOD OF AP 'Workbooks' = wb.
5.CALL METHOD OF AP 'Add'.
6.CALL METHOD OF AP 'Worksheets' = sheet exporting #1 = 1
7.CALL METHOD OF 'Cells' = Cells
8.CALL METHOD OF 'Cells' = 'Select'.
9.CALL METHOD OF sheet 'Range' = range Exporting #1 'A'.
10.CALLMETHOD RANGE 'Select'.

Download ClipBoard
CALL METHOD CL_GUI_FRONTEND_SERVICES=>CLIPBOARD_EXPORT.