Microsoft.Office.Tools.Excel Namespace (2007 System) (2007 System)

Switch on low bandwidth view

Collapse All

Language Filter

This page is specific to

Microsoft Visual Studio 2008/.NET Framework 3.5

Other versions are also available for the following:

Visual Studio Tools for Office API Reference

Microsoft.Office.Tools.Excel Namespace (2007 System)

The Microsoft.Office.Tools.Excel namespace contains a set of classes that extend and support the Microsoft Office Excel object model in projects created by using Visual Studio Tools for Office. The types in this namespace can be used only in Visual Studio Tools for Office projects. For more information about these projects, see Visual Studio Tools for Office Project Templates Overview.

The Microsoft.Office.Tools.Excel namespace includes the following classes:

The Workbook, Worksheet, and ChartSheet host item classes. For information about host items, see Host Items and Host Controls Overview and Excel Host Items.
Host control classes, including Chart, ListObject, NamedRange, and XmlMappedRange. For information about host controls, see Host Items and Host Controls Overview.
Classes that implement smart tag functionality in Excel, including Action and SmartTag.
Various helper classes, such as event argument and event handler classes for events in the Excel host items and host controls.

Classes

	Class	Description
	Action	Represents a Visual Studio Tools for Office smart tag action in a Microsoft Office Excel workbook.
	ActionEventArgs	Provides data for the Click and BeforeCaptionShow events.
	BeforeAddDataBoundRowEventArgs	Provides data for the BeforeAddDataBoundRow event.
	Chart	Represents an embedded chart in Visual Studio Tools for Office projects for Microsoft Office Excel.
	Chart..::._HasAxisType	Infrastructure.
	ChartSheet	A ChartSheet host item is a worksheet in Excel that contains only a chart and exposes events.
	ChartSheet..::._HasAxisType	Infrastructure.
	ControlCollection	Represents a collection of managed controls on an Excel worksheet that is part of a Visual Studio Tools for Office solution.
	ControlCollectionEnumerator	An enumerator that iterates through the ControlCollection instance.
	ErrorAddDataBoundRowEventArgs	Provides information for the ErrorAddDataBoundRow event.
	ExcelLocale1033Attribute	Specifies whether to pass the locale ID (LCID) 1033 to Microsoft Office Excel for all culture-sensitive calls to the Excel object model, regardless of the locale settings defined for the computer.
	ExcelLocale1033Proxy	Provides methods that modify how a specified native Microsoft Office Excel object passes locale ID (LCID) information to the Excel object model.
	ListObject	The ListObject control displays data in a series of rows and columns.
	ListObjectNotDataBoundException	The exception that is thrown when you use the Disconnect method of a ListObject that is not bound to data.
	NamedRange	A NamedRange control is a range that has a unique name, exposes events, and can be bound to data.
	NamedRange..::._AddressLocalType	Infrastructure.
	NamedRange..::._AddressType	Infrastructure.
	NamedRange..::._CharactersType	Infrastructure.
	NamedRange..::._EndType	Infrastructure.
	NamedRange..::._ItemType	Infrastructure.
	NamedRange..::._OffsetType	Infrastructure.
	NamedRange..::._ResizeType	Infrastructure.
	OLEObject	Represents a linked or embedded control on a worksheet.
	OriginalDataRestoredEventArgs	Provides data for an OriginalDataRestored event.
	SetDataBindingFailedException	Represents the exception that is thrown when an attempt to set data binding on the NamedRange control, Chart control, XmlMappedRange control, or ListObject control fails.
	SmartTag	Represents a smart tag in Microsoft Office Excel.
	Workbook	Represents a workbook in Visual Studio Tools for Office projects for Microsoft Office Excel.
	Workbook..::._ColorsType	Infrastructure.
	Worksheet	Represents a worksheet that exposes events and acts as a container for controls in Visual Studio Tools for Office projects for Microsoft Office Excel.
	Worksheet..::._RangeType	Infrastructure.
	XmlMappedRange	An XMLMappedRange control is a range that is created when a non-repeating schema element is mapped onto a cell.
	XmlMappedRange..::._AddressLocalType	Infrastructure.
	XmlMappedRange..::._AddressType	Infrastructure.
	XmlMappedRange..::._CharactersType	Infrastructure.
	XmlMappedRange..::._EndType	Infrastructure.
	XmlMappedRange..::._ItemType	Infrastructure.
	XmlMappedRange..::._OffsetType	Infrastructure.
	XmlMappedRange..::._ResizeType	Infrastructure.

Interfaces

	Interface	Description
	IListObjectDesignSupport	Infrastructure.

Delegates

	Delegate	Description
	ActionClickEventHandler	Represents the method that will handle the Click event of an Action.
	BeforeAddDataBoundRowEventHandler	Represents the method that will handle the BeforeAddDataBoundRow event of a ListObject.
	BeforeCaptionShowEventHandler	Represents the method that will handle the BeforeCaptionShow event of an Action.
	ErrorAddDataBoundRowEventHandler	Represents the method that handles an ErrorAddDataboundRow()()() event.
	ListObjectChangeHandler	Represents the method that will handle the Change event of a ListObject.
	OriginalDataRestoredEventHandler	Represents a method that handles the OriginalDataRestored event.
	WorkbookEvents_NewEventHandler	Represents the method that will handle the New event of a Workbook.

Enumerations

	Enumeration	Description
	ChangeReason	Provides the reason that the original data was restored to a ListObject that is bound to data.
	ChangeType	Provides information about how a ListObject control restored data that was changed by a user.
	FailureReason	Provides the reason why the ListObject data binding failed.
	FormatSettings	Specifies the type of formatting that is applied to the ListObject when it is bound to data.
	ListRanges	Specifies the range of a ListObject that has changes.

Reference

Other Resources

Host Items and Host Controls Overview

Excel Host Items

Excel Host Controls

Programmatic Limitations of Host Items and Host Controls

Excel Document-Level Customization Development

Office Solutions Development Overview