COM add-in for Microsoft Excel in Delphi with complete source code
Add-in Express Toys™ VCL
for Microsoft Excel
Add-in Express Toys 2 is a free sample Excel addin / plugin that adds several useful features to Microsoft Excel. The addin is based on Add-in Express for Delphi VCL and shows how to create Excel add-ins, manage add-in toolbars and controls, and get access to Excel objects. Add-in Express Toys 2 for Excel supports Microsoft Excel 2000, 2002 (XP), 2003 and Excel 2007.
How to Enhance Excel in Delphi with Add-in Express
If you have ever tried to build a COM add-in for MS Excel, then you certainly know that the most complex part of creating such add-ins is the fact that there are awful COM complexities to deal with. Add-in Express VCL can considerably ease the process for you. Add-in Express will help you with:
- Programming Excel COM Add-ins for Microsoft Excel 2000, 2002 (XP), 2003 and Excel 2007.
- Adding your own command bars, command bar controls and handling them, catching Excel events and overriding any built-in command bar controls.
- Customizing Excel 2007 Ribbon UI, building the Quick Access Toolbar and the Office Menu for Microsoft Excel 2007.
- Creating Excel user-defined functions with the Excel Automation Add-in technology.
- Developing Advanced Excel Task Panes.
- Programming RTD servers (Excel Real-Time Data servers) that allow refreshing real-time data on a worksheet, and more.
Add-in Express publishes the Excel.Application object as an instance of TExcelApplication to access to all Excel objects and their events. It supports all Delphi versions, Delphi 5, 6, 7, 2005, Delphi 2006 and 2007. So, if you need to integrate with Excel, or with MS Office in general, check out Add-in Express VCL, the tool that makes Delphi the best platform for Office add-in development. Read more about special features provided by Add-in Express for creating advanced GUI of your Excel add-in.
Download free sample Excel add-in in Delphi with complete source code
Note! Add-in Express Toys 2 for Excel is developed in Borland Delphi 7. The source code doesn't include the Add-in Express 2 VCL Edition units.
Add-in Express Toys 2 toolbar
Add-in Express Toys 2 for Excel adds to MS Excel a new toolbar with several buttons:
The buttons are:
|
|
Shows Add-in Express Toys About window. | |
|
|
Enables/disables "wrap text" for the selected cells. | |
|
|
Enables/disables "shrink to fit" for the selected cells. | |
|
|
Applies the selected underline style for the selected cells. | |
|
|
Aligns text vertically on the top of cells. | |
|
|
Aligns text vertically on the center of cells. | |
|
|
Aligns text vertically on the bottom of cells. | |
|
|
Merges the selected cells top-down and column-by-column. | |
|
|
Merges the selected cells and aligns text vertically on the top of the merged cell. | |
|
|
Merges the selected cells and aligns text vertically on the center of the merged cell. | |
|
|
Merges the selected cells and aligns text vertically on the bottom of the merged cell. | |
|
|
Shows/hides comments, zero values, formulas, gridlines and page breaks. | |
|
|
Replaces the built-in Paste Special dialog box.
| |
|
|
Paste Special Operations. Specify a paste special operation: None, Add, Subtract, Multiply, and Divide. | |
|
|
A Paste Special Option. Avoids replacing values in the paste area when blank cells occur in the copy area. | |
|
|
A Paste Special option. Changes columns of copied data to rows, and vice versa. |
Have a question? Ask it right now!
 | ||
 |
If you need quick assistance or want to share your concerns, ideas or suggestions, please write us using the form below.
|
 |
| ||