get_selection 

This method returns the top left-hand corner and the size of the current selection in the worksheet.

CALL METHOD spreadsheet->get_selection
       EXPORTING updating  = updating
                 no_flush  = no_flush
       IMPORTING top       = top
                 left      = left
                 rows      = rows
                 columns   = columns
                 error     = error
                 retcode   = retcode.

Description of parameters

Parameter

Optional

Description

updating

X

See The Updating Parameter

top

 

Top edge of the range

left

 

Left-hand edge of the range

rows

 

Number of rows

columns

 

Number of columns