Microsoft.Office.Tools.Excel Namespace

  • Article

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.

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

Classes

  Class Description
Public class ChartSheetBase Provides the base class for chart sheet host items in document-level Office projects for Microsoft Office Excel.
Public class 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.
Public class ListObjectNotDataBoundException The exception that is thrown when you use the Disconnect method of a ListObject that is not bound to data.
Public class 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.
Public class WorkbookBase Provides the base class for the ThisWorkbook class in document-level projects for Microsoft Office Excel.
Public class WorksheetBase Provides the base class for the Sheetn classes in document-level projects for Microsoft Office Excel.

Interfaces

  Interface Description
Public interface Action Represents a smart tag action in an Excel workbook that is customized by using the Office development tools in Visual Studio.
Public interface 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.
.
Public interface 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.
Public interface BeforeAddDataBoundRowEventArgs Provides data for the BeforeAddDataBoundRow event.
Public interface Chart Represents an embedded chart in Office projects for Microsoft Office Excel.
Public interface Chart_HasAxisType Infrastructure.
Public interface ChartSheet Represents a worksheet in document-level Excel projects created by using the Office development tools in Visual Studio.
Public interface ChartSheet_HasAxisType Infrastructure.
Public interface ControlCollection Represents a collection of managed controls on an Excel worksheet in an Office solution.
Public interface ControlSite Represents a linked or embedded control on a worksheet.
Public interface ErrorAddDataBoundRowEventArgs Provides information for the ErrorAddDataBoundRow event.
Public interface 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.
Public interface IChartSheetExtension Represents an extension of a ChartSheet object.
Public interface 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.
Public interface IWorkbookExtension Represents an extension of a Workbook object.
Public interface IWorksheetExtension Represents an extension of a Worksheet object.
Public interface ListObject The ListObject control displays data in a series of rows and columns.
Public interface NamedRange A NamedRange control is a range that has a unique name, exposes events, and can be bound to data.
Public interface NamedRange_AddressLocalType Infrastructure.
Public interface NamedRange_AddressType Infrastructure.
Public interface NamedRange_CharactersType Infrastructure.
Public interface NamedRange_EndType Infrastructure.
Public interface NamedRange_ItemType Infrastructure.
Public interface NamedRange_OffsetType Infrastructure.
Public interface NamedRange_ResizeType Infrastructure.
Public interface OriginalDataRestoredEventArgs Provides data for an OriginalDataRestored event.
Public interface SmartTag Represents a smart tag in an Excel workbook that is customized by using the Office development tools in Visual Studio.
Public interface SmartTagRecognizeContext Provides the context of a call to a custom smart tag recognizer.
Public interface Workbook Represents a workbook in Excel projects created by using the Office development tools in Visual Studio.
Public interface Workbook_ColorsType Infrastructure.
Public interface Worksheet Represents a worksheet in Excel projects created by using the Office development tools in Visual Studio.
Public interface Worksheet_RangeType Infrastructure.
Public interface XmlMappedRange An XmlMappedRange control is a range that is created when a non-repeating schema element is mapped onto a cell.
Public interface XmlMappedRange_AddressLocalType Infrastructure.
Public interface XmlMappedRange_AddressType Infrastructure.
Public interface XmlMappedRange_CharactersType Infrastructure.
Public interface XmlMappedRange_EndType Infrastructure.
Public interface XmlMappedRange_ItemType Infrastructure.
Public interface XmlMappedRange_OffsetType Infrastructure.
Public interface XmlMappedRange_ResizeType Infrastructure.

Delegates

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

Enumerations

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

See Also

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