Automating Excel by Using Extended Objects

Updated: July 2008

Applies to

The information in this topic applies only to the specified Visual Studio Tools for Office projects and versions of Microsoft Office.

Document-level projects

  • Excel 2007

  • Excel 2003

Application-level projects

  • Excel 2007

For more information, see Features Available by Application and Project Type.

Visual Studio Tools for Office adds events and data-binding capabilities to some of the objects that are provided by the native object model of Microsoft Office Excel (that is, the object model that is exposed by the primary interop assembly for Excel). These extended objects are called host items and host controls.

Starting in SP1, host items and host controls are available in application-level add-ins and document-level customizations. Without SP1 installed, they are available only in document-level customizations. For more information, see Host Items and Host Controls Overview.

Excel projects give you access to three host items:

The Workbook host item acts as a container for components that are shared by all worksheets in the workbook.

The Worksheet host item acts as a container for other controls, including host controls and Windows Forms controls, and it maintains information about the controls on its surface.

The ChartSheet host item is a worksheet in Excel that contains only a chart.

For more information about Excel host items, see Excel Host Items.

There are several host controls for Excel that help you create, organize, and automate Excel workbooks and worksheets. These host controls provide events and data-binding capabilities that their counterparts in the native Excel object model do not have. For information about host controls and step-by-step procedures for how to use them, see Excel Host Controls




July 2008

Added information about using host items and host controls in application-level add-ins.

SP1 feature change.

Community Additions