get_ranges_data 

This method returns the data of given ranges within a worksheet. There are two ways of controlling this, depending on how you set the all parameter.

CALL METHOD spreadsheet->get_ranges_data
       EXPORTING all       = all
                 rangesdef = rangesdef
                 updating  = updating
                 no_flush  = no_flush
       IMPORTING contents  = contents
                 error     = error
                 retcode   = retcode
       CHANGING  ranges    = ranges.

Description of parameters

Parameter

Optional

Description

all

X

'X': Returns the data in all ranges

' ' : Returns only the data from the ranges specified in the ranges table.

rangesdef

X

An internal table with the type SOI_DIMENSION_TABLE with which you can define ranges by their starting position and size instead of their name.

Note: If you use this parameter, the ranges table (see below) must be empty.

updating

X

See The Updating Parameter

contents

  

Data table. Each row contains the contents of one cell.

The table must be created with reference to the type SOI_GENERIC_TABLE (see the Important Table Structures section).

ranges

  

Result table for the query. If you use the all or rangesdef parameters, it must be empty. If you do not, you must fill it with the names of the ranges before you call the method.

The table must be created with reference to the type SOI_RANGE_LIST (see the Important Table Structures section).