Listed below are the complete XLL+ sample projects.
Each can found in a sub-directory of the Samples
directory.
Basic examples
- SimpOpt
- A typical calculator add-in, which values vanilla options
- AvgOpt
- An option value calculator add-in, which demonstrates the use of a results cache to speed up performance
- LabelledArgs
- A typical calculator add-in, using labelled arguments
Tutorials
- Tutorial1
- Contains most of the code from the User Guide
- MfcTutorial
- Contains the code for the MFC sample in the User Guide
- HandleAPI
- Contains the code for the HandleAPI sample in the User Guide
- HandleAPICached
- Contains the code for the HandleAPICached sample in the User Guide
Advanced examples
- CallExcel
- Demonstrates how to call Excel worksheet and macro functions from an add-in function
- SafeCode
- Demonstrates the use of a Structured Exception Handler to trap fatal run-time exceptions
- PartialReg
- Demonstrates how to control at run-time which add-in functions are registered and which are not
- BinaryData
- Demonstrates the use of BinaryName ranges to store binary data in an invisible named range in a worksheet
- TFold
- Demonstrates the use of the COper and CXlOper classes, in a useful worksheet function that constructs and manipulates arrays
- CalcEvt
- Demonstrates how to trap the OnCalculate event, and add your own data to a worksheet
- Integration
- Demonstrates how to create a meta-function from the relationship between two cells and use standard numerical methods to integrate the function
- Serialize
- Demonstrates how to serialize Excel native data types to and from streams
- FInspect
- Demonstrates how to inspect and display information about functions in an add-in
- SetFormula
- Demonstrates how to set formulae
- UseTimer
- Demonstrates how to use a timer to execute a macro function at regular intervals
- KeyedHandle
- Shows how to use an object cache with meaningful string keys
International support and localization
- International
- Demonstrates how to get and use Excel's international settings
- Localized (Single DLL)
- Demonstrates how to support multiple languages in a single XLL
- Localized (Multiple DLLs)
- Demonstrates how to support multiple languages using one DLL per language
Excel interaction
- Simple Menus
- Uses the CXlMenu class to add a menu to Excel's application menu bar
- Advanced Menus
- Adds a menu and dynamic sub-menus to Excel's application menu bar
- Simple Toolbar
- Uses the CXlToolbar class to add a toolbar to Excel's application window
- Simple Toolbar using resources
- Uses the CXlToolbar class to add a toolbar to Excel's application window
- Dynamic Toolbar
- Uses the CXlToolbar class to add a dynamic toolbar to Excel's application window
- ComEvents
- Shows how to set up event handlers for COM events
- FindReplace
- Uses the CXllFinder class to find and replace the contents of cells
- CreateBook
- Demonstrates how to use CXlMacros methods to create and populate workbooks
- Dialogs
- Uses the CXlDialog class to display native Excel dialogs
- ColorCell
- Contains macro functions which set the colors of a cell
Multithreading
- AvgOptAsync
- An option value calculator add-in, which runs lengthy calculations in a background thread
See Also
Samples and Walkthroughs