Use this method to set data in ranges. You must insert the data from the table
contents into the worksheet in the order defined in the ranges or rangesdef table. You can use control codes to access parts of individual ranges.CALL METHOD spreadsheet->set_ranges_data
EXPORTING ranges = ranges
contents = contents
rangesdef = rangesdef
updating = updating
no_flush = no_flush
IMPORTING error = error
retcode = retcode.
Description of parameters
Parameter |
Optional |
Description |
ranges |
Table with all ranges The table must be created with reference to the type SOI_RANGE_LIST (see the Important Table Structures section). | |
contents |
Data table The table must be created with reference to the type SOI_GENERIC_TABLE (see the Important Table Structures section). | |
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 above) must be empty. |
updating |
X |
See The Updating Parameter |
The data in the contents table may not have leading spaces. You should therefore insert the data into the table using the WRITE statement to format it at the same time. Otherwise, the leading spaces will be considered when the column width is calculated in the
fit_widest method.