Was this page helpful?
Your feedback about this content is important. Let us know what you think.
Additional feedback?
1500 characters remaining
Microsoft.Office.Tools.Excel
Collapse the table of content
Expand the table of content

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.

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

  ClassDescription
Public classChartSheetBaseProvides the base class for chart sheet host items in document-level Office projects for Microsoft Office Excel.
Public classControlExtensionsProvides 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 classListObjectNotDataBoundExceptionThe exception that is thrown when you use the Disconnect method of a ListObject that is not bound to data.
Public classSetDataBindingFailedExceptionRepresents 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 classWorkbookBaseProvides the base class for the ThisWorkbook class in document-level projects for Microsoft Office Excel.
Public classWorksheetBaseProvides the base class for the Sheetn classes in document-level projects for Microsoft Office Excel.

  InterfaceDescription
Public interfaceActionRepresents a smart tag action in an Excel workbook that is customized by using the Office development tools in Visual Studio.
Public interfaceActionEventArgsProvides 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 interfaceApplicationFactoryProvides 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 interfaceBeforeAddDataBoundRowEventArgsProvides data for the BeforeAddDataBoundRow event.
Public interfaceChartRepresents an embedded chart in Office projects for Microsoft Office Excel.
Public interfaceChart_HasAxisTypeInfrastructure.
Public interfaceChartSheetRepresents a worksheet in document-level Excel projects created by using the Office development tools in Visual Studio.
Public interfaceChartSheet_HasAxisTypeInfrastructure.
Public interfaceControlCollectionRepresents a collection of managed controls on an Excel worksheet in an Office solution.
Public interfaceControlSiteRepresents a linked or embedded control on a worksheet.
Public interfaceErrorAddDataBoundRowEventArgsProvides information for the ErrorAddDataBoundRow event.
Public interfaceFactoryProvides 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 interfaceIChartSheetExtensionRepresents an extension of a ChartSheet object.
Public interfaceISmartTagExtensionRepresents 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 interfaceIWorkbookExtensionRepresents an extension of a Workbook object.
Public interfaceIWorksheetExtensionRepresents an extension of a Worksheet object.
Public interfaceListObjectThe ListObject control displays data in a series of rows and columns.
Public interfaceNamedRangeA NamedRange control is a range that has a unique name, exposes events, and can be bound to data.
Public interfaceNamedRange_AddressLocalTypeInfrastructure.
Public interfaceNamedRange_AddressTypeInfrastructure.
Public interfaceNamedRange_CharactersTypeInfrastructure.
Public interfaceNamedRange_EndTypeInfrastructure.
Public interfaceNamedRange_ItemTypeInfrastructure.
Public interfaceNamedRange_OffsetTypeInfrastructure.
Public interfaceNamedRange_ResizeTypeInfrastructure.
Public interfaceOriginalDataRestoredEventArgsProvides data for an OriginalDataRestored event.
Public interfaceSmartTagRepresents a smart tag in an Excel workbook that is customized by using the Office development tools in Visual Studio.
Public interfaceSmartTagRecognizeContextProvides the context of a call to a custom smart tag recognizer.
Public interfaceWorkbookRepresents a workbook in Excel projects created by using the Office development tools in Visual Studio.
Public interfaceWorkbook_ColorsTypeInfrastructure.
Public interfaceWorksheetRepresents a worksheet in Excel projects created by using the Office development tools in Visual Studio.
Public interfaceWorksheet_RangeTypeInfrastructure.
Public interfaceXmlMappedRangeAn XmlMappedRange control is a range that is created when a non-repeating schema element is mapped onto a cell.
Public interfaceXmlMappedRange_AddressLocalTypeInfrastructure.
Public interfaceXmlMappedRange_AddressTypeInfrastructure.
Public interfaceXmlMappedRange_CharactersTypeInfrastructure.
Public interfaceXmlMappedRange_EndTypeInfrastructure.
Public interfaceXmlMappedRange_ItemTypeInfrastructure.
Public interfaceXmlMappedRange_OffsetTypeInfrastructure.
Public interfaceXmlMappedRange_ResizeTypeInfrastructure.

  DelegateDescription
Public delegateActionClickEventHandlerRepresents the method that will handle the Click event of an Action.
Public delegateBeforeAddDataBoundRowEventHandlerRepresents the method that will handle the BeforeAddDataBoundRow event of a ListObject.
Public delegateBeforeCaptionShowEventHandlerRepresents the method that will handle the BeforeCaptionShow event of an Action.
Public delegateErrorAddDataBoundRowEventHandlerRepresents the method that handles an ErrorAddDataBoundRow event.
Public delegateListObjectChangeHandlerRepresents the method that will handle the Change event of a ListObject.
Public delegateOriginalDataRestoredEventHandlerRepresents a method that handles the OriginalDataRestored event.
Public delegateWorkbookEvents_NewEventHandlerRepresents the method that will handle the New event of a Workbook.

  EnumerationDescription
Public enumerationChangeReasonProvides the reason that the original data was restored to a ListObject that is bound to data.
Public enumerationChangeTypeProvides information about how a ListObject control restored data that was changed by a user.
Public enumerationFailureReasonProvides the reason why the ListObject data binding failed.
Public enumerationFormatSettingsSpecifies the type of formatting that is applied to the ListObject when it is bound to data.
Public enumerationListRangesSpecifies the range of a ListObject that has changes.
Show:
© 2015 Microsoft