Excel Host Controls
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
Application-level projects
For more information, see Features Available by Application and Project Type. |
Visual Studio Tools for Office extends the functionality of some important objects in Microsoft Office Excel so that they expose events and can be bound to data. This section describes the host controls available for Excel workbooks.
In This Section
Chart Control
Describes the extended functionality of Chart controls, including the addition of events and data binding.ListObject Control
Describes the extended functionality of ListObject controls, including the addition of events and data binding.NamedRange Control
Describes the extended functionality of NamedRange controls, including the addition of events and data binding.XmlMappedRange Control
Describes the extended functionality of XmlMappedRange controls, including the addition of events and data binding.How to: Add Chart Controls to Worksheets
Demonstrates how to create Excel Chart controls at design-time and programmatically during run-time.How to: Add ListObject Controls to Worksheets
Demonstrates how to add ListObject controls from the toolbox at design-time, and programmatically during run-time.How to: Add NamedRange Controls to Worksheets
Provides information on adding NamedRange controls at design-time and run-time.How to: Add XMLMappedRange Controls to Worksheets
Describes how to map repeating XML elements to a worksheet in order to create XmlMappedRange controls.How to: Delete NamedRange Controls at Design Time
Demonstrates how to use the Define Name dialog box to delete named ranges in Excel.How to: Resize NamedRange Controls
Describes how to set properties of NamedRange controls in order to resize it.How to: Resize ListObject Controls
Demonstrates how to use the Resize list dialog box and also how to programmatically resize ListObject controls.How to: Locate NamedRange Controls on a Worksheet
Describes how to use the Name Box or Properties window to locate NamedRange controls on a worksheet.How to: Validate Data When a New Row is Added to a ListObject Control
Describes how to use the BeforeAddDataBoundRow event to validate data before committing changes in the ListObject to the data source.How to: Handle Errors When a New Row is Added to a ListObject Control
Describes how to use the ErrorAddDataBoundRow event to correct an error and attempt to add the row to the data source again.How to: Map ListObject Columns to Data
Describes how to map specific columns within a ListObject control to a data source.Walkthrough: Programming Against Events of a NamedRange Control
Demonstrates the creation of event handlers for the BeforeRightClick, SelectionChange and Change events of a NamedRange control.Understanding ListObject Column and Row Order Persistence
Describes how column and row order changes made to a ListObject are preserved.
Related Sections
Host Items and Host Controls Overview
Describes the relationship between host items and host controls, as well as the additional functionality that has been added to the native objects upon which they are based.Word Host Controls
Provides links to information on the new controls available to Word documents, known as host controls, and how to add them to a document.Binding Data to Controls in Office Solutions
Lists topics that show how to bind controls, including host controls, to data.