6.1 Referencing Data in the Worksheet Data Block

Within a Viewsheet script, you can use the standard Worksheet syntax to access data from any Worksheet Data Block within the linked Worksheet. For example, to access a value in a Worksheet Table or Embedded Table called “TopSales”, use one of the following syntaxes.

Note: In general, Data Block operations should be performed in the Worksheet rather than the Viewsheet.

TopSales[2][4]:
Third row, fifth column of the Data Block “TopSales.”

TopSales[2]['Price']:
Third row of the "Price" field in the Data Block “TopSales.”

viewsheet["Top Sales"][2][4]:
Third row, fifth column of the Data Block “TopSales” (with space in name).

You can type these keywords manually into your script, or you can insert them by clicking the appropriate node on the 'Data' tree in the Script Editor.

 

See Also

Grouping, in Data Mashup, for information on aggregating data.

Accessing Table Cells in Script, in Data Mashup, for information on referencing Data Blocks.

<< 6 Accessing Worksheet Data © 1996-2013 InetSoft Technology Corporation (v11.5) 6.2 Aggregating Data in the Worksheet Data Block >>