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