XLL+ Class Library

CXlOper::SetValue

Set the value of the referenced cells

[C++]
BOOL SetValue(
   const CXlOper& xloValue
) const;

Parameters

xloValue

CXlOper containing the new value of the range referenced by this CXlOper. This can be an array.

Return value

Returns TRUE if the function was successful, FALSE if it failed. The function can fail if the CXlOper does not contain a reference, or if it cannot be run in Excel at this time or if xloValue is not valid.

Remarks

This function can only be called from macro functions. It will always fail if called from worksheet functions.

The function is extremely fast, particularly when compared to equivalent VBA methods. It is by far the fastest way to pump large amounts of data into Excel.

Requirements

Header: xllplus.h

See Also

CXlOper Class | CXlOper Methods | CXlOper::Coerce() | CXlOper::GetActiveCell() | CXlOper::MakeRef()