VP Get values

Home

4D v18

VP Get values


VP Get values ( rangeObj ) -> Function result

Parameter	Type	Description
rangeObj	Object	Range object
Function 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 Longint, Real, Boolean, Text, 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]