Skip to main content
Version: Streamsheets 2.5

OPCUA.VARIABLES

star This is a premium feature.

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

NameDescription
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:
“String”
“Int32”
“XmlElement”
“ByteString”
“Double”
“Int64”
“UInt32”
“UInt16”
“Int16”
“Boolean”
Supported typedefinitions:
“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

Serverhost

FormulaResultComment
=OPCUA.VARIABLES(OPCUA.JSON(B3:C8))
"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.