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: