VP Get values
VP Get values ( rangeObj : Object ) : Collection
| Parameter | Type | Description | |
|---|---|---|---|
| rangeObj | Object | -> | Range object |
| Result | Collection | <- | Collection of values |
Description
The VP Get values command retrieves the values from the designated rangeObj.
In rangeObj, pass a range whose values you want to retrieve. If rangeObj includes multiple ranges, only the first range is used.
The collection returned by VP Get values contains a two-dimensional collection:
- Each element of the first-level collection represents a row and contains a subcollection of values
- Each subcollection contains cell values for the row. Values can be Integer, Real, Boolean, Text, Object, or Null. If a value is a date or time, it is returned in an object with the following properties:
| Property | Type | Description |
|---|---|---|
| value | Date | Value in the cell (except- time) |
| time | Real | Time value (in seconds) if the value is of the js date type |
Dates or times are treated as a datetime and completed as follows:
- time value - the date portion is completed as December 30, 1899
- date value - the time portion is completed as midnight (00:00:00:000)
Example
You want to get values from C4 to G6:
$result:=VP Get values(VP Cells("ViewProArea";2;3;5;3))
// $result[0]=[4,5,null,hello,world]
// $result[1]=[6,7,8,9,null]
// $result[2]=[null,{time:42,value:2019-05-29T00:00:00.000Z},null,null,null]