GetRangeValue Function (Table)

Class

Table.

Action

Returns the values for the specified range in a table as a list of list of row values.

Availability

This functionality is supported only if you are using the Classic Agent.

Syntax

llaRangeValues = table.GetRangeValue (Range[, ValueType])
Variable Description
llaRangeValues The returned cell values. Each sublist in llaRangeValues is a list of the cell values for that row. LIST OF LIST OF ANYTYPE.
Range The range for which to get the value. TABLERANGE.
ValueType

Optional: The type of value to return; one of the following values of TABLEVALUETYPE:

TVT_TEXT
The values are returned as text strings (default).
TVT_TYPED
The values are in their native data types.

Example

LIST OF LIST OF ANYTYPE llVals
LIST OF ANYTYPE lRow
ANYTYPE aValue
TABLERANGE TableRange

WINDOW wAdd = DialogBox("Add-Only Table").Table("#1")

TableRange = wAdd.GetSelRange(TRUE)
llVals = wAdd.GetRangeValue(TableRange, TVT_TYPED)
for each lRow in llVals
  for each aValue in lRow
    Print(TypeOf(aValue))

// Results
// INTEGER
// INTEGER
// INTEGER
// INTEGER
// DATE