CXlFuncs Class

Supports calls to Excel worksheet functions.


class CXlFuncs

Overview

The CXlFuncs class contains only static methods. Each of these methods calls the corresponding Excel worksheet function.

Any of these functions may normally be called from worksheet functions.

Return values

All methods return a result code, which is zero if the function has succeeded, and non-zero if the function has failed for any reason. See Error codes for a list of return values.

Note that the results of some functions may still contain Excel error values, even if a zero result code is returned, and you should take care to test the type of these results where appropriate.

Macro functions

CXlFuncs only contains worksheet functions. If you want to call an Excel macro function, use the CXlMacros class.

Other worksheet functions

The CXlFuncs class does not implement all Excel worksheet functions. If the function you want is not implemented, you can call it yourself via the CXlOper::Excel() method using the techniques described in Calling an Excel built-in function from your add-in.

Requirements