Share via


Get started programming document-level customizations for Excel

Applies to: yesVisual Studio noVisual Studio for Mac

Note

This article applies to Visual Studio 2017. If you're looking for the latest Visual Studio documentation, see Visual Studio documentation. We recommend upgrading to the latest version of Visual Studio. Download it here

If you are just getting started creating document-level customizations for Microsoft Office Excel by using Visual Studio, here is what you need to know.

Applies to: The information in this topic applies to document-level projects for Excel. For more information, see Features available by Office application and project type.

Understand how document-level customizations for Excel work

A document-level customization for Excel is based around a single workbook. To start using the customization, the end user opens the workbook or creates the workbook from an Excel template. Events in the workbook, for example typing in cells or clicking buttons and menu items, can call event-handling methods in the assembly. When the workbook is closed, the features provided by the customization are no longer available in Excel, only in the document that contained them.

For more information, see Architecture of document-level customizations.

Create document-level projects for Excel

To create a document-level customization for Excel, use the Excel Workbook or Excel Template project template in the New Project dialog box. These templates include required assembly references and project files.

For more information about how to create a document-level project for Excel, see How to: Create Office projects in Visual Studio. For more information about the project templates, see Office project templates overview.

Program Excel workbooks by using host items and host controls

Host items and host controls are classes that provide the programming model for document-level customizations created by using Visual Studio.

Host items provide an entry point for your code, and they can also act as containers for host controls and Windows Forms controls. In document-level projects for Excel, these host items are represented by the ThisWorkbook, Sheet1, Sheet2, and Sheet3 classes.

Host controls are based on native Excel objects, such as list objects and ranges. Host controls provide similar functionality to the native Excel objects, but they also have new events, designer support, and data binding capability. They appear as first-class objects in your project code and in IntelliSense, which makes it easier to refer to specific objects directly in your code without having to navigate the Excel object model.

For more information, see the following topics:

Customize the user interface of Excel

Most Microsoft Office solutions modify the user interface (UI) of the Office application to provide some way for users to interact with the solution. There are many ways in which you can modify the UI of Excel by using a document-level customization. For example, you can add controls to the ribbon, or you can display an actions pane. For more information, see Office UI customization.

You can also open the workbook that is associated with your project directly in Visual Studio. When the workbook is open in Visual Studio, you can modify the workbook by using the Excel user interface. You can also use the workbook as a design surface, which enables you to drag controls onto worksheets. For more information, see Office projects in the Visual Studio environment.

Use data binding

The host controls are also in the list of controls that you can drag from the Data Sources window. Adding host controls in this way automatically binds them to the data source that you set up using the window. Without writing any code, you can display data from databases, web services, and business objects. For more information, see Bind data to controls in Office solutions.

Next steps

To learn how to create a document-level customization for Excel, see Walkthrough: Create your first document-level customization for Excel. This walkthrough introduces you to the Office development tools in Visual Studio and the programming model for Excel document-level customizations.

For a list of topics that walk you through some of the common tasks in Excel projects, see Common tasks in Office programming.

See also