The methods of the CXllApp class are listed here.
Construction
 CXllApp | Constructs a CXllApp object |
Attributes
| GetFnCount | Get a count of the add-in functions in the library |
| GetStartFnPosition | Get the starting position for iterating the function map |
| GetNextFnAssoc | Iterate the function map |
Function list operations
| AddFn | Add a function to the list of functions to be registered |
| FindFn | Find a function in the function list |
| RemoveFn | Remove a function from the list of functions to be registered |
| AddStaticFns | Register the XLL's functions as Excel add-in functions |
| PrefixFunctions | Add a string prefix to all the library's add-in functions |
SDK interface
 XlVersion | Return the Excel version number |
| XlHwnd | Return Excel's application window handle |
| GetCallerDims | Get the dimensions of the range from which this add-in function was called |
| XlGetStackSpace | Gets the number of bytes of remaining stack space |
| XlMessageBox | Display the Excel message box |
| WinMessageBox | Display the standard Windows message box |
| IsInFormulaWizard | Is Excel currently showing the Formula Wizard ? |
| Excel | Invoke the Excel SDK |
| SetErrorHandling | Switch on or off XLM4 macro error handling |
| GetSheetId | Get the sheet ID of a named sheet |
| MakeSheetName | Combine a workbook and sheet name to [book]sheet format |
| SplitSheetName | Get a workbook and sheet name from [book]sheet format |
| GetSheetName | Get the name of sheet from its sheet ID |
| GetCalculationMode | Get Excel's calculation mode |
| SetCalculationMode | Set Excel's calculation mode |
| GetUserAbort | Returns whether user has aborted operation |
| CancelUserAbort | Cancels pending abort request |
| GetInternational | Returns information about the current country and international settings. |
Miscellaneous
| GetVersionInfo | Return the version info of the XLL, including version number, copyright and build information. |
| GetXllName | Return the full path of the XLL. |
| RetString | Return a string value to Excel. |
| ErrorToString | Convert an error value to a string. |
Overridables
| OnXllOpen | Called by the framework when Excel opens the XLL |
| OnXllOpenEx | Called by the framework when Excel opens the XLL. Programmer can return FALSE to halt further loading of the XLL. |
| OnXllClose | Called by the framework when Excel closes the XLL |
| OnXllLoad | Called by the framework when Excel loads the XLL into memory |
| OnXllUnload | Called by the framework when Excel unloads the XLL |
| OnXllRegister | Called by the framework when the add-in is registered with the Excel Add-in Manager |
| OnXllUnregister | Called by the framework when the add-in is removed from the list of add-ins with the Excel Add-in Manager |
| GetRegDllName | Called by the framework to get the name of the DLL containing the add-in functions when they are registered |
COM event management
| GetSinkEvents | Returns the state of the COM event handler |
| SetSinkEvents | Sets the SinkEvents flag to switch COM event handling on or off |
| GetComEventHandler | Returns the name of an add-in function to handle a specific COM event |
| SetComEventHandler | Sets the name of an add-in function to handle a specific COM event |
COM event handlers
| OnNewWorkbook | Called by the framework when Excel creates a new workbook |
| OnSheetSelectionChange | Called by the framework when the user changes the selection |
| OnSheetBeforeDoubleClick | Called by the framework when the user double-clicks in a worksheet |
| OnSheetBeforeRightClick | Called by the framework when the user right-clicks in a worksheet |
| OnSheetActivate | Called by the framework when the user activates a worksheet |
| OnSheetDeactivate | Called by the framework when the user deactivates a worksheet |
| OnSheetCalculate | Called by the framework when any worksheet is recalculated |
| OnSheetChange | Called by the framework when the user changes the contents of a cell |
| OnWorkbookOpen | Called by the framework when a workbook is opened |
| OnWorkbookActivate | Called by the framework when a workbook is activated |
| OnWorkbookDeactivate | Called by the framework when a workbook is deactivated |
| OnWorkbookBeforeClose | Called by the framework just before a workbook is closed |
| OnWorkbookBeforeSave | Called by the framework just before a workbook is saved |
| OnWorkbookNewSheet | Called by the framework when a new sheet is added to a workbook |
BinaryName support
| DefineBinaryName | Define a binary name in a worksheet and assign a block of data to it |
| ClearBinaryName | Clear a binary name from a worksheet |
| GetBinaryName | Retrieve a binary name from a worksheet |
Requirements
Header: xllplus.h