CIMPLICITYCWSERV with Microsoft Excel
You can use CWSERV on a Microsoft Excel spreadsheet to display point information, and to update setpoints in the CIMPLICITY point database.
Important: Beginning with CIMPLICITY v9.0, CWSERV supports point names that are longer than 32 characters. However, it supports a maximum of 255 characters that includes both the point ID and point attribute.
Example
A CIMPLICITY project is running.
The following macro is used in an Excel spreadsheet to display the value of a point in that project.
=CWSERV|POINT!pointName.VALUE
Where
pointName is the point ID
.VALUE is the VALUE attribute.
The maximum length for the point ID is 255 - 6 characters = 249 characters.
| 1 | Start CWSERV. |
| 2 | Display point data. |
| 3 | Modify point data. |
