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:

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.
Download

How to handle the WorkbookBeforeSave event of MS Excel in Delphi

Download

How to create an Excel command bar and command bar controls at run time in Delphi

Download

How to pass a parameter to an RTD function in Delphi

Download

How to work with a command bar button at run-time in Delphi

Download

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.
Download

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.
Download

How to create a custom Excel UDF in Delphi

This plugin shows how to create user-defined functions.
Download

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.
Download

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.
Download

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.
Download

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.
Download

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.
Download

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:

  • Version neutral COM add-ins that support all versions of several Office applications
  • Toolbars and toolbar controls
  • Office Ribbon controls in Ribbon tabs and Office menu
  • Advanced task panes for Microsoft Office 2016 - 2000 Excel, Word and PowerPoint
  • Handling application-level events

Also, please see a step-by-step example of developing Office plug-ins in Delphi.
Download

How to develop your first smart tag

You can find end-to-end example showing how to program smart tags in Delphi in our developer tutorial.
Download

How to implement a custom recognizer for a Smart Tag?

Download

How to intercept keyboard combinations pressed by the user?

This sample Outlook plugin intercepts Alt+W, Alt+R, Alt+L shortcuts.
Download

How to handle the TaskChange event of MS Project

This sample demonstrates how to handle the TaskChange event of MS Project in Delphi.
Download