To display CIMPLICITY point information in a Microsoft Excel spreadsheet:
Select the cell where you want the point information to appear.
Enter the CWSERV formula in the cell, then press Enter.
For example, to display the raw value for the point CWSERV_VIRT, you would type:
=cwserv|point!cwserv_virt.raw_value
To display an array in a Microsoft Excel spreadsheet:
Select a range of cells (horizontal or vertical) where you want the point information to appear.
Enter the CWSERV formula, and enclose the point information within single quotes, then press Ctrl+Shift+Enter.
For example, to display the raw values for the ten-item array CWSERV_ARRAY in a column on your spreadsheet, you would type
=cwserv|point!'cwserv_array.raw_value[0:9c]'
|
|
CWSERV with Microsoft Excel. |
