setCellValue(tableName, row, col, value)
Writes a value into the specified row and column of the Embedded Table. See Table Properties for information on how to make a Table editable.
Parameter
- tableName
-
name of Embedded Table into which to write value
- row
-
positive integer row index starting from 0 (header row)
- col
-
positive integer col index starting from 0
- value
-
value to write
Example
The script below can be placed in the onClick handler of a Submit button. See Add Component Script for more information.
setCellValue("Table1",2,2,"hello");
saveWorksheet();
// Refresh the Dashboard with saved data from the Data Worksheet
refreshAfterSubmit = true;See saveWorksheet() and refreshAfterSubmit for more information about these functions.
|
Either syntax below can be used in component script: For onInit/onRefresh scripts, and for component and property scripts on other components, the second (qualified) form is required. |