데이터 선언은 이전 게시글 참고!

Select a Cell

CALL METHOD OF WORKSHEET 'CELLS' = CELL EXPORTING #1 = 1  "Row
                                                  #2 = 2. "Column

Set a Value

SET PROPERTY OF CELL 'VALUE' = 'Hello World'.

Change Font, Size, Color, Underline and Italics

CALL METHOD  OF CELL 'FONT' = FONT.        " Change Font
SET PROPERTY OF FONT 'NAME' = 'Arial'.
SET PROPERTY OF FONT 'SIZE' = 15.          " Size
SET PROPERTY OF FONT 'COLOR' = -16776961.  " Color
SET PROPERTY OF FONT 'TINTANDSHADE' = 0.
SET PROPERTY OF FONT 'BOLD' = 1.           " Bold
SET PROPERTY OF FONT 'ITALIC' = 1.         " Underline
SET PROPERTY OF FONT 'UNDERLINE' = 2.      " Italics

Change Cell Color

CALL METHOD OF CELL 'INTERIOR' = INTERIOR.
SET PROPERTY OF INTERIOR 'COLOR' = 15773696.

Select a Range of Cells

*  (1) Select starting cell
CALL METHOD OF WORKSHEET 'CELLS' = CELLSTART EXPORTING #1 = 1 #2 = 1.

*  (2) Select ending cell
CALL METHOD OF WORKSHEET 'CELLS' = CELLEND EXPORTING #1 = 3 #2 = 3.

*  (3) Select the Range
CALL METHOD OF WORKSHEET 'RANGE' = RANGE EXPORTING #1 = CELLSTART
                                                   #2 = CELLEND.

Set Borders

테두리 설정하려는 셀 또는 범위를 먼저 지정해야 한다. => ex. range

CALL METHOD OF RANGE 'BORDERS' = BORDERS EXPORTING #1 = 7. "Left
SET PROPERTY OF BORDERS 'LINESTYLE' = 1 NO FLUSH.

CALL METHOD OF RANGE 'BORDERS' = BORDERS EXPORTING #1 = 8. "Top
SET PROPERTY OF BORDERS 'LINESTYLE' = 1 NO FLUSH.

CALL METHOD OF RANGE 'BORDERS' = BORDERS EXPORTING #1 = 9.  "Bottom
SET PROPERTY OF BORDERS 'LINESTYLE' = 1 NO FLUSH.

CALL METHOD OF RANGE 'BORDERS' = BORDERS EXPORTING #1 = 10. "Right
SET PROPERTY OF BORDERS 'WEIGHT' = 4. "두껍게
SET PROPERTY OF BORDERS 'LINESTYLE' = 1 NO FLUSH.

CALL METHOD OF RANGE 'BORDERS' = BORDERS EXPORTING #1 = 11. "Central
SET PROPERTY OF BORDERS 'LINESTYLE' = 1 NO FLUSH.

Select a Column & Row

CALL METHOD OF WORKSHEET 'COLUMNS' = COLUMN EXPORTING #1 = 1.
CALL METHOD OF WORKSHEET 'ROWS' = ROW EXPORTING #1 = 1.

Get the selection reference

*  (1) Select a Row
CALL METHOD OF WORKSHEET 'ROWS' = ROW EXPORTING #1 = 1.

*  (2) Active the selection
CALL METHOD OF ROW 'SELECT'. "Get the selection object
CALL METHOD OF APPLICATION 'SELECTION' = SELECTION.

결과 화면