This method returns the size of the specified range, that is, the top left-hand corner and the number of lines and columns.
CALL METHOD spreadsheet->get_dimension
EXPORTING name = name
no_flush = no_flush
IMPORTING top = top
left = left
rows = rows
columns = columns
error = error
retcode = retcode.
Description of parameters
Parameter |
Optional |
Description |
name |
Name of the range | |
top |
Top edge of the range | |
left |
Left-hand edge of the range | |
rows |
Number of rows | |
columns |
Number of columns |