Add-in Express Toys™ .NET
for Microsoft Excel
Add-in Express Toys .NET is a free plug-in that adds several useful features to Microsoft Excel. This sample addin is based on
Add-in Express for Office and .NET and designed to show how to create Excel add-ins, how to manage add-in toolbars and controls,
and how to get access to Excel objects. Add-in Express for Office and .net supports Microsoft Excel 2000, Excel 2002 (XP), Excel 2003, 2007 and Excel 2010.
How to extend Excel in Visual Studio .NET with Add-in Express
Add-in Express is a .NET object library specially designed to make the development of Excel COM add-ins as fast and comfortable as it can possibly be. Add-in Express supports
Visual Studio .NET 2005, 2008 and Visual Studio 2010, even the free Express version (VB.NET, C#).
Here are just a few examples of what you can do with Add-in Express:
- Develop powerful COM add-ins for Microsoft Excel 2000, 2002, 2003 and Excel 2007 and 2010.
- Create your own toolbars, add command bar controls, handle Excel events and "hook" any built-in command bar controls.
- Customize Office Excel Ribbon UI, build the Quick Access Toolbar and the Office Menu. More about Excel Ribbon UI customization.
- Create new custom worksheet functions using the Excel Automation Add-in technology and XLL add-ins.
- Build advanced task panes for Excel 2000 - 2010. More about custom Excel task panes.
- Program Excel Real-Time Data servers that allow you to refresh any data on a worksheet in real-time, and more.
Add-in Express for Microsoft Office and .net provides the Excel.Application object as an entry point to all Excel objects and their events. Add-in Express supports all popular programming languages of the .NET platform: Visual Basic (VB.NET), Managed C++ and C#.
Note. The add-in is developed in C# .NET on Microsoft Visual Studio .NET 2003. The source code doesn't include the Add-in Express for Office and .NET source files.
Add-in Express Toys .NET for Excel adds to Excel a new toolbar with several buttons:
The buttons are:
|
|
Custom Excel button that shows Add-in Express Toys.NET About window. |
|
|
Custom button that enables / disables "wrap text" for the selected cells. |
|
|
Custom button that enables / disables "shrink to fit" for the selected cells. |
|
|
Custom Excel drop-down menu that 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. |
|
|
Custom Excel menu that shows / hides comments, zero values, formulas, gridlines and page breaks. |
|
|
Custom Excel drop-down menu that replaces the built-in Paste Special dialog box.
- All - pastes all contents and formatting of the copied cells.
- All except borders - pastes all cell contents and formatting applied to the copied cells except borders.
- Paste links - links the pasted data to the active worksheet.
- Formulas - pastes only formulas of the copied cells.
- Values - pastes only values.
- Formats - pastes only cell formatting.
- Comments - pastes only comments of the copied cells.
- Column Widths - pastes widths of the copied columns.
- Data Validation - pastes only data validation rules.
|
|
|
Custom Excel buttons to paste special operations: None, Add, Subtract, Multiply, and Divide. |
|
|
Special paste option. Avoids replacing values in the paste area when blank cells occur in the copy area. |
|
|
Special paste option. Changes columns of copied data to rows, and vice versa. |
|
