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.

ClassDescription
System_CAPS_pubclassChartSheetBase

Provides the base class for chart sheet host items in document-level Office projects for Microsoft Office Excel.

System_CAPS_pubclassControlExtensions

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.

System_CAPS_pubclassListObjectNotDataBoundException

The exception that is thrown when you use the Disconnect method of a ListObject that is not bound to data.

System_CAPS_pubclassSetDataBindingFailedException

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.

System_CAPS_pubclassWorkbookBase

Provides the base class for the ThisWorkbook class in document-level projects for Microsoft Office Excel.

System_CAPS_pubclassWorksheetBase

Provides the base class for the Sheetn classes in document-level projects for Microsoft Office Excel.

InterfaceDescription
System_CAPS_pubinterfaceAction

Represents a smart tag action in an Excel workbook that is customized by using the Office development tools in Visual Studio.

System_CAPS_pubinterfaceActionEventArgs

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.

.

System_CAPS_pubinterfaceApplicationFactory

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.

System_CAPS_pubinterfaceBeforeAddDataBoundRowEventArgs

Provides data for the BeforeAddDataBoundRow event.

System_CAPS_pubinterfaceChart

Represents an embedded chart in Office projects for Microsoft Office Excel.

System_CAPS_pubinterfaceChart_HasAxisType

This API supports the product infrastructure and is not intended to be used directly from your code.

System_CAPS_pubinterfaceChartSheet

Represents a worksheet in document-level Excel projects created by using the Office development tools in Visual Studio.

System_CAPS_pubinterfaceChartSheet_HasAxisType

This API supports the product infrastructure and is not intended to be used directly from your code.

System_CAPS_pubinterfaceControlCollection

Represents a collection of managed controls on an Excel worksheet in an Office solution.

System_CAPS_pubinterfaceControlSite

Represents a linked or embedded control on a worksheet.

System_CAPS_pubinterfaceErrorAddDataBoundRowEventArgs

Provides information for the ErrorAddDataBoundRow event.

System_CAPS_pubinterfaceFactory

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.

System_CAPS_pubinterfaceIChartSheetExtension

Represents an extension of a ChartSheet object.

System_CAPS_pubinterfaceISmartTagExtension

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.

System_CAPS_pubinterfaceIWorkbookExtension

Represents an extension of a Workbook object.

System_CAPS_pubinterfaceIWorksheetExtension

Represents an extension of a Worksheet object.

System_CAPS_pubinterfaceListObject

The ListObject control displays data in a series of rows and columns.

System_CAPS_pubinterfaceNamedRange

A NamedRange control is a range that has a unique name, exposes events, and can be bound to data.

System_CAPS_pubinterfaceNamedRange_AddressLocalType

This API supports the product infrastructure and is not intended to be used directly from your code.

System_CAPS_pubinterfaceNamedRange_AddressType

This API supports the product infrastructure and is not intended to be used directly from your code.

System_CAPS_pubinterfaceNamedRange_CharactersType

This API supports the product infrastructure and is not intended to be used directly from your code.

System_CAPS_pubinterfaceNamedRange_EndType

This API supports the product infrastructure and is not intended to be used directly from your code.

System_CAPS_pubinterfaceNamedRange_ItemType

This API supports the product infrastructure and is not intended to be used directly from your code.

System_CAPS_pubinterfaceNamedRange_OffsetType

This API supports the product infrastructure and is not intended to be used directly from your code.

System_CAPS_pubinterfaceNamedRange_ResizeType

This API supports the product infrastructure and is not intended to be used directly from your code.

System_CAPS_pubinterfaceOriginalDataRestoredEventArgs

Provides data for an OriginalDataRestored event.

System_CAPS_pubinterfaceSmartTag

Represents a smart tag in an Excel workbook that is customized by using the Office development tools in Visual Studio.

System_CAPS_pubinterfaceSmartTagRecognizeContext

Provides the context of a call to a custom smart tag recognizer.

System_CAPS_pubinterfaceWorkbook

Represents a workbook in Excel projects created by using the Office development tools in Visual Studio.

System_CAPS_pubinterfaceWorkbook_ColorsType

This API supports the product infrastructure and is not intended to be used directly from your code.

System_CAPS_pubinterfaceWorksheet

Represents a worksheet in Excel projects created by using the Office development tools in Visual Studio.

System_CAPS_pubinterfaceWorksheet_RangeType

This API supports the product infrastructure and is not intended to be used directly from your code.

System_CAPS_pubinterfaceXmlMappedRange

An XmlMappedRange control is a range that is created when a non-repeating schema element is mapped onto a cell.

System_CAPS_pubinterfaceXmlMappedRange_AddressLocalType

This API supports the product infrastructure and is not intended to be used directly from your code.

System_CAPS_pubinterfaceXmlMappedRange_AddressType

This API supports the product infrastructure and is not intended to be used directly from your code.

System_CAPS_pubinterfaceXmlMappedRange_CharactersType

This API supports the product infrastructure and is not intended to be used directly from your code.

System_CAPS_pubinterfaceXmlMappedRange_EndType

This API supports the product infrastructure and is not intended to be used directly from your code.

System_CAPS_pubinterfaceXmlMappedRange_ItemType

This API supports the product infrastructure and is not intended to be used directly from your code.

System_CAPS_pubinterfaceXmlMappedRange_OffsetType

This API supports the product infrastructure and is not intended to be used directly from your code.

System_CAPS_pubinterfaceXmlMappedRange_ResizeType

This API supports the product infrastructure and is not intended to be used directly from your code.

DelegateDescription
System_CAPS_pubdelegateActionClickEventHandler

Represents the method that will handle the Click event of an Action.

System_CAPS_pubdelegateBeforeAddDataBoundRowEventHandler

Represents the method that will handle the BeforeAddDataBoundRow event of a ListObject.

System_CAPS_pubdelegateBeforeCaptionShowEventHandler

Represents the method that will handle the BeforeCaptionShow event of an Action.

System_CAPS_pubdelegateErrorAddDataBoundRowEventHandler

Represents the method that handles an ErrorAddDataBoundRow event.

System_CAPS_pubdelegateListObjectChangeHandler

Represents the method that will handle the Change event of a ListObject.

System_CAPS_pubdelegateOriginalDataRestoredEventHandler

Represents a method that handles the OriginalDataRestored event.

System_CAPS_pubdelegateWorkbookEvents_NewEventHandler

Represents the method that will handle the New event of a Workbook.

EnumerationDescription
System_CAPS_pubenumChangeReason

Provides the reason that the original data was restored to a ListObject that is bound to data.

System_CAPS_pubenumChangeType

Provides information about how a ListObject control restored data that was changed by a user.

System_CAPS_pubenumFailureReason

Provides the reason why the ListObject data binding failed.

System_CAPS_pubenumFormatSettings

Specifies the type of formatting that is applied to the ListObject when it is bound to data.

System_CAPS_pubenumListRanges

Specifies the range of a ListObject that has changes.

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

Return to top
Show: