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


A CIMPLICITY project is running.

The following macro is used in an Excel spreadsheet to display the value of a point in that project.



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.