OPCUA.VARIABLES

Premium

Creates variables on an OPC UA Server. You are able to create single or multiple variables and if needed arrange them in a folder structure.

info

Before using OPCUA.VARIABLES() enable OPCUA Server in Stream Machine settings. Only one OPCUA.VARIABLES() per Streamsheet possible. Always use a parent element in the OPCUA.JSON() Range.

Syntax

=OPCUA.VARIABLES(Range)

Arguments

Name	Type	Description
Range	Range	An OPCUA.JSON range covering the variables and folders, which should be hosted by the OPCUA Server. OPCUA Variables have the following parameters (2 optional): key, value, [datatype, typedefinition].: Allowed Datatypes String Int32 XmlELement ByteString Double Int64 UInt32 UInt16 Boolean Allowed Type Definitions folder variable If an empty column is included in range then the system assumes for optional parameters that they are NOT given and it shall go to default. By default the system assumes the data type for each node, depending on the value.

Return

The OPCUA.VARIABLES function always switches to blue, if the inserted range is accepted. Otherwise to red with an error code.

Examples

	A	B
1	example
2	param1	13
3	string1	test1
4	param2	12
5	string2	test2
6	param3	16.23

Formula	Result	Comment
=OPCUA.VARIABLES(OPCUA.JSON(A1:B6))	"TRUE"	The two rows are needed to define the variable name and its value. The amount of columns is flexible, depending on the amount and structure of the variables needed. The Range will automatically assume a structure and settings.