SetCellValue

Sets the value of specific cell appended with an EasyBuilder Tag.

Note: The In-Sight 2000 series vision sensor does not support this extended native mode command and returns -2.

SetCellValue Inputs

Syntax: EV SetCellValue("Name",Value,[Mode])

Parameter	Description
"Name"	The EasyBuilder Tag name that is being used for that cell. The name must be enclosed in quotation marks.
Value	The value to be used in the cell: an integer, floating point value or text string. The function will return #ERR if the cell specified in "Name" input is not an EditInt, EditFloat or EditString function, or the value types do not correspond.
Mode	Mode is an optional input. 0 = Disable Output. The named value is not enabled for OPC data access and exchange. 1 = Output Enabled when the value of the cell changes. 2 = Enable Output. The named value is enabled for OPC data access and exchange.

Parameter

Description

"Name"

The EasyBuilder Tag name that is being used for that cell. The name must be enclosed in quotation marks.

Value

The value to be used in the cell: an integer, floating point value or text string. The function will return #ERR if the cell specified in "Name" input is not an EditInt, EditFloat or EditString function, or the value types do not correspond.

Mode

Mode is an optional input.

0 = Disable Output. The named value is not enabled for OPC data access and exchange.
1 = Output Enabled when the value of the cell changes.
2 = Enable Output. The named value is enabled for OPC data access and exchange.

SetCellValue Outputs

Returns a status code. The status codes are:

Status Codes	Description
1	The command was executed successfully.
0	Unrecognized command.
-1	The cell ID is invalid.
-2	The command could not be executed.
-6	User does not have Full Access to execute the command. For more information, see User Access Settings Dialog.

SetCellValue Example

To set the Minimum Distance value of a Distance Measurement Tool, appended with the EasyBuilder Tag name "Distance_1.Minimum" and located in cell A116, issue the following command: EV SetCellValue("Distance_1.Minimum",62)

The In-Sight sensor returns 1 to indicate that the command was executed successfully. The number of characters (in bytes) and <Float>1</Float> follows as a second confirmation of successful command execution.