.NET - Sample Excel add-in project in VB.NET, C#, C++ with source code

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 .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 Toys .NET for Excel supports Microsoft Excel 2000, Excel 2002 (XP), Excel 2003 and Excel 2007.

How to extend Excel in Visual Studio .NET with Add-in Express

Add-in Express is a .NET object library specially designed to facilitate and expedite the development of COM add-ins in Visual Studio .NET 2003, 2005 and Visual Studio 2008 (VB.NET, C#, C++). With Add-in Express you can:

  • Develop COM add-ins for Microsoft Excel 2000, 2002, 2003 and Excel 2007.
  • Create your own command bars, add command bar controls, handle Excel events and "hook" any built-in command bar controls.
  • Customize Excel 2007 Ribbon UI, build the Quick Access Toolbar and the Office Menu for Microsoft Excel 2007. More about Excel 2007 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 - 2007. 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#.

Download free sample Excel add-in in C# with complete source code

Download free sample Excel add-in in VB .NET with complete source code

Download free sample Excel add-in in C++ with complete source code

Download free sample Excel add-in in J# with complete source code

Download free sample Excel add-in in Delphi 8 with complete source code

Note! The add-in is developed in C# .NET on Microsoft Visual Studio .NET 7.1. The source code doesn't include the Add-in Express .NET Edition source files.

Add-in Express Toys .NET toolbar

Add-in Express Toys .NET for Excel adds to Excel a new toolbar with several buttons:

The buttons are:

Shows Add-in Express Toys.NET 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.

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

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!




Client login

 

Login 

Password 

 

Remember me

Forgot my password