Reading Values from the Gateway into Excel

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

=applicationname|<devicegroup>!itemname

Example formula:

=Gateway|ArchestrA!'<tagname>'

where:

• Gateway = the name of the OI Gateway application.

• ArchestrA = the exact device group name defined in OI Gateway for the data source.

• <tagname> = the 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, OI Gateway 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.