SetCellNumber method: PSSpreadsheet class
Syntax
SetCellNumber(rownum, colnum, data, format)Description
Use the SetCellNumber method to set a double precision floating point value for the specified cell in the active spreadsheet.
Parameters
| Parameter | Description |
|---|---|
|
rownum |
Specifies the row number for the cell. |
|
colnum |
Specifies the column number for the cell. |
|
data |
Specifies the double precision floating point value to be set for the specified cell. |
|
format |
Specifies the numeric format of the data. |
Returns
(Optional) A Boolean value: True if the method completes successfully, False otherwise.
Example
The following example sets a numeric value and format for the specified cell within the spreadsheet.
&rownum = 2;
&colnum = 2;
&data = 120;
&format = "0.00";
&ssObject.SetCellNumber(&rownum, &colnum, &data, &format);