Specifications

Microsoft Excel Data Exchange Functions
PlantScape Server and Client Configuration Guide 461
Microsoft Excel Data Exchange Functions
The Microsoft Excel Data Exchange functions and parameters are listed on the
following pages.
Formula Arrays
When using formulas in worksheet cells in Microsoft Excel, some formulas may
return an array as a result. By default Microsoft Excel will only show the first
element of the array in the cell the formula is in. To see the complete array, you
need to spread the formula across a few cells.
To insert a formula array:
1 Select the cells in which you would like to insert the output.
2 Type in the function (or use the Microsoft Excel Function Wizard to build
the function).
3 After adding the formula, press <Ctrl>+<Shift>+<Enter> (instead of <Enter>)
to put the formula into all the cells.
This formula will only be executed once for the whole selection of cells and the
output array will be placed in these cells.
Note If you click one of the cells in the formula array you will notice that the formula
appears in parentheses { } instead of by itself.
Caution
1 Functions that are prefixed by NAPI_ should only be used by
advanced or experienced users who are familiar with the
Network API.
2 Do not use the Microsoft Function Wizard to write NAPI routines
into cells.
When you enter the formula in the Wizard, it displays a value in
the top of the Wizard to indicate what you will see in the cell,
given the currently entered formula. To determine this value,
Microsoft Excel actually runs the function, and this means that if
you are setting up a PUTVAL, it will write down to the server as
you enter your intermediate values.
For example, if you write the PUTVAL (POINT,SP,123.4) it will
write the values, 1, 12, 123 and 123.4 to the setpoint of POINT.
plscpcg.book Page 461 Monday, May 28, 2001 10:11 AM