Dela via

Microsoft.Office.Tools.Excel Namespace (2007 System)

  • Artikel

The Microsoft.Office.Tools.Excel namespace contains a set of classes that extend and support the Microsoft Office Excel object model in projects created by using Visual Studio Tools for Office. The types in this namespace can be used only in Visual Studio Tools for Office projects. For more information about these projects, see Visual Studio Tools for Office Project Templates Overview.

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

Classes

  Class Description
Public class Action Represents a Visual Studio Tools for Office smart tag action in a Microsoft Office Excel workbook.
Public class ActionEventArgs Provides data for the Click and BeforeCaptionShow events.
Public class BeforeAddDataBoundRowEventArgs Provides data for the BeforeAddDataBoundRow event.
Public class Chart Represents an embedded chart in Visual Studio Tools for Office projects for Microsoft Office Excel.
Public class Chart._HasAxisType Infrastructure.
Public class ChartSheet A ChartSheet host item is a worksheet in Excel that contains only a chart and exposes events.
Public class ChartSheet._HasAxisType Infrastructure.
Public class ControlCollection Represents a collection of managed controls on an Excel worksheet that is part of a Visual Studio Tools for Office solution.
Public class ControlCollectionEnumerator An enumerator that iterates through the ControlCollection instance.
Public class ErrorAddDataBoundRowEventArgs Provides information for the ErrorAddDataBoundRow event.
Public class ExcelLocale1033Attribute Specifies 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 class ExcelLocale1033Proxy Provides methods that modify how a specified native Microsoft Office Excel object passes locale ID (LCID) information to the Excel object model.
Public class ListObject The ListObject control displays data in a series of rows and columns.
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 NamedRange A NamedRange control is a range that has a unique name, exposes events, and can be bound to data. For more information, see NamedRange Control.
Public class NamedRange._AddressLocalType Infrastructure.
Public class NamedRange._AddressType Infrastructure.
Public class NamedRange._CharactersType Infrastructure.
Public class NamedRange._EndType Infrastructure.
Public class NamedRange._ItemType Infrastructure.
Public class NamedRange._OffsetType Infrastructure.
Public class NamedRange._ResizeType Infrastructure.
Public class OLEObject Represents a linked or embedded control on a worksheet.
Public class OriginalDataRestoredEventArgs Provides data for an OriginalDataRestored event.
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 SmartTag Represents a smart tag in Microsoft Office Excel.
Public class Workbook Represents a workbook in Visual Studio Tools for Office projects for Microsoft Office Excel. 
Public class Workbook._ColorsType Infrastructure.
Public class Worksheet Represents a worksheet that exposes events and acts as a container for controls in Visual Studio Tools for Office projects for Microsoft Office Excel.
Public class Worksheet._RangeType Infrastructure.
Public class XmlMappedRange An XMLMappedRange control is a range that is created when a non-repeating schema element is mapped onto a cell.
Public class XmlMappedRange._AddressLocalType Infrastructure.
Public class XmlMappedRange._AddressType Infrastructure.
Public class XmlMappedRange._CharactersType Infrastructure.
Public class XmlMappedRange._EndType Infrastructure.
Public class XmlMappedRange._ItemType Infrastructure.
Public class XmlMappedRange._OffsetType Infrastructure.
Public class XmlMappedRange._ResizeType Infrastructure.

Interfaces

  Interface Description
Public interface IListObjectDesignSupport 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