Rockwell Automation FactoryTalk Historian SE DataLink 4.2 User Guide - Manual (Page 75)

6
●
Spreadsheets
●
●
●
●
●
67
For example, when you select a cell and add a Current Value function,
you specify the name of the FactoryTalk Historian tag whose current value
you want to see in the Tagname field. If you type the sinusoid tag,
FactoryTalk Historian DataLink pastes the following function into the
target cell:
=PICurrVal("sinusoid",0,)
Excel evaluates this function, retrieves the latest value of sinusoid from
FactoryTalk Historian, and displays it in the cell. If you select the cell, the
function syntax above appears in the Excel formula bar.
Array Management
Function arrays can be moved within, copied, or removed from a
spreadsheet. To select an array, do one of the following:
 Click and drag to select every cell in the array. Keep in mind that the
array may have empty values, which must also be selected.
 Right-click any part of the array and choose Select DataLink
Function from the context menu to select all cells in the array.
Once selected, you can easily manage the array:
 Right-click any cell in the array and choose the desired Cut, Copy,
Delete, Clear or Format operation from the context menu. Manually
remove initial $ characters in the formula bar to make cell references
relative.
 Right-click in a new cell and choose Paste to reinsert a cut or copied
array.
 Place the cursor over the edge of the selected array until a crosshair
cursor appears, then click and drag the array to a new cell to move it.
 Open the function dialog box or task pane and update the Output cell
(page 68) to place the array in a new location.