Microsoft.Office.Tools.Excel Namespace

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

Classes

ChartSheetBase	Provides the base class for chart sheet host items in document-level Office projects for Microsoft Office Excel.
ControlExtensions	Provides extension methods you can use to add Windows Forms controls to Excel worksheets that have been customized by using the Office development tools in Visual Studio.
ListObjectNotDataBoundException	The exception that is thrown when you use the Disconnect() method of a ListObject that is not bound to data.
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.
WorkbookBase	Provides the base class for the ThisWorkbook class in document-level projects for Microsoft Office Excel.
WorksheetBase	Provides the base class for the Sheetn classes in document-level projects for Microsoft Office Excel.

Interfaces

Action	Represents a smart tag action in an Excel workbook that is customized by using the Office development tools in Visual Studio.
ActionEventArgs	Provides data for the Click and BeforeCaptionShow events. This type or member is intended to be used only in projects for the 2007 Microsoft Office system. Smart tags are deprecated in Office 2010..
ApplicationFactory	Provides methods you can use to perform miscellaneous tasks in application-level add-ins, such as creating Ribbon controls at run time and adding smart tags to worksheets.
BeforeAddDataBoundRowEventArgs	Provides data for the BeforeAddDataBoundRow event.
Chart	Represents an embedded chart in Office projects for Microsoft Office Excel.
Chart_HasAxisType
ChartSheet	Represents a worksheet in document-level Excel projects created by using the Office development tools in Visual Studio.
ChartSheet_HasAxisType
ControlCollection	Represents a collection of managed controls on an Excel worksheet in an Office solution.
ControlSite	Represents a linked or embedded control on a worksheet.
ErrorAddDataBoundRowEventArgs	Provides information for the ErrorAddDataBoundRow event.
Factory	Provides methods you can use to perform miscellaneous tasks in a document-level customization, such as creating Ribbon controls at run time and adding smart tags to worksheets.
IChartSheetExtension	Represents an extension of a ChartSheet object.
ISmartTagExtension	Represents an extension of a smart tag in an Excel worksheet that is customized by using Office development tools in Visual Studio. The extension defines a custom recognizer for the smart tag.
IWorkbookExtension	Represents an extension of a Workbook object.
IWorksheetExtension	Represents an extension of a Worksheet object.
ListObject	The ListObject control displays data in a series of rows and columns.
NamedRange	A NamedRange control is a range that has a unique name, exposes events, and can be bound to data.
NamedRange_AddressLocalType
NamedRange_AddressType
NamedRange_CharactersType
NamedRange_EndType
NamedRange_ItemType
NamedRange_OffsetType
NamedRange_ResizeType
OriginalDataRestoredEventArgs	Provides data for an OriginalDataRestored event.
SmartTag	Represents a smart tag in an Excel workbook that is customized by using the Office development tools in Visual Studio.
SmartTagRecognizeContext	Provides the context of a call to a custom smart tag recognizer.
Workbook	Represents a workbook in Excel projects created by using the Office development tools in Visual Studio.
Workbook_ColorsType
Worksheet	Represents a worksheet in Excel projects created by using the Office development tools in Visual Studio.
Worksheet_RangeType
XmlMappedRange	An XmlMappedRange control is a range that is created when a non-repeating schema element is mapped onto a cell.
XmlMappedRange_AddressLocalType
XmlMappedRange_AddressType
XmlMappedRange_CharactersType
XmlMappedRange_EndType
XmlMappedRange_ItemType
XmlMappedRange_OffsetType
XmlMappedRange_ResizeType

Enums

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.

Delegates

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.

Remarks

The Microsoft.Office.Tools.Excel namespace includes the following main types:

• The WorkbookBase and WorksheetBase classes. These are the base classes for the ThisWorkbook and Sheetn classes in document-level projects for Excel. For more information, see Programming Document-Level Customizations.

• The Workbook and Worksheet interfaces. These interfaces represent extended workbooks and worksheets that you can create at run time in application-level add-ins for Excel. For more information, see Extending Word Documents and Excel Workbooks in VSTO Add-ins at Run Time.

• Host controls, including Chart, ListObject, NamedRange, and XmlMappedRange. For more information, see Host Items and Host Controls Overview.

• Types that provide smart tag functionality in Excel solutions, including Action and SmartTag.

• Various helper types, such as event arguments and delegates.