Skip to main content
Version: 20 R7 BETA

VP Get table range

History
ReleaseChanges
19 R7Added

VP Get table range ( vpAreaName : Text ; tableName : Text {; onlyData : Integer {; sheet : Integer }} ) : Object

ParameterTypeDescription
vpAreaNameText->4D View Pro area form object name
tableNameText->Table name
onlyDataInteger->vk table full range (default) or vk table data range
sheetInteger->Sheet index (current sheet if omitted)
ResultObject<-Range that contains the table

Description

The VP Get table range command returns the range of tableName.

In vpAreaName, pass the name of the 4D View Pro area.

In the onlyData parameter, you can pass one of the following constants to indicate if you want to get the data only:

ConstantValueDescription
vk table full range0Get the cell range for the table area with footer and header (default if omitted)
vk table data range1Get the cell range for the table data area only

In sheet, pass the index of the target sheet. If no index is specified, the command applies to the current sheet.

Indexing starts at 0.

If tableName is not found, the command returns null.

See also

VP RESIZE TABLE
VP Find table