Siemens SIMATIC NET Guide de l'utilisateur télécharger pdf (Page 51)

Reading Values from the I/O Server into Excel 47

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:

=S7|S7PLC400!EW4

where:

S7 Is the name of the server application.

S7PLC400 Is the exact topic name defined in the server for the PLC.

EW4 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 EW4 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.

1 2 ... 46 47 48 49 50 51 52 53 54 55 56 ... 67 68

Pas de commentaire

Siemens SIMATIC NET Guide de l'utilisateur Page 51