Examples of Excel add-in in Delphi
Delphi examples for Excel
The Delphi examples you will find further on this page work with Excel 2021 and lower and support Delphi XE2 and higher.
You may also be interested in:
Excel addin in Delphi
How to create your first Excel RTD server in Delphi
See how to build an Excel Real-Time Data server step-by-step in the
Add-in Express for Office and Delphi VCL developer tutorial:
Building Excel RTD server.
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.
Excel Automation add-ins and user-defined functions
How to write your first Excel Automation add-in
This Delphi Excel Automation addin project is described in the Add-in Express developer tutotial:
Excel Automation addin in Delphi.
How to create a custom Excel UDF in Delphi
This plugin shows how to create user-defined functions.
Advanced Excel Task Panes
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
This Delphi Excel example demonstrates how to prevent TadxExcelTaskPane from being shown and how to show it
from the command bar.
Microsoft Office general
How to develop your first add-in for Microsoft Office
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:
Also, please see a step-by-step example of developing Office plug-ins in Delphi.
How to develop your first smart tag
You can find end-to-end example showing how to program smart tags in Delphi in our
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.