Reading Values From The I/O Server Into Excel - Siemens 3964R User Manual

24

Reading Values from the I/O Server into Excel

Values may be read directly into Excel spreadsheets from the server by entering a DDE
formula into a cell using the following format:
=applicationname|topicname!itemname
Example formula:
where:
In this example, each time the value of DB10DW20KF changes in the PLC, the server
will automatically send 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.
=S3964R|S115U!DB10DW20KF
S3964R
S115U
DB10DW20KF
Is the name of the server application name.
Is the exact topic name defined in the server for the
PLC.
Is the actual location in the PLC that contains the data
value. This is the item name.