Excel Add-in Support

Taskpane: Write Value

Summary

The ‘Write Value’ taskpane helps the user configuring the ‘=APWRITEVAL(…) function’ in a very user-friendly way. This function writes a value from an Excel cell to a given tag and displays the result of the write job in any desired Excel cell. Before a tag can be used in Excel, the tag must first be configured in Automation Portal Historian.

The user can open the ‘Write Value’ taskpane by clicking the ‘Write Value’ button in the Automation Portal Excel Add-in ribbon.

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’. The user can also search the tag via the ‘Search Tag’ panel. To make use of the ‘Search Tag’ panel, click the magnifying glass next to the tag field.

Value – Specifies the value to write to the tag.

Mode – Specifies the write mode of the write job to the tag. 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 in the ribbon is clicked.

Header – When this checkbox is checked, a header with column titles is added to the top of the current value cell.

Timestamp – When this checkbox is checked, the timestamp of the shown value is added to the left of the current value.

Quality – When this checkbox is checked, the quality of the shown value is added to the right of the current value.

Procedure

1. First open the taskpane by clicking the ‘Write Value‘ in the ribbon.

2. Secondly, click the magnifying glass, the ‘Search Tag‘ panel appears.

3. Next, select the desired tag from the list and click ‘OK‘, the tag name will appear in the tag textbox.

4. Then enter the desired value to write to the tag.

5. Select the desired write mode.

6. Thereafter, check the desired ‘Header’, ‘Timestamp’ and ‘Quality’ options.

7. Then, select the desired cell where the write job function should be displayed in the spreadsheet.

8. Finally, click ‘OK’, the write job will appear in the cell.

Example