Examples of Excel add-in in Delphi
Delphi examples for Excel
The Delphi examples you will find further on this page work with Excel 2016, 2013, 2010, 2007, 2003 and lower; and support Delphi XE2 to Delphi 10.2 Tokyo.
You may also be interested in:
How to handle the WorkbookBeforeSave event of MS Excel in Delphi
How to create an Excel command bar and command bar controls at run time in Delphi
How to pass a parameter to an RTD function in Delphi
How to work with a command bar button at run-time in Delphi
How to use the TTable component as a data source for RTD servers
This Delphi example shows how to use the TTable component as a data source for Excel real-time data servers.
How to create a custom Excel UDF in Delphi
This plugin shows how to create user-defined functions.
How to re-size an Excel task pane
This example illustrates the form-sizing features available for Advanced Excel Task Panes.
There are two options depending on the visibility of the splitter: if the splitter is visible, the user can change the
form size and the developer cannot. To change the form size programmatically, the developer sets the Splitter.Visible
property to false.
How to build a context-dependent Advanced Excel Task Pane
The Delphi sample for Excel dynamically shows / hides an Advanced Excel Task Pane when cell A1 contains some value
or doesn't contain any.
How to use several Advanced Excel Task Panes in one position
This Delphi plugin shows how you can use several Excel task panes in one position. Click on a RadioButton
on the Controlling Task Pane to activate the necessary TadxExcelTaskPane. Find more about
creating Excel task panes in Delphi.
How to set the visibility of Advanced Excel Task Pane
This Excel sample for Delphi demonstrates how to prevent TadxExcelTaskPane from being shown and how to show it
from a command bar.
How to create a custom pane in Excel 2016 - 2000
This Delphi Excel example demonstrates how to prevent TadxExcelTaskPane from being shown and how to show it
from the command bar.
You can find a detailed description of this project in the Developer's Guide: Creating your first Office plug-in in Delphi. From this example you will learn about the main features of Add-in Express for Office and VCL such as:
How to implement a custom recognizer for a Smart Tag?
How to intercept keyboard combinations pressed by the user?
This sample Outlook plugin intercepts Alt+W, Alt+R, Alt+L shortcuts.
How to handle the TaskChange event of MS Project
This sample demonstrates how to handle the TaskChange event of MS Project in Delphi.