Excel Add-in Support

APRUNTIMEINFO | Read Runtime Info

Summary

Retrieve a runtime info value from the Automation Portal Historian. This function is available via the taskpane as well as directly via the cell “=APRUNTIMEINFO(…)”.

We recommend configuring this formula using the ‘Read Runtime Info‘ task pane.

Return Value

The function returns the runtime info value from the Automation Portal Historian.

Arguments

Attribute – Specifies the attribute value of the runtime info. Following options are possible:

  • NO_OF_TAGS – Returns the number of tags.
  • NO_OF_ACTIVE_TAGS – Returns the number of active tags.
  • NO_OF_CONNECTIONS – Returns the number of connections.
  • NO_OF_ACTIVE_CONNECTIONS – Returns the number of active connections.
  • NO_OF_DATAPOINTS – Returns the number of datapoints.

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

Example