COM add-in for Microsoft Excel in Delphi with complete source code
Add-in Express Toys™ VCL
for Microsoft Excel
Add-in Express Toys 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 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 awful COM complexities that you need to deal with. Add-in Express for Delphi VCL can considerably ease the process for you. Add-in Express will help you with:
- Programming COM Add-ins for Microsoft Excel 2007, 2003, 2002 (XP) and 2000.
- 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 for Excel is developed in Borland Delphi 7. The source code doesn't include the Add-in Express VCL Edition units.
Add-in Express Toys toolbar
Add-in Express Toys 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 Excel 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 Excel comments, zero values, formulas, gridlines and page breaks. | |
|
|
Replaces the built-in Excel 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. |
Download sample Excel add-in in Delphi with complete source code
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.
|
 |
| ||