KDCalcEngine.SetValue Method (String, String)

Set the value of a cell on the specified worksheet using the Sheet!A1 syntax.

Parameters

sheetRowCol

The sheet, row, col specified in Sheet!A1 syntax.

val

string representative of a number, boolean, or text.

Remarks

If no sheet is specified, the active sheet is used. Attempts to transform the given value into the most appropriate type, either a number, boolean, or text value. For example "10.32" would be set as a number, "true" would be set as a boolean and "hello" would go in as text. A "" value clears the cell.

Example

SetValue('my result sheet'!BC237, 42.123)

See Also

KDCalcEngine Class | KnowledgeDynamics.KDCalc Namespace | KDCalcEngine.SetValue Overload List