This documentation is archived and is not being maintained.

Microsoft.Office.Tools.Excel Namespace

The Microsoft.Office.Tools.Excel namespace contains a set of classes that extend and support the Microsoft Office Excel object model.

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

Public classActionRepresents a Visual Studio Tools for Office smart tag action in a Microsoft Office Excel workbook.
Public classActionEventArgsProvides data for the Click and BeforeCaptionShow events.
Public classBeforeAddDataBoundRowEventArgsProvides data for the BeforeAddDataboundRow event.
Public classChartThe Chart control is a chart object that exposes events and can be bound to data.
Public classChart._HasAxisType 
Public classChartSheetA Microsoft.Office.Tools.Excel.ChartSheet host item is a worksheet in Excel that contains only a chart and exposes events.
Public classChartSheet._HasAxisType 
Public classControlCollectionRepresents a collection of controls.
Public classControlCollectionEnumeratorAn enumerator that iterates through the ControlCollection instance.
Public classErrorAddDataBoundRowEventArgsProvides information for the ErrorAddDataBoundRow event.
Public classExcelLocale1033AttributeSpecifies 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.
Public classExcelLocale1033ProxyProvides methods that modify how a specified native Microsoft Office Excel object passes locale ID (LCID) information to the Excel object model.
Public classListObjectThe ListObject control displays data in a series of rows and columns.
Public classListObjectNotDataBoundExceptionThe exception that is thrown when you use the Disconnect method of a ListObject that is not bound to data.
Public classNamedRangeA NamedRange control is a range that has a unique name, exposes events, and can be bound to data.
Public classNamedRange._AddressLocalType 
Public classNamedRange._AddressType 
Public classNamedRange._CharactersType 
Public classNamedRange._EndType 
Public classNamedRange._ItemType 
Public classNamedRange._OffsetType 
Public classNamedRange._ResizeType 
Public classOLEObjectRepresents a linked or embedded control on a worksheet.
Public classOriginalDataRestoredEventArgsProvides data for an OriginalDataRestored event.
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 classSmartTagRepresents a smart tag in Microsoft Office Excel.
Public classWorkbookRepresents a Microsoft.Office.Interop.Excel.Workbook object that exposes events and acts as a container for components.
Public classWorkbook._ColorsType 
Public classWorksheetThe Microsoft.Office.Tools.Excel.Worksheet host item is a Microsoft.Office.Interop.Excel.Worksheet object that exposes events and acts as a container for controls.
Public classWorksheet._RangeType 
Public classXmlMappedRangeAn XMLMappedRange control is a range that is created when a non-repeating schema element is mapped onto a cell.
Public classXmlMappedRange._AddressLocalType 
Public classXmlMappedRange._AddressType 
Public classXmlMappedRange._CharactersType 
Public classXmlMappedRange._EndType 
Public classXmlMappedRange._ItemType 
Public classXmlMappedRange._OffsetType 
Public classXmlMappedRange._ResizeType 
Public classXmlMappedRange._ValueType 

Public interfaceIListObjectDesignSupport 

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 handles the New event on the Workbook.

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.