star This is a Streamsheets Premium feature.

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


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.




RangeAn 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]. Supported datatypes:
Supported typedefinitions:
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 Value

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


=OPCUA.VARIABLES(OPCUA.JSON(A1:B7)"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.