Show TOC

get_ranges_dataLocate this document in the navigation structure

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.
         

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