Read values from the Gateway Communication Driver into Excel

Values may be read directly into Excel spreadsheets from Gateway Communication Driver by entering a DDE formula into a cell using the following format:

=applicationname|<devicegroup>!itemname

Example formula:

=Gateway|ArchestrA!'<tagname>'

where,

Gateway: name of the Gateway Communication Driver application.

ArchestrA: exact device group name defined in Gateway Communication Driver for the data source.

<tagname>: actual location in the data source that contains the data value. This is the item name.

In this example, each time the value of <tagname> changes in the data source,Gateway Communication Driver automatically sends the new value to the cell containing the formula in Excel.

Note: Refer to the Microsoft Excel manual for complete details on entering Remote Reference formulas for cells.