Visual Studio provides project templates you can use to create document-level customizations and VSTO Add-ins for Microsoft Office Excel. You can use these solutions to automate Excel, extend Excel features, and customize the Excel user interface (UI). For more information about the differences between document-level customizations and VSTO Add-ins, see Office Solutions Development Overview (VSTO).
Applies to: The information in this topic applies to document-level projects and VSTO add-in projects for Excel. For more information, see Features Available by Office Application and Project Type.
This topic provides the following information:
The Excel object model exposes many types that you can use to automate Excel. For example, you can programmatically create charts, format worksheets, and set the values of ranges and cells. For more information, see Excel Object Model Overview.
When developing Excel solutions in Visual Studio, you can also use host items and host controls in your solutions. These are objects that extend certain commonly used objects in the Excel object model, such as the Microsoft.Office.Interop.Excel.Worksheet and Microsoft.Office.Interop.Excel.Range objects. The extended objects behave like the Excel objects they are based on, but they add additional events and data binding capabilities to the objects. For more information, see Automating Excel by Using Extended Objects.
A document-level customization for Microsoft Office Excel consists of an assembly that is associated with a specific workbook. The assembly typically extends the workbook by customizing the UI and by automating Excel. Unlike a VSTO Add-in, which is associated with Excel itself, functionality that you implement in a customization is available only when the associated workbook is open in Excel.
To create a document-level customization project for Excel, use the Excel Workbook or Excel Template project templates in the New Project dialog box of Visual Studio. For more information, see How to: Create Office Projects in Visual Studio.
For more information about how document-level customizations work, see Architecture of Document-Level Customizations.
When you create a document-level project for Excel, Visual Studio generates several classes that are the foundation of your solution:
Sheet3. These classes represent the workbook and worksheets that are associated with your solution, and they provide a starting point for writing your code.
For more information about these generated classes and other features you can use in a document-level project, see Programming Document-Level Customizations.
A VSTO Add-in for Microsoft Office Excel consists of an assembly that is loaded by Excel. The assembly typically extends Excel by customizing the UI and by automating Excel. Unlike a document-level customization, which is associated with a specific workbook, functionality that you implement in an VSTO Add-in is not restricted to any single workbook.
To create a VSTO Add-in project for Excel, use the Excel Workbook or Excel Template project templates in the New Project dialog box of Visual Studio. For more information, see How to: Create Office Projects in Visual Studio.
For general information about how VSTO Add-ins work, see Architecture of VSTO Add-ins.
For a related video demonstration, see How Do I: Automate PowerPoint from an Excel Add-in?.
When you create an Excel VSTO Add-in project, Visual Studio generates a class, called
ThisAddIn, which is the foundation of your solution. This class provides a starting point for writing your code, and it also exposes the object model of Excel to your VSTO Add-in.
For more information about the
ThisAddIn class and other Visual Studio features you can use in an VSTO Add-in, see Programming VSTO Add-Ins.
There are several different ways to customize the user interface of Excel. Some options are available to all project types, and other options are available only to VSTO Add-ins or document-level customizations.
The following table lists customization options that are available to both document-level customizations and VSTO Add-ins.
|Task||For more information|
|Customize the Ribbon.||Ribbon Overview|
|Add Windows Forms controls or extended Excel controls to a worksheet in the customized workbook for a document-level customization, or in any open workbook for a VSTO Add-in.||How to: Add Windows Forms Controls to Office Documents|
How to: Add Chart Controls to Worksheets
How to: Add ListObject Controls to Worksheets
How to: Add NamedRange Controls to Worksheets
The following table lists customization options that are available only to document-level customizations.
|Task||For more information|
|Add an actions pane to the workbook.||Actions Pane Overview|
How to: Add an Actions Pane to Word Documents or Excel Workbooks
|Add extended range controls that are mapped to XML nodes to a worksheet.||How to: Add XMLMappedRange Controls to Worksheets|
The following table lists customization options that are available only to VSTO Add-ins.
|Task||For more information|
|Create a custom task pane.||Custom Task Panes|
|Excel Object Model Overview||Provides an overview of the main types provided by the Excel object model.|
|Automating Excel by Using Extended Objects||Provides information about extended objects (provided by the Visual Studio Tools for Office runtime) that you can use in Excel solutions.|
|Globalization and Localization of Excel Solutions||Contains information about special considerations for Excel solutions that will be run on computers that have non-English settings for Windows.|
|Windows Forms Controls on Office Documents Overview||Describes how you can add Windows Forms controls to Excel worksheets.|
|Walkthrough: Creating Your First Document-Level Customization for Excel||Demonstrates how to create a basic document-level customization for Excel.|
|Walkthrough: Creating Your First VSTO Add-in for Excel||Demonstrates how to create a basic VSTO Add-in for Excel.|
|Walkthrough: Adding Controls to a Worksheet at Run Time in VSTO add-in Project||Demonstrates how to add a Windows Forms button, a NamedRange, and a ListObject to a worksheet at run time by using a VSTO Add-in.|
|Excel 2010 in Office Development||Provides links to articles and reference documentation about developing Excel solutions. These are not specific to Office development using Visual Studio.|