Microsoft Excel Example

The syntax for a CWSERV command in a Microsoft Excel spreadsheet, is:

=cwserv|point!<point_id>.<attribute>[n:mD]

Where

< point_id > is the CIMPLICITY Point ID whose data is being retrieved. You may enter an unqualified or fully qualified (by project or node name) Point ID.
<attribute> is the point attribute of interest. If you do not enter an attribute, CWSERV uses "VALUE" as the default.
n:m is the range of array elements desired. If you do not enter a range, CWSERV uses "[0]" as the default. Enter "[n]" to specify a single element of an array.
D If you have requested a range of elements, use this field to specify the display format. Enter "C" to display the elements in a column, or "R" to display the elements in a row. If you do not enter a display format, CWSERV uses "C" as the default. Note: Consult the CIMPLICITY Help Desk for updated examples.