Creating Excel AddIn From Visual Studio 2013

Introduction

Today you will learn to create an application-level add-in for Microsoft Office Excel with the Visual Studio 2013. You can apply it also to create the projects for Excel 2010.

We'll proceed here with the following sections:

• Project Creation
• Code Implementation
• Project Execution
• Cleaning the Solution

Prerequisites

The following are some prerequisites:

• Excel 2013 or Excel 2010
• Microsoft Office Development in Visual Studio 2013

Let's proceed with the sections mentioned above.

Project Creation

Step 1: Open the Visual Studio 2013

Step 2: Click on "New Project" and select the Excel 2013 as shown below:

Step 3: Enter the name for your Excel-Addin

Visual Studio creates the Excel-AddIn and ThisAddIn.cs file that opens automatically.

Code Implementation

There are two methods named ThisAddIn_Startup() and ThisAddIn_Shutdown() created automatically. We need to implement some code to generate the text in the Excel file. Use the following procedure to do that.

Step 1: Modify your code in the ThisAddIn_Startup()

private void ThisAddIn_Startup(object sender, System.EventArgs e)

{

this.Application.WorkbookBeforeSave += new Microsoft.Office.Interop.Excel.AppEvents_WorkbookBeforeSaveEventHandler(MyExcelAddIn_BeforeSave);

}

Step 2: Now generate the method as shown below:

Step 3: Modify your auto generated method with the following code: