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.

More information

Sample CWSERV commands.

Command syntax for CWSERV.