Skip to main content
Version: 20 R7 BETA

VP Get row count

VP Get row count ( vpAreaName : Text {; sheet : Integer } ) : Integer

ParameterTypeDescription
vpAreaNameText->4D View Pro area from object name
sheetInteger->Sheet index (current sheet if omitted)
ResultInteger<-Total number of rows

Description

The VP Get row count command returns the total number of rows from the designated sheet.

In vpAreaName, pass the name property of the 4D View Pro area. If you pass a name that does not exist, an error is returned.

You can define where to get the row count in the optional sheet parameter using the sheet index (counting begins at 0). If omitted or if you pass vk current sheet, the current spreadsheet is used.

Example

The following code returns the number of rows in the 4D View Pro area:

var $rowCount : Integer
$rowCount:=VP Get row count("ViewProarea")

See also

VP Get column count
VP SET COLUMN COUNT
VP SET ROW COUNT