[C++]
class CXlArray
Overview
A CXlArray object encapsulates the XLARRAY structure.
This structure is used by the Excel SDK, to pass data containing arrays
of floating-point numbers.
CXlArray versus COper
Both COper and CXlArray can be used to pass floating-point arrays to add-in functions.
We prefer to use COper for two reasons:
- Using COper, it is possible for the add-in function to truncate any empty cells.
If you use CXlArray, then all empty cells are filled with zeroes by Excel before
the argument is passed to the add-in function.
This may not be acceptable behaviour.
- Using COper, you can return a helpful error message if data is of the wrong type,
e.g. "Expected number in Arg1(278)" for an error in the 278th cell of an array.
Using CXlArray, Excel will merely return "#VALUE!", instead of calling the add-in function,
which is much less helpful to the user, especially if the array is very large.
See also Comparison of COper, CXlOper and CXlArray types.
Requirements
Header: xllplus.h
See Also
CXlArray Methods
| xllplus.h