4D v17

WP Table get columns

Home

 
4D v17
WP Table get columns

WP Table get columns 


 

WP Table get columns ( tableRef ; startCol {; numCols} ) -> Function result 
Parameter Type   Description
tableRef  Object in Table reference
startCol  Longint in Position of first column
numCols  Longint in Number of columns to get
Function result  Object in New table range containing selected columns

The WP Table get columns command returns a new cell range object containing the selection of tableRef columns defined by startCol and numCols

The startCol parameter points to the first table column to return, and the optional numCols parameter specifies how many columns to return. If numCols is omitted, the single startCol column is returned.
If startCol plus numCols exceed the number of columns in tableRef, or if startCol is greater than the number of columns in tableRef, the returned range contains the maximum possible columns.

You want to modify the attributes of the last two columns of a table:

 C_OBJECT($wpTable;$wpRange;$wpRow1;$wpRow2;$wpRow3;$wpRow4;$wpRow5;$cols)
 $wpRange:=WP Create range(WParea;wk start text;wk end text)
 $wpTable:=WP Insert table($wpRange;wk append)
 $wpRow1:=WP Table append row($wpTable;"Paul";"Smith";25)
 $wpRow2:=WP Table append row($wpTable;"John";"Richmond";40)
 $wpRow3:=WP Table append row($wpTable;"Mary";"Trenton";18)
 $wpRow4:=WP Table append row($wpTable;"Christopher";"Lee";53)
 $wpRow5:=WP Table append row($wpTable;"Henry";"Cartier";42)
 
 $cols:=WP Table get columns($wpTable;2;2)
 WP SET ATTRIBUTES($cols;wk background color;0x00E0E0E0;wk text color;"red";wk height;"36pt";wk text align;wk center)

 

Result:

To get a range of columns starting from the 10th to the end:

 WP Table get columns(tableRef;10;MAXLONG)



See also 

WP Table get cells
WP Table get rows

 
PROPERTIES 

Product: 4D
Theme: 4D Write Pro Language
Number: 1476

This command can be run in preemptive processes

 
HISTORY 

New
Created: 4D v16 R4
Modified: 4D v17

 
ARTICLE USAGE

4D Write Pro Reference ( 4D v17)