2.2. Data Points
Here you can select and configure the data points to which you want to connect.
- Selected Point
Enter the point name manually, or select it from the list in Points or Bindings below.
- Range
The range selected in the worksheet will appear here. You can change this with the new range icon
, or modify it to match the size of the range with
the range size icon 
. You can also check the
box to automatically adjust the range when the range in the data point
changes size. These changes will take effect when you click the
button (below).- Range Name
The system provides a default range name, which you can change. This range name can be used in formulas in other cells.
Options
- Direction
There are four options for the direction of the data flow:
Read the data from the server (DataHub instance or DataHub for Azure) into Excel.
Write the data from Excel to the server. Use this to publish a value or formula result back to the server.
Read before Write creates a bidirectional connection that always takes the value from the server initially, when this worksheet is first opened. Once the connection is made, the data is sequentially updated by the latest values from either side.
Write before Read creates a bidirectional connection that always updates the server from this worksheet when it is first opened. Once the connection is made, the data is sequentially updated by the latest values from either side.
- Properties
Lets you select which properties of the data will appear in consecutive cells in a range (UTC Time, Local Time, Value, Quality, and Quality Name). They will be added to the range in that order. You need to ensure that you have selected the correct number of cells to accommodate all of the ones you select.
- Treatment
Lets you specify how the data is treated. Value preserves the point's data type and value. Formula treats strings that start with
=as formulas; all others are treated the same as Value.- Fill Style
When you select a range of cells, the Fill Style determines how Read values will fill the cell:
Fill updates all cells in the range with the same value.
RotateVertical adds new values to the last cell in the range, pushing all previous values upward within the range.
RotateHorizontal adds new values to the last cell in the range, pushing all previous values to the left.
CycleVertical adds new values to the range from top to bottom. When the last cell in the range is filled, new values begin to to fill in from the top again.
CycleHorizontal adds new values to the range from left to right. When the last cell in the range is filled, new values begin to to fill in from the left again.
Reverse changes the direction of any Rotate or Cycle option above (e.g. bottom to top, right to left, etc.).
For all selections
- Add button
Adds the current selection.
- Update button
Applies any configuration changes made to the current selection.
- Points
Displays all the points that are available on the server.
- Bindings
Displays all the saved bindings of points to ranges.
- or
These buttons remove all bindings, or the one selected.
When removing, the option lets you remove or keep the range or cell name. The option lets you remove or keep the values in the range or cell.
- and buttons
These allow you to export or import bindings.
To export
Open a blank sheet and select a cell where you want the list of exported bindings to start.
Press the button. All the binding information will be written as an eleven-column list, with one binding per line.
You can save the sheet or its contents to a file.
To import
In the target workbook, open a blank sheet and select a cell where you want to start the list of bindings.
Put the whole binding information list, including headers, into the sheet. You can do this by copy/paste or by reading a CSV file into the sheet.
You can now modify the contents of the list, add rows, remove rows, etc. to customize the import, if you wish.
Select the entire range, including the column headers.
Press the button.
The bindings should appear in the Bindings window and be fully operational.
You can now delete the sheet with the bindings list you created.