Read values from the Communication Driver into Excel

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

=applicationname|<devicegroup>!itemname

Example formula:

=SIDIR|S7PLC!'DB1,B20'

where,

• SIDirect is the name of the Communication Driver application.

• S7PLC is the exact device group name defined in the Communication Driver for the PLC.

• DB1,B20 is the actual location in the PLC that contains the data value. This is the item name.

• In this example, each time the value of <DB1,B20> changes in the PLC, the Communication Driver automatically sends the new value to the cell containing the formula in Excel.

  Note: See the Microsoft Excel documentation for complete details on entering Remote Reference formulas for cells.