Excel Add-in Support

APWRITEVAL | Write Value

Summary

Write a given value to a given tag. This function is available via the taskpane as well as directly via the cell “=APWRITEVAL(…)”.

We recommend configuring this formula using the ‘Write Value‘ task pane.

Return Value

The function returns the write job result to the given tag. The tag must be configured in the Automation Portal Historian before the tag value can be written from Microsoft Excel.

Arguments

Tag – Specifies the tag name of the desired tag. The tag name must be exactly the same as configured in the Automation Portal ‘Historian’.

Value – Specifies the value to write to the tag.

Mode – Specifies the write mode. Following options are possible:

  • DEFAULT – Write the value to the tag each time the input value changes.
  • ONLY_ONCE – Write the value only once to the tag.
  • ON_VALUE_CHANGE – Write the value to the tag each time the input value changes.
  • ON_PUSH_VALUES_CLICK – Write the value to the tag each time the ‘Push Values’ button is clicked.

Options – Specifies custom options given by the task pane. Default value is 0.

Example