Use the HISTORIAN​.INFO function

The HISTORIAN.INFO function retrieves tag information for a specified list of tags.

Syntax

HISTORIAN.INFO(TagList, Details, Direction)

• TagList - Required. The range of cells containing the list of tag names you want to retrieve information about.

• Details - Required. A comma-separated list of properties to retrieve for the selected tags. The following properties are supported: SmartName, FQN, Description, EngUnit, EngUnitMax, EngUnitMin, InterpolationType, MessageOff, MessageOn, SourceTag, TagName, HierarchicalName, Alias, Location, and Namespace.

• Direction - Optional. If TRUE, the tags are listed in rows. If FALSE, the tags are listed in columns. If no value is specified, the default value of TRUE is used.

Example

Recreating the simple report from the previous example, we select the Function option instead of the Static option. This results in a formula being inserted into the spreadsheet, instead of static data. There is a brief pause while communicating with the server, then the retrieved data is displayed.

The formula generated using this example is:

=HISTORIAN.INFO(Sheet1!A2:A4, "SmartName,FQN,Description,EngUnit", TRUE)

You can modify the formula, and the results refresh automatically to reflect your changes. You can also use the function independently from the add-in. For example, the following formula is entered into cell B10:

=HISTORIAN.INFO(Sheet1!A2:A4, "SmartName,FQN,Description,EngUnit,TagType", TRUE)

The resulting report is identical to the first, but with the additional TagType property added.

If your version of Excel does not support dynamic arrays, a message similar to the following displays:

In this case, although you can still use the custom function, the output cannot be refreshed automatically. You must manually trigger the update by selecting the output range, and pressing Ctrl-Shift-Enter.