XLL+ Class Library (7.0)

Alphabetical List of Sample Projects

The XLL+ sample projects are listed below, in alphabetical order. Each can found in a sub-directory of the Samples directory.

ApiTest
Demonstrates how to create a wrapper library which lets you call XLL Add-in functions directly from a C#, C++ or VBA application. (New in XLL+ 6.3)
ArrayHandles
Uses handles to represent vectors of numbers
AssemblyDemo
Calls methods in a C# .NET assembly
AvgOpt
An option value calculator add-in, which demonstrates the use of a results cache to speed up performance
AvgOptCuda
An option value calculator add-in, which demonstrates the use of CUDA and a GPU to speed up performance
BinaryData
Demonstrates the use of BinaryName ranges to store binary data in an invisible named range in a worksheet
BoostHandles
Demonstrates the use of RTD handles to represent objects in Excel, where the objects are wrapped by boost::shared_ptr smart pointers (New in XLL+ 6.2)
BoostMatrix
Demonstrates how to write a matrix adapter class, to integrate a matrix class into XLL+
CalcEvt
Demonstrates how to trap the OnCalculate event, and add your own data to a worksheet
CallExcel
Demonstrates how to call Excel worksheet and macro functions from an add-in function
ClrDemo
Calls .NET methods from add-in functions
ColorCell
Contains macro functions which set the colors of a cell
CreateBook
Demonstrates how to use CXlMacros methods to create and populate workbooks
DemoFeed
Demonstrates how to integrate a data feed into an Excel add-in for high-performance real-time data add-in, written in C++, and which supports array real-time values as well as scalar values. (New in XLL+ 6.3)
Dialogs
Uses the CXlDialog class to display native Excel dialogs
DynInterMulti - Dynamic localized (Multiple DLLs)
Demonstrates how to support multiple languages using one DLL per language, switching between languages dynamically (New in XLL+ 6.0)
DynInterSingle - Dynamic localized (Single DLL)
Demonstrates how to support multiple languages in a single XLL, switching between languages dynamically (New in XLL+ 6.0)
ExcepExt
Demonstrates a function extension, which catches a developer-defined exception
ExUIDynList
Changes the contents of a value list at run-time (New in XLL+ 6.2)
ExUIPopup
Demonstrates a popup editor within the Excel Formula Wizard (New in XLL+ 6.2)
ExUIPopupCLR
Demonstrates a popup editor within the Excel Formula Wizard (using .NET WinForms) (New in XLL+ 6.2)
ExUIPopupMFC
Demonstrates a popup editor within the Excel Formula Wizard (using MFC) (New in XLL+ 6.2)
FindReplace
Uses the CXllFinder class to find and replace the contents of cells
FInspect
Demonstrates how to inspect and display information about functions in an add-in (Changed for XLL+ 6.0)
Integration
Demonstrates how to create a meta-function from the relationship between two cells and use standard numerical methods to integrate the function
InterMulti - Localized (Multiple DLLs)
Demonstrates how to support multiple languages using one DLL per language (Changed for XLL+ 6.0)
International
Demonstrates how to get and use Excel's international settings
InterSingle - Localized (Single DLL)
Demonstrates how to support multiple languages in a single XLL (Changed for XLL+ 6.0)
LabelledArgs
A typical calculator add-in, using labelled arguments
LockableHandles
Demonstrates the use of RTD handles to represent objects in Excel (New in XLL+ 7.0)
LogDemo
An add-in that writes to a log
Menus - Simple Menus
Uses the CXlMenu class to add a menu to Excel's application menu bar
MfcTutorial
Contains the code for the MFC sample in the User Guide
MonteCarlo
Combines the use of object handles and asynchronous functions (Changed for XLL+ 6.2)
MonteCarlo2
Combines the use of object handles, and asynchronous functions, and also provides a persistent object cache (New in XLL+ 6.2)
NumericHandleDemo
Demonstrates the use of numeric handles to represent objects in Excel (New in XLL+ 6.0)
PartialReg
Demonstrates how to control at run-time which add-in functions are registered and which are not
PersistentHandleDemo
Demonstrates the use of persistent RTD handles to represent objects in Excel (New in XLL+ 6.2)
PiaDemo
Uses the Excel object model, via the Primary Interop Assemblies
Profiling
Demonstrates a function extension, which profiles the performance of add-in functions
PubDevIn - Publish Opt-In Demo
Applies a function filter with an Opt-In policy
PubDevOut - Publish Opt-Out Demo
Applies a function filter with an Opt-Out policy
PublishRT - Publish Run-time Demo
Applies a function filter using a configuration file
Queued
Demonstrates the use of queued asynchronous functions
RibbonDemo - Ribbon Demo
Adds and manages controls in the Office Ribbon (New in XLL+ 7.0)
RtdHandleDemo
Demonstrates the use of RTD handles to represent objects in Excel (New in XLL+ 6.2)
Serialize
Demonstrates how to serialize Excel native data types to and from streams
SetFormula
Demonstrates how to set formulae
SharedHandles
Demonstrates how to share handles between separate add-ins
SimpOpt
A typical calculator add-in, which values vanilla options
StringHandleDemo
Demonstrates the use of string handles to represent objects in Excel (New in XLL+ 6.0)
StringPtrHandleDemo
Demonstrates the use of string pointer handles to represent objects in Excel (New in XLL+ 6.0)
SubMenus - Advanced Menus
Adds a menu and dynamic sub-menus to Excel's application menu bar
TFold
Demonstrates the use of the CXlOper class, in a useful worksheet function that constructs and manipulates arrays
Toolbar1 - Simple Toolbar
Uses the CXlToolbar class to add a toolbar to Excel's application window
Toolbar2 - Simple Toolbar using resources
Uses the CXlToolbar class to add a toolbar to Excel's application window
Toolbar3 - Dynamic Toolbar
Uses the CXlToolbar class to add a dynamic toolbar to Excel's application window
Tutorial1
Contains most of the code from the User Guide
UseTimer
Demonstrates how to use a timer to execute a macro function at regular intervals
XlpGenDemo
Demonstrates how to use the XLPGEN.EXE command-line tool

See Also

List of Sample Projects (Grouped by topic) | Samples and walkthroughs