「EXCEL」の編集履歴（バックアップ）一覧はこちら

「EXCEL」(2014/10/17 (金) 23:26:26) の最新版変更点

追加された行は緑色になります。

削除された行は赤色になります。

**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.

*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.