Microsoft.Office.Interop.Excel Namespace

Classes

AppEvents_SinkHelper

Reserved for internal use.

ApplicationClass

Reserved for internal use.

ChartClass

Reserved for internal use.

ChartEvents_SinkHelper

Reserved for internal use.

DocEvents_SinkHelper

Reserved for internal use.

GlobalClass

Reserved for internal use.

OLEObjectClass

Reserved for internal use.

OLEObjectEvents_SinkHelper

Reserved for internal use.

QueryTableClass

Reserved for internal use.

RefreshEvents_SinkHelper

Reserved for internal use.

WorkbookClass

Reserved for internal use.

WorkbookEvents_SinkHelper

Reserved for internal use.

WorksheetClass

Reserved for internal use.

Interfaces

_Application

This is a primary interface in a COM coclass that is required by managed code for interoperability with the corresponding COM object. Use this primary interface only when the method you want to use shares the same name as an event of the COM object; in this case, cast to this interface to call the method, and cast to the latest events interface to connect to the event. Otherwise, use the .NET interface that is derived from the COM coclass to access methods, properties, and events of the COM object. For more information about the COM object, see Application.

_Chart

This is a primary interface in a COM coclass that is required by managed code for interoperability with the corresponding COM object. Use this primary interface only when the method you want to use shares the same name as an event of the COM object; in this case, cast to this interface to call the method, and cast to the latest events interface to connect to the event. Otherwise, use the .NET interface that is derived from the COM coclass to access methods, properties, and events of the COM object. For more information about the COM object, see Chart.

_Global

This is a primary interface in a COM coclass that is required by managed code for interoperability with the corresponding COM object. Use this primary interface only when the method you want to use shares the same name as an event of the COM object; in this case, cast to this interface to call the method, and cast to the latest events interface to connect to the event. Otherwise, use the .NET interface that is derived from the COM coclass to access methods, properties, and events of the COM object. For more information about the COM object, see Global.

_IOLEObject

Reserved for internal use.

_IQueryTable

Reserved for internal use.

_OLEObject

This is a primary interface in a COM coclass that is required by managed code for interoperability with the corresponding COM object. Use this primary interface only when the method you want to use shares the same name as an event of the COM object; in this case, cast to this interface to call the method, and cast to the latest events interface to connect to the event. Otherwise, use the .NET interface that is derived from the COM coclass to access methods, properties, and events of the COM object. For more information about the COM object, see OLEObject.

_QueryTable

This is a primary interface in a COM coclass that is required by managed code for interoperability with the corresponding COM object. Use this primary interface only when the method you want to use shares the same name as an event of the COM object; in this case, cast to this interface to call the method, and cast to the latest events interface to connect to the event. Otherwise, use the .NET interface that is derived from the COM coclass to access methods, properties, and events of the COM object. For more information about the COM object, see QueryTable.

_Workbook

This is a primary interface in a COM coclass that is required by managed code for interoperability with the corresponding COM object. Use this primary interface only when the method you want to use shares the same name as an event of the COM object; in this case, cast to this interface to call the method, and cast to the latest events interface to connect to the event. Otherwise, use the .NET interface that is derived from the COM coclass to access methods, properties, and events of the COM object. For more information about the COM object, see Workbook.

_Worksheet

This is a primary interface in a COM coclass that is required by managed code for interoperability with the corresponding COM object. Use this primary interface only when the method you want to use shares the same name as an event of the COM object; in this case, cast to this interface to call the method, and cast to the latest events interface to connect to the event. Otherwise, use the .NET interface that is derived from the COM coclass to access methods, properties, and events of the COM object. For more information about the COM object, see Worksheet.

AboveAverage

Represents an above average visual of a conditional formatting rule. Applying a color or fill to a range or selection to help you see the value of a cells relative to other cells.

Action

Represents an action to be executed in PivotTable or Worksheetdata.

Actions

A collection of all Action objects for the specified series.

AddIn

Represents a single add-in, either installed or not installed.

AddIns

A collection of AddIn objects that represents all the add-ins available to Microsoft Excel, regardless of whether they’re installed. This list corresponds to the list of add-ins displayed in the Add-Ins dialog box (Tools menu).

AddIns2

A collection of AddIn objects that represent all the add-ins that are currently available or open in Microsoft Excel, regardless of whether they are installed.

Adjustments

Contains a collection of adjustment values for the specified AutoShape, WordArt object, or connector.

AllowEditRange

Represents the cells that can be edited on a protected worksheet.

AllowEditRanges

A collection of all the AllowEditRange objects that represent the cells that can be edited on a protected worksheet.

AppEvents

Reserved for internal use.

AppEvents_Event

Events interface for Microsoft Excel Application object events.

Application

Represents the entire Microsoft Excel application.

Arc

Reserved for internal use.

Arcs

Reserved for internal use.

Areas

A collection of the areas, or contiguous blocks of cells, within a selection.

AutoCorrect

Contains Microsoft Excel AutoCorrect attributes (capitalization of names of days, correction of two initial capital letters, automatic correction list, and so on).

AutoFilter

Represents autofiltering for the specified worksheet.

AutoRecover

Represents the automatic recovery features of a workbook.

Axes

A collection of all the Axis objects in the specified chart.

Axis

Represents a single axis in a chart.

AxisTitle

Represents a chart axis title.

Border

Represents the border of an object.

Borders

A collection of four Border objects that represent the four borders of a Range or Style object.

Button

Reserved for internal use.

Buttons

Reserved for internal use.

CalculatedFields

A collection of PivotField objects that represents all the calculated fields in the specified PivotTable report.

CalculatedItems

A collection of PivotItem objects that represent all the calculated items in the specified PivotTable report.

CalculatedMember

Represents the calculated fields and calculated items for PivotTables with Online Analytical Processing (OLAP) data sources.

CalculatedMembers

A collection of all the CalculatedMember objects on the specified PivotTable.

CalloutFormat

Contains properties and methods that apply to line callouts.

CategoryCollection

Represents the collection of visible chart categories in the chart.

CellFormat

Represents the search criteria for the cell format.

Characters

Represents characters in an object that contains text. The Characters object lets you modify any sequence of characters contained in the full text string.

Chart

Represents a chart in a workbook. The chart can be either an embedded chart (contained in a ChartObject) or a separate chart sheet.

ChartArea

Represents the chart area of a chart. The chart area on a 2-D chart contains the axes, the chart title, the axis titles, and the legend. The chart area on a 3-D chart contains the chart title and the legend; it doesn’t include the plot area (the area within the chart area where the data is plotted). For information about formatting the plot area, see the PlotArea object.

ChartCategory

Specifies a chart type's category.

ChartColorFormat

Used only with charts. Represents the color of a one-color object or the foreground or background color of an object with a gradient or patterned fill.

ChartEvents

This object has chart events.

ChartEvents_Event

Events interface for Microsoft Excel Chart object events.

ChartFillFormat

Used only with charts. Represents fill formatting for chart elements.

ChartFormat

Provides access to the Office Art formatting for chart elements.

ChartGroup

Represents one or more series plotted in a chart with the same format. The ChartGroup object is a member of the ChartGroups collection.

ChartGroups

A collection of all the ChartGroup objects in the specified chart.

ChartObject

Represents an embedded chart on a worksheet.

ChartObjects

A collection of all the ChartObject objects on the specified chart sheet, dialog sheet, or worksheet.

Charts

A collection of all the chart sheets in the specified or active workbook. Each chart sheet is represented by a Chart object. This doesn’t include charts embedded on worksheets or dialog sheets. For information about embedded charts, see the ChartObject object.

ChartTitle

Represents the chart title.

ChartView

Represents a view of a chart.

CheckBox

Reserved for internal use.

CheckBoxes

Reserved for internal use.

ColorFormat

Represents the color of a one-color object, the foreground or background color of an object with a gradient or patterned fill, or the pointer color.

ColorScale

Represents a color scale conditional formatting rule.

ColorScaleCriteria

A collection of ColorScaleCriterion objects that represents all of the criteria for a color scale conditional format. Each criterion specifies the minimum, midpoint, or maximum threshold for the color scale.

ColorScaleCriterion

Represents the criteria for the minimum, midpoint, or maximum thresholds for a color format conditional format.

ColorStop

Represents the color stop point for a gradient fill in an range or selection.

ColorStops

A collection of all the ColorStop objects for the specified series.

Comment

Represents a cell comment.

Comments

A collection of cell comments. Each comment is represented by a Comment object.

ConditionValue

Represents how the shortest bar or longest bar is evaluated for a data bar conditional formatting rule.

Connections

A collection of Connection objects for the specified workbook.

ConnectorFormat

Contains properties and methods that apply to connectors.

ControlFormat

Contains Microsoft Excel control properties.

Corners

Represents the corners of a 3-D chart.

CubeField

Represents a hierarchy or measure field from an OLAP cube.

CubeFields

A collection of all CubeField objects in a PivotTable report that is based on an OLAP cube.

CustomProperties

A collection of CustomProperty objects that represent additional information. The information can be used as metadata for XML.

CustomProperty

Represents identifier information. Identifier information can be used as metadata for XML.

CustomView

Represents a custom workbook view.

CustomViews

A collection of custom workbook views. Each view is represented by a CustomView object.

Databar

Represents a data bar conditional formating rule. Applying a data bar to a range helps you see the value of a cell relative to other cells.

DataBarBorder

Represents the border of the data bars specified by a conditional formatting rule.

DataFeedConnection

Contains the data and functionality needed to connect to data feeds. The same object is used for all Data Feed types.

DataLabel

Represents the data label on a chart point or trendline.

DataLabels

A collection of all the DataLabel objects for the specified series. Each DataLabel object represents a data label for a point or trendline. For a series without definable points (such as an area series), the DataLabels collection contains a single data label.

DataTable

Represents a chart data table.

DefaultWebOptions

Contains global application-level attributes used by Microsoft Excel when you save a document as a Web page or open a Web page.

Diagram

Represents a diagram.

DiagramNode

Represents a node in a diagram.

DiagramNodeChildren

A collection of DiagramNode objects that represents child nodes in a diagram.

DiagramNodes

A collection of DiagramNode objects that represents all the nodes in a diagram.

Dialog

Represents a built-in Microsoft Excel dialog box.

DialogFrame

Reserved for internal use.

Dialogs

A collection of all the Dialog objects in Microsoft Excel.

DialogSheet

Reserved for internal use.

DialogSheets

Reserved for internal use.

DialogSheetView

Represents the current Dialogsheet view in a workbook.

DisplayFormat

Represents the display settings for an associated Range object.

DisplayUnitLabel

Represents a unit label on an axis in the specified chart.

DocEvents

Reserved for internal use.

DocEvents_Event

Events interface for Microsoft Excel Worksheet object events.

DownBars

Represents the down bars in a chart group.

Drawing

Reserved for internal use.

DrawingObjects

Reserved for internal use.

Drawings

Reserved for internal use.

DropDown

Reserved for internal use.

DropDowns

Reserved for internal use.

DropLines

Represents the drop lines in a chart group.

EditBox

Reserved for internal use.

EditBoxes

Reserved for internal use.

Error

Represents a spreadsheet error for a range.

ErrorBars

Represents the error bars on a chart series.

ErrorCheckingOptions

Represents the error-checking options for an application.

Errors

Represents the various spreadsheet errors for a range.

FileExportConverter

Represents a file converter that is used to save files.

FileExportConverters

A collection of FileExportConverter objects that represent all the file converters available for saving files.

FillFormat

Represents fill formatting for a shape.

Filter

Represents a filter for a single column. The Filter object is a member of the Filters collection. The Filters collection contains all the filters in an autofiltered range.

Filters

A collection of Filter objects that represents all the filters in an autofiltered range.

Floor

Represents the floor of a 3-D chart.

Font

Contains the font attributes (font name, font size, color, and so on) for an object.

FormatColor

Represents the fill color specified for a threshold of a color scale conditional format or the color of the bar in a data bar conditional format.

FormatCondition

Represents a conditional format.

FormatConditions

Represents the collection of conditional formats for a single range.

FreeformBuilder

Represents the geometry of a freeform while it’s being built.

FullSeriesCollection

Represents the full set of Series objects in a chart.

Global

This is a .NET interface derived from a COM coclass that is required by managed code for interoperability with the corresponding COM object. Use this derived interface to access all method, property, and event members of the COM object. However, if a method or event you want to use shares the same name under the same COM object, cast to the corresponding primary interface to call the method, and cast to the latest events interface to connect to the event. Refer to this topic for information about the COM object. For information about the method and property members of the COM object, see _Global.

Graphic

Contains properties that apply to header and footer picture objects.

Gridlines

Represents major or minor gridlines on a chart axis.

GroupBox

Reserved for internal use.

GroupBoxes

Reserved for internal use.

GroupObject

Reserved for internal use.

GroupObjects

Reserved for internal use.

GroupShapes

Represents the individual shapes within a grouped shape.

HeaderFooter

Represents a single header or footer.

HiLoLines

Represents the high-low lines in a chart group.

HPageBreak

Represents a horizontal page break.

HPageBreaks

The collection of horizontal page breaks within the print area. Each horizontal page break is represented by an HPageBreak object.

Hyperlink

Represents a hyperlink.

Hyperlinks

Represents the collection of hyperlinks for a worksheet or range. Each hyperlink is represented by a Hyperlink object.

IAboveAverage

Reserved for internal use.

IAction

Reserved for internal use.

IActions

Reserved for internal use.

IAddIn

Reserved for internal use.

IAddIns

Reserved for internal use.

IAddIns2

Reserved for internal use.

IAllowEditRange

Reserved for internal use.

IAllowEditRanges

Reserved for internal use.

IAppEvents

Reserved for internal use.

IArc

Reserved for internal use.

IArcs

Reserved for internal use.

IAreas

Reserved for internal use.

IAutoCorrect

Reserved for internal use.

IAutoFilter

Reserved for internal use.

IAutoRecover

Reserved for internal use.

IAxes

Reserved for internal use.

IAxis

Reserved for internal use.

IAxisTitle

Reserved for internal use.

IBorder

Reserved for internal use.

IBorders

Reserved for internal use.

IButton

Reserved for internal use.

IButtons

Reserved for internal use.

ICalculatedFields

Reserved for internal use.

ICalculatedItems

Reserved for internal use.

ICalculatedMember

Reserved for internal use.

ICalculatedMembers

Reserved for internal use.

ICanvasShapes

Reserved for internal use.

ICategoryCollection
ICellFormat

Reserved for internal use.

ICharacters

Reserved for internal use.

IChartArea

Reserved for internal use.

IChartCategory
IChartColorFormat

Reserved for internal use.

IChartEvents

Reserved for internal use.

IChartFillFormat

Reserved for internal use.

IChartFormat

Reserved for internal use.

IChartGroup

Reserved for internal use.

IChartGroups

Reserved for internal use.

IChartObject

Reserved for internal use.

IChartObjects

Reserved for internal use.

ICharts

Reserved for internal use.

IChartTitle

Reserved for internal use.

IChartView

Reserved for internal use.

ICheckBox

Reserved for internal use.

ICheckBoxes

Reserved for internal use.

IColorScale

Reserved for internal use.

IColorScaleCriteria

Reserved for internal use.

IColorScaleCriterion

Reserved for internal use.

IColorStop

Reserved for internal use.

IColorStops

Reserved for internal use.

IComment

Reserved for internal use.

IComments

Reserved for internal use.

Icon

Represents a single icon in an icon set used in a conditional formatting rule.

IconCriteria

Represents the collection of IconCriterion objects. Each IconCriterion represents the values and threshold type for each icon in an icon set conditional formatting rule.

IconCriterion

Represents the criterion for an individual icon in an icon set. The criterion specifies the range of values and the threshold type associated with the icon in an icon set conditional formatting rule.

IConditionValue

Reserved for internal use.

IConnections

Reserved for internal use.

IConnectorFormat

Reserved for internal use.

IconSet

Represents a single set of icons that are used in an icon set conditional formatting rule.

IconSetCondition

Represents an icon set conditional formatting rule.

IconSets

Represents a collection of icon sets used in an icon set conditional formatting rule.

IControlFormat

Reserved for internal use.

ICorners

Reserved for internal use.

ICustomProperties

Reserved for internal use.

ICustomProperty

Reserved for internal use.

ICustomView

Reserved for internal use.

ICustomViews

Reserved for internal use.

IDatabar

Reserved for internal use.

IDataBarBorder
IDataFeedConnection
IDataLabel

Reserved for internal use.

IDataLabels

Reserved for internal use.

IDataTable

Reserved for internal use.

IDiagram

Reserved for internal use.

IDialog

Reserved for internal use.

IDialogFrame

Reserved for internal use.

IDialogs

Reserved for internal use.

IDialogSheet

Reserved for internal use.

IDialogSheets

Reserved for internal use.

IDialogSheetView

Reserved for internal use.

IDisplayFormat
IDisplayUnitLabel

Reserved for internal use.

IDocEvents

Reserved for internal use.

IDownBars

Reserved for internal use.

IDrawing

Reserved for internal use.

IDrawingObjects

Reserved for internal use.

IDrawings

Reserved for internal use.

IDropDown

Reserved for internal use.

IDropDowns

Reserved for internal use.

IDropLines

Reserved for internal use.

IDummy

Reserved for internal use.

IEditBox

Reserved for internal use.

IEditBoxes

Reserved for internal use.

IError

Reserved for internal use.

IErrorBars

Reserved for internal use.

IErrorCheckingOptions

Reserved for internal use.

IErrors

Reserved for internal use.

IFileExportConverter

Reserved for internal use.

IFileExportConverters

Reserved for internal use.

IFilter

Reserved for internal use.

IFilters

Reserved for internal use.

IFloor

Reserved for internal use.

IFont

Reserved for internal use.

IFormatColor

Reserved for internal use.

IFormatCondition

Reserved for internal use.

IFormatConditions

Reserved for internal use.

IFreeformBuilder

Reserved for internal use.

IFullSeriesCollection
IGraphic

Reserved for internal use.

IGridlines

Reserved for internal use.

IGroupBox

Reserved for internal use.

IGroupBoxes

Reserved for internal use.

IGroupObject

Reserved for internal use.

IGroupObjects

Reserved for internal use.

IGroupShapes

Reserved for internal use.

IHeaderFooter

Reserved for internal use.

IHiLoLines

Reserved for internal use.

IHPageBreak

Reserved for internal use.

IHPageBreaks

Reserved for internal use.

IHyperlink

Reserved for internal use.

IHyperlinks

Reserved for internal use.

IIcon

Reserved for internal use.

IIconCriteria

Reserved for internal use.

IIconCriterion

Reserved for internal use.

IIconSet

Reserved for internal use.

IIconSetCondition

Reserved for internal use.

IIconSets

Reserved for internal use.

IInterior

Reserved for internal use.

ILabel

Reserved for internal use.

ILabels

Reserved for internal use.

ILeaderLines

Reserved for internal use.

ILegend

Reserved for internal use.

ILegendEntries

Reserved for internal use.

ILegendEntry

Reserved for internal use.

ILegendKey

Reserved for internal use.

ILine

Reserved for internal use.

ILinearGradient

Reserved for internal use.

ILines

Reserved for internal use.

ILinkFormat

Reserved for internal use.

IListBox

Reserved for internal use.

IListBoxes

Reserved for internal use.

IListColumn

Reserved for internal use.

IListColumns

Reserved for internal use.

IListDataFormat

Reserved for internal use.

IListObject

Reserved for internal use.

IListObjects

Reserved for internal use.

IListRow

Reserved for internal use.

IListRows

Reserved for internal use.

IMailer

Reserved for internal use.

IMenu

Reserved for internal use.

IMenuBar

Reserved for internal use.

IMenuBars

Reserved for internal use.

IMenuItem

Reserved for internal use.

IMenuItems

Reserved for internal use.

IMenus

Reserved for internal use.

IModel
IModelChanges
IModelColumnChange
IModelColumnChanges
IModelColumnName
IModelColumnNames
IModelConnection
IModelMeasureName
IModelMeasureNames
IModelRelationship
IModelRelationships
IModelTable
IModelTableColumn
IModelTableColumns
IModelTableNameChange
IModelTableNameChanges
IModelTableNames
IModelTables
IModule

Reserved for internal use.

IModules

Reserved for internal use.

IModuleView

Reserved for internal use.

IMultiThreadedCalculation

Reserved for internal use.

IName

Reserved for internal use.

INames

Reserved for internal use.

INegativeBarFormat

Reserved for internal use.

Interior

Represents the interior of an object.

IODBCConnection

Reserved for internal use.

IODBCError

Reserved for internal use.

IODBCErrors

Reserved for internal use.

IOLEDBConnection

Reserved for internal use.

IOLEDBError

Reserved for internal use.

IOLEDBErrors

Reserved for internal use.

IOLEFormat

Reserved for internal use.

IOLEObjectEvents

Reserved for internal use.

IOLEObjects

Reserved for internal use.

IOptionButton

Reserved for internal use.

IOptionButtons

Reserved for internal use.

IOutline

Reserved for internal use.

IOval

Reserved for internal use.

IOvals

Reserved for internal use.

IPage

Reserved for internal use.

IPages

Reserved for internal use.

IPageSetup

Reserved for internal use.

IPane

Reserved for internal use.

IPanes

Reserved for internal use.

IParameter

Reserved for internal use.

IParameters

Reserved for internal use.

IPhonetic

Reserved for internal use.

IPhonetics

Reserved for internal use.

IPicture

Reserved for internal use.

IPictures

Reserved for internal use.

IPivotAxis

Reserved for internal use.

IPivotCache

Reserved for internal use.

IPivotCaches

Reserved for internal use.

IPivotCell

Reserved for internal use.

IPivotField

Reserved for internal use.

IPivotFields

Reserved for internal use.

IPivotFilter

Reserved for internal use.

IPivotFilters

Reserved for internal use.

IPivotFormula

Reserved for internal use.

IPivotFormulas

Reserved for internal use.

IPivotItem

Reserved for internal use.

IPivotItemList

Reserved for internal use.

IPivotItems

Reserved for internal use.

IPivotLayout

Reserved for internal use.

IPivotLine

Reserved for internal use.

IPivotLineCells

Reserved for internal use.

IPivotLines

Reserved for internal use.

IPivotTable

Reserved for internal use.

IPivotTableChangeList
IPivotTables

Reserved for internal use.

IPivotValueCell
IPlotArea

Reserved for internal use.

IPoint

Reserved for internal use.

IPoints

Reserved for internal use.

IProtectedViewWindow

Reserved for internal use.

IProtectedViewWindows

Reserved for internal use.

IProtection

Reserved for internal use.

IPublishObjects

Reserved for internal use.

IQueryTables

Reserved for internal use.

IQuickAnalysis
IRange

Reserved for internal use.

IRanges

Reserved for internal use.

IRecentFile

Reserved for internal use.

IRecentFiles

Reserved for internal use.

IRectangle

Reserved for internal use.

IRectangles

Reserved for internal use.

IRectangularGradient

Reserved for internal use.

IRefreshEvents

Reserved for internal use.

IResearch

Reserved for internal use.

IRoutingSlip

Reserved for internal use.

IRTD

Reserved for internal use.

IRtdServer

Represents an interface for a real-time data server.

IRTDUpdateEvent

Represents real-time data update events.

IScenario

Reserved for internal use.

IScenarios

Reserved for internal use.

IScrollBar

Reserved for internal use.

IScrollBars

Reserved for internal use.

ISeries

Reserved for internal use.

ISeriesCollection

Reserved for internal use.

ISeriesLines

Reserved for internal use.

IServerViewableItems

Reserved for internal use.

IShape

Reserved for internal use.

IShapeRange

Reserved for internal use.

IShapes

Reserved for internal use.

ISheetViews

Reserved for internal use.

ISlicer

Reserved for internal use.

ISlicerCache

Reserved for internal use.

ISlicerCacheLevel

Reserved for internal use.

ISlicerCacheLevels

Reserved for internal use.

ISlicerCaches

Reserved for internal use.

ISlicerItem

Reserved for internal use.

ISlicerItems

Reserved for internal use.

ISlicerPivotTables

Reserved for internal use.

ISlicers

Reserved for internal use.

ISmartTag

Reserved for internal use.

ISmartTagAction

Reserved for internal use.

ISmartTagActions

Reserved for internal use.

ISmartTagOptions

Reserved for internal use.

ISmartTagRecognizer

Reserved for internal use.

ISmartTagRecognizers

Reserved for internal use.

ISmartTags

Reserved for internal use.

ISort

Reserved for internal use.

ISortField

Reserved for internal use.

ISortFields

Reserved for internal use.

ISoundNote

Reserved for internal use.

ISparkAxes

Reserved for internal use.

ISparkColor

Reserved for internal use.

ISparkHorizontalAxis

Reserved for internal use.

ISparkline

Reserved for internal use.

ISparklineGroup

Reserved for internal use.

ISparklineGroups

Reserved for internal use.

ISparkPoints

Reserved for internal use.

ISparkVerticalAxis

Reserved for internal use.

ISpeech

Reserved for internal use.

ISpellingOptions

Reserved for internal use.

ISpinner

Reserved for internal use.

ISpinners

Reserved for internal use.

IStyle

Reserved for internal use.

IStyles

Reserved for internal use.

ITab

Reserved for internal use.

ITableObject
ITableStyle

Reserved for internal use.

ITableStyleElement

Reserved for internal use.

ITableStyleElements

Reserved for internal use.

ITableStyles

Reserved for internal use.

ITextBox

Reserved for internal use.

ITextBoxes

Reserved for internal use.

ITextConnection
ITextFrame

Reserved for internal use.

ITickLabels

Reserved for internal use.

ITimelineState
ITimelineViewState
IToolbar

Reserved for internal use.

IToolbarButton

Reserved for internal use.

IToolbarButtons

Reserved for internal use.

IToolbars

Reserved for internal use.

ITop10

Reserved for internal use.

ITrendline

Reserved for internal use.

ITrendlines

Reserved for internal use.

IUniqueValues

Reserved for internal use.

IUpBars

Reserved for internal use.

IUsedObjects

Reserved for internal use.

IUserAccess

Reserved for internal use.

IUserAccessList

Reserved for internal use.

IValidation

Reserved for internal use.

IValueChange

Reserved for internal use.

IVPageBreak

Reserved for internal use.

IVPageBreaks

Reserved for internal use.

IWalls

Reserved for internal use.

IWatch

Reserved for internal use.

IWatches

Reserved for internal use.

IWindow

Reserved for internal use.

IWindows

Reserved for internal use.

IWorkbookConnection

Reserved for internal use.

IWorkbookEvents

Reserved for internal use.

IWorksheetDataConnection
IWorksheetFunction

Reserved for internal use.

IWorksheets

Reserved for internal use.

IWorksheetView

Reserved for internal use.

IXmlDataBinding

Reserved for internal use.

IXmlMap

Reserved for internal use.

IXmlMaps

Reserved for internal use.

IXmlNamespace

Reserved for internal use.

IXmlNamespaces

Reserved for internal use.

IXmlSchema

Reserved for internal use.

IXmlSchemas

Reserved for internal use.

IXPath

Reserved for internal use.

Label

Reserved for internal use.

Labels

Reserved for internal use.

LeaderLines

Represents leader lines on a chart.

Legend

Represents the legend in a chart.

LegendEntries

A collection of all the LegendEntry objects in the specified chart legend.

LegendEntry

Represents a legend entry in a chart legend.

LegendKey

Represents a legend key in a chart legend.

Line

Reserved for internal use.

LinearGradient

The LinearGradient object transitions through a series of colors in a linear manner along a specific angle.

LineFormat

Represents line and arrowhead formatting.

Lines

Reserved for internal use.

LinkFormat

Contains linked OLE object properties.

ListBox

Reserved for internal use.

ListBoxes

Reserved for internal use.

ListColumn

Represents a column in a list. The ListColumn object is a member of the ListColumns collection. The ListColumns collection contains all the columns in a list (ListObject object).

ListColumns

A collection of all the ListColumn objects in the specified ListObject object. Each ListColumn object represents a column in the list.

ListDataFormat

The ListDataFormat object holds all the data type properties of the ListColumn object. These properties are read-only.

ListObject

Represents a list object on a worksheet.

ListObjects

A collection of all the ListObject objects on a worksheet. Each ListObject object represents a list in the worksheet.

ListRow

Represents a row in a List object. The ListRow object is a member of the ListRows collection. The ListRows collection contains all the rows in a list object.

ListRows

A collection of all the ListRow objects in the specified ListObject object. Each ListRow object represents a row in the list.

Mailer

You have requested Help for a Visual Basic keyword used only on the Macintosh. For information about this keyword, consult the language reference Help included with Microsoft Office Macintosh Edition.

Menu

Reserved for internal use.

MenuBar

Reserved for internal use.

MenuBars

Reserved for internal use.

MenuItem

Reserved for internal use.

MenuItems

Reserved for internal use.

Menus

Reserved for internal use.

Model

Stores references to workbook connections and information about the tables and relationships contained within the Data Model.

ModelChanges

Represents changes made to the data model.

ModelColumnChange

An object representing a column in a table in the Excel data model for which the data type was changed.

ModelColumnChanges

A collection of ModelColumnChange objects representing columns for which the data type was change in the Excel data model.

ModelColumnName

An object representing the name of a column in the data model.

ModelColumnNames

A collection of ModelColumnName objects representing columns of tables in the data model.

ModelConnection

Contain information for the new Model Connection Type introduced in Excel 2013 to interact with the integrated data model.

ModelMeasureName

An object representing a measure in the data model.

ModelMeasureNames

A collection of ModelMeasureName objects representing names of measures in the Excel data model.

ModelRelationship
ModelRelationships

This collection contains all relationships currently between data tables in the data model of Excel 2013.

ModelTable
ModelTableColumn

Represent a single column inside a ModelTable object.

ModelTableColumns

Represent a ModelTableColumn collection of single columns inside a ModelTable object.

ModelTableNameChange

An object representing the old and new name of a table which was renamed in the Excel data model.

ModelTableNameChanges

A collection of ModelTableNameChange objects representing table names before and after a table name change in the Excel data model.

ModelTableNames

A collection of table names representing tables in the Excel data model.

ModelTables

Collection of model tables inside the Data Model.

Module

Reserved for internal use.

Modules

Reserved for internal use.

ModuleView

Represents existing Moduleviews in the workbook.

MultiThreadedCalculation

Returns or sets the concurrent calculation mode.

Name

Represents a defined name for a range of cells.

Names

A collection of all the Name objects in the application or workbook. Each Name object represents a defined name for a range of cells. Names can be either built-in names — such as Database, Print_Area, and Auto_Open — or custom names.

NegativeBarFormat

Represents the color settings of the data bars for negative values that are defined by a data bar conditional formating rule.

ODBCConnection

Represents the ODBC connection.

ODBCError

Represents an ODBC error generated by the most recent ODBC query.

ODBCErrors

A collection of ODBCError objects.

OLEDBConnection

Represents the OLE DB connection.

OLEDBError

Represents an OLE DB error returned by the most recent OLE DB query.

OLEDBErrors

A collection of OLEDBError objects.

OLEFormat

Contains OLE object properties.

OLEObject

Represents an ActiveX control or a linked or embedded OLE object on a worksheet. The OLEObject object is a member of the OLEObjects collection. The OLEObjects collection contains all the OLE objects on a single worksheet.

OLEObjectEvents

Reserved for internal use.

OLEObjectEvents_Event

Events interface for Microsoft Excel OLEObject object events.

OLEObjects

A collection of all the OLEObject objects on the specified worksheet. Each OLEObject object represents an ActiveX control or a linked or embedded OLE object.

OptionButton

Reserved for internal use.

OptionButtons

Reserved for internal use.

Outline

Represents an outline on a worksheet.

Oval

Reserved for internal use.

Ovals

Reserved for internal use.

Page

Represents a page in a workbook. Use the PageSetup object and the related methods and properties for programmatically defining page layout in a workbook.

Pages

A collection of pages in a document. Use the Pages collection and the related objects and properties for programmatically defining page layout in a workbook.

PageSetup

Represents the page setup description. The PageSetup object contains all page setup attributes (left margin, bottom margin, paper size, and so on) as properties.

Pane

Represents a pane of a window.

Panes

A collection of all the Pane objects shown in the specified window.

Parameter

Represents a single parameter used in a parameter query. The Parameter object is a member of the Parameters collection.

Parameters

A collection of Parameter objects for the specified query table. Each Parameter object represents a single query parameter. Every query table contains a Parameters collection, but the collection is empty unless the query table is using a parameter query.

Phonetic

Contains information about a specific phonetic text string in a cell.

Phonetics

A collection of all the Phonetic objects in the specified range. Each Phonetic object contains information about a specific phonetic text string.

Picture

Reserved for internal use.

PictureFormat

Contains properties and methods that apply to pictures and OLE objects.

Pictures

Reserved for internal use.

PivotAxis
PivotCache

Represents the memory cache for a PivotTable report.

PivotCaches

Represents the collection of memory caches from the PivotTable reports in a workbook.

PivotCell

Represents a cell in a PivotTable report.

PivotField

Represents a field in a PivotTable report. The PivotField object is a member of the PivotFields collection. The PivotFields collection contains all the fields in a PivotTable report, including hidden fields.

PivotFields

A collection of all the PivotField objects in a PivotTable report.

PivotFilter

A PivotFilter is applied to a PivotField object.

PivotFilters

The PivotFilters object is a collection of PivotFilter objects.

PivotFormula

Represents a formula used to calculate results in a PivotTable report.

PivotFormulas

Represents the collection of formulas for a PivotTable report. Each formula is represented by a PivotFormula object.

PivotItem

Represents an item in a PivotTable field. The items are the individual data entries in a field category. The PivotItem object is a member of the PivotItems collection. The PivotItems collection contains all the items in a PivotField object.

PivotItemList

A collection of all the PivotItem objects in the specified PivotTable. Each PivotItem represents an item in a PivotTable field.

PivotItems

A collection of all the PivotItem objects in a PivotTable field. The items are the individual data entries in a field category.

PivotLayout

Represents the placement of fields in a PivotChart report.

PivotLine

A PivotLine object is a line of rows or columns in an Excel PivotTable.

PivotLineCells

Collection of PivotCell objects for a specific PivotLine.

PivotLines

The PivotLines object is a collection of lines in a PivotTable, containing all lines on rows or columns of the pivot. Each line is a set of PivotCells.

PivotTable

Represents a PivotTable report on a worksheet. The PivotTable object is a member of the PivotTables collection. The PivotTables collection contains all the PivotTable objects on a single worksheet.

PivotTableChangeList

Represents the list of changes a user has made to value cells in a PivotTable report based on an OLAP data source.

PivotTables

A collection of all the PivotTable objects on the specified worksheet.

PivotValueCell

Provides a way to expose values of cells in the case that actual cells (Range objects) are not available.

PlotArea

Represents the plot area of a chart. This is the area where your chart data is plotted.

Point

Represents a single point in a series in a chart.

Points

A collection of all the Point objects in the specified series in a chart.

ProtectedViewWindow

Represents a Protected View window.

ProtectedViewWindows

A collection of the ProtectedViewWindow objects that represent all the Protected View windows that are currently open in the application.

Protection

Represents the various types of protection options available for a worksheet.

PublishObject

Represents an item in a workbook that has been saved to a Web page and can be refreshed according to values specified by the properties and methods of the PublishObject object.

PublishObjects

A collection of all PublishObject objects in the workbook. Each PublishObject object represents an item in a workbook that has been saved to a Web page and can be refreshed according to values specified by the properties and methods of the object.

QueryTable

Represents a worksheet table built from data returned from an external data source, such as a SQL server or a Microsoft Access database. The QueryTable object is a member of the QueryTables collection.

QueryTables

A collection of QueryTable objects. Each QueryTable object represents a worksheet table built from data returned from an external data source.

QuickAnalysis

Object that enables single-click access to data analysis features such as formulas, conditional formatting, sparklines, tables, charts, and PivotTables.

Range

Represents a cell, a row, a column, a selection of cells containing one or more contiguous blocks of cells, or a 3-D range.

Ranges

A collection of Range objects.

RecentFile

Represents a file in the list of recently used files.

RecentFiles

Represents the list of recently used files. Each file is represented by a RecentFile object.

Rectangle

Reserved for internal use.

Rectangles

Reserved for internal use.

RectangularGradient

The RectangularGradient object transitions through a series of colors in a linear manner along a specific angle.

RefreshEvents

Reserved for internal use.

RefreshEvents_Event

Events interface for Microsoft Excel QueryTable object events.

Research

Represents the controls of a Research query.

RoutingSlip

Represents the routing slip for a workbook. The routing slip is used to send a workbook through the electronic mail system.

RTD

Represents a real-time data object.

Scenario

Represents a scenario on a worksheet. A scenario is a group of input values (called changing cells) that’s named and saved.

Scenarios

A collection of all the Scenario objects on the specified worksheet. A scenario is a group of input values (called changing cells) that’s named and saved.

ScrollBar

Reserved for internal use.

ScrollBars

Reserved for internal use.

Series

Represents a series in a chart. The Series object is a member of the SeriesCollection collection.

SeriesCollection

A collection of all the Series objects in the specified chart or chart group.

SeriesLines

Represents series lines in a chart group. Series lines connect the data values from each series.

ServerViewableItems

A collection of objects that have been marked as viewable on the server.

ShadowFormat

Represents shadow formatting for a Shape.

Shape

Represents an object in the drawing layer, such as an AutoShape, freeform, OLE object, or picture. The Shape object is a member of the Shapes collection. The Shapes collection contains all the shapes on a slide.

ShapeNode

Represents the geometry and the geometry-editing properties of the nodes in a user-defined freeform.

ShapeNodes

A collection of all the ShapeNode objects in the specified freeform.

ShapeRange

Represents a shape range, which is a set of shapes on a document.

Shapes

A collection of all the Shape objects on the specified sheet.

Sheets

A collection of all the sheets in the specified or active workbook.

SheetViews

A collection of all the sheet views in the specified or active workbook window.

Slicer

Represents a slicer in a workbook.

SlicerCache

Represents the current filter state for a slicer and information about which PivotCache or WorkbookConnection the slicer is connected to.

SlicerCacheLevel

Represents a level of a hierarchy in an OLAP data source being filtered by a slicer.

SlicerCacheLevels

Represents the collection of hierarchy levels for the OLAP data source that is filtered by a slicer.

SlicerCaches

Represents the collection of slicer caches associated with the specified workbook.

SlicerItem

Represents an item in a slicer.

SlicerItems

Represents the collection of SlicerItem objects contained in a SlicerCache or SlicerCacheLevel object.

SlicerPivotTables

Represents information about the collection of PivotTables associated with the specified SlicerCache object.

Slicers

A collection of Slicer objects.

SmartTag

Represents an identifier that is assigned to a cell.

SmartTagAction

Represents the actions that can be performed with smart tags.

SmartTagActions

A collection of SmartTagAction objects that represent the actions that can be performed with smart tags.

SmartTagOptions

Represents the options that can be performed with smart tags.

SmartTagRecognizer

Represents recognition engines which label data with types of information as you work in Microsoft Excel.

SmartTagRecognizers

A collection of SmartTagRecognizer objects that represent recognition engines that label data with types of information as you work in Microsoft Excel.

SmartTags

A collection of SmartTag objects that represent the identifiers assigned to each cell.

Sort

Represents a sort of a range of data.

SortField

The SortField object contains all the sort information for the Worksheet, ListObject, and AutoFilter objects.

SortFields

The SortFields collection is a collection of SortField objects. It allows developers to store a sort state on workbooks, lists, and autofilters.

SoundNote

This object should not be used. Sound notes have been removed from Microsoft Excel.

SparkAxes

Represents the settings for the horizontal and vertical axes of a group of sparklines.

SparkColor

Represents the color of the markers for points in a sparkline.

SparkHorizontalAxis

Represents the settings for the horizontal axes of a group of sparklines.

Sparkline

Represents a single sparkline.

SparklineGroup

Represents a group of sparklines.

SparklineGroups

Represents a collection of sparkline groups.

SparkPoints

Represents the settings of the markers for points of data on a sparkline.

SparkVerticalAxis

Represents the settings for the vertical axes of a group of sparklines.

Speech

Contains methods and properties that pertain to speech.

SpellingOptions

Represents the various spell-checking options for a worksheet.

Spinner

Reserved for internal use.

Spinners

Reserved for internal use.

Style

Represents a style description for a range.

Styles

A collection of all the Style objects in the specified or active workbook.

Tab

Represents a tab in a chart or a worksheet.

TableObject

Represents a worksheet table built from data returned from a PowerPivot model.

TableStyle

Represents a single style that can be applied to a table.

TableStyleElement

Represents a single table style element.

TableStyleElements

Represents table style elements.

TableStyles

Represents styles that can be applied to a table.

TextBox

Reserved for internal use.

TextBoxes

Reserved for internal use.

TextConnection

Contains Service Contract settings that enable Excel to connect to a Data Feed data source.

TextEffectFormat

Contains properties and methods that apply to WordArt objects.

TextFrame

Represents the text frame in a Shape object. Contains the text in the text frame as well as the properties and methods that control the alignment and anchoring of the text frame.

TextFrame2

Represents the text frame in a Shape, ShapeRange, or ChartFormat object.

ThreeDFormat

Represents a shape's three-dimensional formatting.

TickLabels

Represents the tick mark labels associated with tick marks on a chart axis.

TimelineState

The timeline-specific state of a SlicerCache object.

TimelineViewState

Represents the Timeline-specific members of a Slicer view.

Toolbar

Reserved for internal use.

ToolbarButton

Reserved for internal use.

ToolbarButtons

Reserved for internal use.

Toolbars

Reserved for internal use.

Top10

Represents a top ten visual of a conditional formatting rule. Applying a color to a range helps you see the value of a cell relative to other cells.

TreeviewControl

Represents the hierarchical member-selection control of a cube field. You use this object primarily for macro recording; it is not intended for any other use.

Trendline

Represents a trendline in a chart. A trendline shows the trend, or direction, of data in a series.

Trendlines

A collection of all the Trendline objects for the specified series. Each Trendline object represents a trendline in a chart. A trendline shows the trend, or direction, of data in a series.

UniqueValues

The UniqueValues object uses the DupeUnique property to returns or sets an enum that determines whether the rule should look for duplicate or unique values in the range.

UpBars

Represents the up bars in a chart group. Up bars connect points on series one with higher values on the last series in the chart group (the lines go up from series one).

UsedObjects

Represents objects that have been allocated in a workbook.

UserAccess

Represents the user access for a protected range.

UserAccessList

A collection of UserAccess objects that represent the user access for protected ranges.

Validation

Represents data validation for a worksheet range.

ValueChange

Represents a value that has been changed in a PivotTable report that is based on an OLAP data source.

VPageBreak

Represents a vertical page break.

VPageBreaks

A collection of vertical page breaks within the print area. Each vertical page break is represented by a VPageBreak object.

Walls

Represents the walls of a 3-D chart.

Watch

Represents a range which is tracked when the worksheet is recalculated.

Watches

A collection of all the Watch objects in a specified application.

WebOptions

Contains workbook-level attributes used by Microsoft Excel when you save a document as a Web page or open a Web page.

Window

Represents a window. Many worksheet characteristics, such as scroll bars and gridlines, are actually properties of the window.

Windows

A collection of all the Window objects in Microsoft Excel.

Workbook

Represents a Microsoft Excel workbook.

WorkbookConnection

A connection is a set of information needed to obtain data from an external data source other than an 1st_Excel12 workbook.

WorkbookEvents

Reserved for internal use.

WorkbookEvents_Event

Events interface for ExcelWorkbook object events.

Workbooks

A collection of all the Workbook objects that are currently open in the Microsoft Excel application.

Worksheet

Represents a worksheet.

WorksheetDataConnection

Used to import data into the Data Model from data on the worksheet such as ranges and tables.

WorksheetFunction

Used as a container for Excel worksheet functions that can be called from Visual Basic.

Worksheets

A collection of all the Worksheet objects in the specified or active workbook. Each Worksheet object represents a worksheet.

WorksheetView

A collection of all the WorksheetView objects in the specified or active workbook.

XmlDataBinding

Represents the connection to the source data for an XmlMap object.

XmlMap

Represents an XML map that has been added to a workbook.

XmlMaps

Represents the collection of XmlMap objects that have been added to a workbook.

XmlNamespace

Represents a namespace that has been added to a workbook.

XmlNamespaces

Represents the collection of XmlNamespace objects in a workbook.

XmlSchema

Represents an XML schema contained by an XmlMap object.

XmlSchemas

Represents the collection of XmlSchema objects contained by an XmlMap object.

XPath

Represents an XPath that has been mapped to a Range or ListColumn object.

Enums

Constants

Specifies global constants used in Microsoft Excel.

XlAboveBelow

Specifies if the values are above or below average.

XlActionType

Specifies the action that should be performed.

XlAllocation

Specifies when to calculate changes when performing what-if analysis on a PivotTable based on an OLAP data source.

XlAllocationMethod

Specifies the method to use to allocate values when performing what-if analysis on a PivotTable report based on an OLAP data source.

XlAllocationValue

Specifies what value to allocate when performing what-if analysis on a PivotTable report based on an OLAP data source.

XlApplicationInternational

Specifies country/region and international settings.

XlApplyNamesOrder

Specifies which range name is listed first when a cell reference is replaced by a row-oriented and column-oriented range name.

XlArabicModes

Specifies spelling rules for the Arabic spelling checker.

XlArrangeStyle

Specifies how windows are arranged on the screen.

XlArrowHeadLength

Specifies the length of the arrowhead at the end of a line.

XlArrowHeadStyle

Specifies the type of arrowhead to apply to the line end.

XlArrowHeadWidth

Specifies the width of the arrowhead at the line end.

XlAutoFillType

Specifies how the target range is to be filled, based on the contents of the source range.

XlAutoFilterOperator

Specifies the operator to use to associate two criteria applied by a filter.

XlAxisCrosses

Specifies the point on the specified axis where the other axis crosses.

XlAxisGroup

Specifies the type of axis group.

XlAxisType

Specifies the axis type.

XlBackground

Specifies the background type for text in charts.

XlBarShape

Specifies the shape used with the 3-D bar or column chart.

XlBordersIndex

Specifies the border to be retrieved.

XlBorderWeight

Specifies the weight of the border around a range.

XlBuiltInDialog

Specifies which dialog box to display.

XlCalcFor

Specifies what should be calculated.

XlCalcMemNumberFormatType

Specifies the format of cell values that are based on the calculated member.

XlCalculatedMemberType

Specifies the type of a calculated member in a pivot table.

XlCalculation

Specifies the calculation mode.

XlCalculationInterruptKey

Specifies which key interrupts recalculation.

XlCalculationState

Specifies the calculation state of the application.

XlCategoryLabelLevel

Specifies the category labels for the category label levels.

XlCategoryType

Specifies the type of the category axis.

XlCellChangedState

Specifies whether a PivotTable value cell has been edited or recalculated since the PivotTable report was created or the last commit operation was performed.

XlCellInsertionMode

Specifies the way rows on the specified worksheet are added or deleted to accommodate the number of rows in a recordset returned by a query.

XlCellType

Specifies the type of cells.

XlChartElementPosition

Specifies the position of the chart element.

XlChartGallery

Specifies a chart gallery.

XlChartItem

Specifies the type of the chart item.

XlChartLocation

Specifies where to relocate a chart.

XlChartPicturePlacement

Specifies the placement of a user-selected picture on a bar in a 3-D bar or column.

XlChartPictureType

Specifies how pictures are displayed on a column, bar picture chart, or legend key.

XlChartSplitType

Specifies the values displayed in the second chart in a pie chart or a bar of pie chart.

XlChartType

Specifies the chart type.

XlCheckInVersionType

Specifies the type of version for the document checked in when using the CheckIn method. Applies to workbooks stored in a SharePoint library.

XlClipboardFormat

Specifies the format of an item on the Windows clipboard.

XlCmdType

Specifies the value of the CommandText property.

XlColorIndex

Specifies the color of a selected feature such as border, font, or fill.

XlColumnDataType

Specifies how a column is to be parsed.

XlCommandUnderlines

Specifies the state of the command underlines in Microsoft Excel for the Macintosh.

XlCommentDisplayMode

Specifies the way cells display comments and comment indicators.

XlConditionValueTypes

Specifies the types of condition values that can be used.

XlConnectionType

Specifies the type of database connection.

XlConsolidationFunction

Specifies the subtotal function.

XlContainsOperator

Specifies the operator used in a function.

XlCopyPictureFormat

Specifies the format of the picture being copied.

XlCorruptLoad

Specifies the processing for a file when it is opened.

XlCreator

Specifies the 32-bit creator code for Excel for Macintosh (decimal 1480803660, Hex 5843454C, string XCEL).

XlCredentialsMethod

Specifies the type of credentials method used.

XlCubeFieldSubType

Specifies the subtype of the CubeField.

XlCubeFieldType

Specifies whether the OLAP field is a hierarchy, set, or measure field.

XlCutCopyMode

Specifies whether status is Copy mode or Cut mode.

XlCVError

Specifies the cell error number and value.

XlDataBarAxisPosition

Specifies the axis position for a range of cells with conditional formatting as data bars.

XlDataBarBorderType

Specifies the border of a data bar.

XlDataBarFillType

Specifies how a data bar is filled with color.

XlDataBarNegativeColorType

Specifies whether to use the same border and fill color as postive data bars.

XlDataLabelPosition

Specifies where the data label is positioned.

XlDataLabelSeparator

Specifies the separator used with data labels.

XlDataLabelsType

Specifies the type of data label to apply.

XlDataSeriesDate

Specifies the type of date to apply to a data series.

XlDataSeriesType

Specifies the data series to create.

XlDeleteShiftDirection

Specifies how to shift cells to replace deleted cells.

XlDirection

Specifies the direction in which to move.

XlDisplayBlanksAs

Specifies how blank cells are plotted on a chart.

XlDisplayDrawingObjects

Specifies how shapes are displayed.

XlDisplayUnit

Specifies the display unit label for an axis.

XlDupeUnique

Specifies whether duplicate or unique values shoud be displayed.

XlDVAlertStyle

Specifies the icon used in message boxes displayed during validation.

XlDVType

Specifies the type of validation test to be performed in conjunction with values.

XlDynamicFilterCriteria

Specifies the filter criterion.

XlEditionFormat

Specifies the format of the published edition. This is Macintosh only and should not be used.

XlEditionOptionsOption

This enumeration is for Macintosh only and should not be used.

XlEditionType

Specifies the type of edition to be changed.

XlEnableCancelKey

Specifies how Microsoft Excel handles CTRL+BREAK (or ESC or COMMAND+PERIOD) user interruptions to the running procedure.

XlEnableSelection

Specifies what can be selected on the sheet.

XlEndStyleCap

Specifies the end style for error bars.

XlErrorBarDirection

Specifies which axis values are to receive error bars.

XlErrorBarInclude

Specifies which error bar parts to include.

XlErrorBarType

Specifies the range marked by error bars.

XlErrorChecks

Specifies the type of error object to be retrieved from the Errors collection.

XlFileAccess

Specifies the new access mode for the object.

XlFileFormat

Specifies the file format when saving the spreadsheet.

XlFileValidationPivotMode

Specifies how to validate the data caches for PivotTable reports.

XlFillWith

Specifies how to copy the range.

XlFilterAction

Specifies whether data is to be copied or left in place during a filter operation.

XlFilterAllDatesInPeriod

Specifies how dates should be filtered in the specified period.

XlFilterStatus

Used to return a status from filter functions.

XlFindLookIn

Specifies the type of data to search.

XlFixedFormatQuality

Specifies the quality of speadsheets saved in different fixed formats.

XlFixedFormatType

Specifies the type of file format.

XlFormatConditionOperator

Specifies the operator to use to compare a formula against the value in a cell or, for xlBetween and xlNotBetween, to compare two formulas.

XlFormatConditionType

Specifies whether the conditional format is based on a cell value or an expression.

XlFormatFilterTypes

Specifies the types of format filters.

XlFormControl

Specifies the type of the form control.

XlFormulaLabel

Specifies the formula label type for the specified range.

XlGenerateTableRefs

Specifies the type of table references.

XlGradientFillType

Specifies the type of gradient fill.

XlHAlign

Specifies the horizontal alignment for the object.

XlHebrewModes

Specifies the mode for the Hebrew spelling checker.

XlHighlightChangesTime

Specifies which set of changes is shown in a shared workbook.

XlHtmlType

Specifies the type of HTML generated by Microsoft Excel when you save the specified item to a Web page and whether the item is static or interactive.

XlIcon

Specifies the icon for a criterion in an icon set conditional formatting rule.

XlIconSet

Specifies the type of icon set.

XlIMEMode

Specifies the description of the Japanese input rules.

XlImportDataAs

Specifies the format in which to return data from a database.

XlInsertFormatOrigin

Specifies from where to copy the format for inserted rows.

XlInsertShiftDirection

Specifies the direction in which to shift cells during an insertion.

XlLayoutFormType

Specifies the way the specified PivotTable items appear—in table format or in outline format.

XlLayoutRowType

Specifies the type of layout row.

XlLegendPosition

Specifies the position of the legend on a chart.

XlLineStyle

Specifies the line style for the border.

XlLink

Specifies the type of link.

XlLinkInfo

Specifies the type of information to be returned.

XlLinkInfoType

Specifies the type of link.

XlLinkStatus

Specifies the status of a link.

XlLinkType

Specifies the type of link.

XlListConflict

Specifies the conflict resolution options for updating a list on a Microsoft Windows SharePoint Services site with the changes made to a list in a Microsoft Excel worksheet.

XlListDataType

Specifies the data type of a list column connected to a Microsoft Windows SharePoint Services site.

XlListObjectSourceType

Specifies the current source of the list.

XlLocationInTable

Specifies the part of the PivotTable report that contains the upper-left corner of a range.

XlLookAt

Specifies whether a match is made against the whole of the search text or any part of the search text.

XlLookFor

Specifies what to look for in searches.

XlMailSystem

Specifies the mail system that is installed on the host machine.

XlMarkerStyle

Specifies the marker style for a point or series in a line chart, scatter chart, or radar chart.

XlMeasurementUnits

Specifies the measurement units.

XlModelChangeSource

Specifies the source of the change to the data model.

XlMouseButton

Specifies which mouse button was pressed.

XlMousePointer

Specifies the appearance of the mouse pointer in Microsoft Excel.

XlMSApplication

Specifies a Microsoft application.

XlOartHorizontalOverflow

Specifies the horizontal overflow setting for a text frame.

XlOartVerticalOverflow

Specifies the vertical overflow setting for a text frame.

XlObjectSize

Specifies the way a chart is scaled to fit on a page.

XlOLEType

Specifies the OLE object type.

XlOLEVerb

Specifies the verb that the server of the OLE object should act on.

XlOrder

Specifies the order in which cells are processed.

XlOrientation

Specifies the text orientation.

XlPageBreak

Specifies page break location in the worksheet.

XlPageBreakExtent

Specifies whether a page break is full screen or applies only within the print area.

XlPageOrientation

Specifies the page orientation when the worksheet is printed.

XlPaperSize

Specifies the size of the paper.

XlParameterDataType

Specifies the data type of a query parameter.

XlParameterType

Specifies how to determine the value of the parameter for the specified query table.

XlPasteSpecialOperation

Specifies how numeric data will be calculated with the destinations cells in the worksheet.

XlPasteType

Specifies the part of the range to be pasted.

XlPattern

Specifies the interior pattern of a chart or interior object.

XlPhoneticAlignment

Specifies the alignment for phonetic text.

XlPhoneticCharacterType

Specifies the type of phonetic text in a cell.

XlPictureAppearance

Specifies how the picture should be copied.

XlPictureConvertorType

Specifies how to convert a graphic.

XlPieSliceIndex

Specifies which position on the slice to return the coordinate of.

XlPieSliceLocation

Specifies the horizontal or vertical position of a point on a pie chart, in points, from the top or left edge of the object to the top or left edge of the chart area.

XlPivotCellType

Specifies the PivotTable entity the cell corresponds to.

XlPivotConditionScope

This enumeration specifies the conditional formatting applied for filtering values from the PivotTable object.

XlPivotFieldCalculation

Specifies the type of calculation performed by a data PivotField when a custom calculation is used.

XlPivotFieldDataType

Specifies the type of data in the PivotTable field.

XlPivotFieldOrientation

Specifies the location of the field in a PivotTable report.

XlPivotFieldRepeatLabels

Specifies whether to repeat all field item labels in a PivotTable report.

XlPivotFilterType

The type of filter applied.

XlPivotFormatType

Specifies the type of report formatting to be applied to the specified PivotTable report.

XlPivotLineType

Specifies the type of the PivotLine.

XlPivotTableMissingItems

Specifies the maximum number of unique items per PivotField allowed.

XlPivotTableSourceType

Specifies the source of the report data.

XlPivotTableVersionList

Specifies the version of a PivotTable or a PivotCache. Creating PivotTables with a specific version ensures that tables created in behave in the same manner as they did in the corresponding version of Excel.

XlPlacement

Specifies the way an object is attached to its underlying cells.

XlPlatform

Specifies the platform that a text file originated on.

XlPortugueseReform

Specifies the mode for checking the spelling of Portuguese.

XlPrintErrors

Specifies the type of print error displayed.

XlPrintLocation

Specifies the way comments are printed with the sheet.

XlPriority

Specifies the priority of a SendMailer message.

XlPropertyDisplayedIn

Specifies where to display the property.

XlProtectedViewCloseReason

Specifies how the Protected View window was closed.

XlProtectedViewWindowState

Specifies the state of the Protected View window.

XlPTSelectionMode

Specifies what may be selected in a PivotTable during a structured selection. These constants may be combined to select multiple types.

XlQueryType

Specifies the type of query used by Microsoft Excel to populate the query table or PivotTable cache.

XlQuickAnalysisMode

Indicates for which top level button the callout user interface is displayed.

XlRangeAutoFormat

Specifies the predefined format when a range is automatically formatted.

XlRangeValueDataType

Specifies the range value data type.

XlReferenceStyle

Specifies the reference style.

XlReferenceType

Specifies cell reference style when a formula is being converted.

XlRemoveDocInfoType

Specifies the type information to be removed from the document information.

XlRgbColor

Specifies the RGB color.

XlRobustConnect

Specifies how the PivotTable cache connects to its data source.

XlRoutingSlipDelivery

Specifies the routing delivery method.

XlRoutingSlipStatus

Specifies the status of the routing slip.

XlRowCol

Specifies whether the values corresponding to a particular data series are in rows or columns.

XlRunAutoMacro

Specifies the automatic macro to run.

XlSaveAction

Specifies during file close if the file will be saved.

XlSaveAsAccessMode

Specifies the access mode for the Save As function.

XlSaveConflictResolution

Specifies the way conflicts are to be resolved whenever a shared workbook is updated.

XlScaleType

Specifies the scale type of the value axis.

XlSearchDirection

Specifies the search direction when searching a range.

XlSearchOrder

Specifies the order in which to search the range.

XlSearchWithin

Specifies the extent of the search for the range.

XlSeriesNameLevel

Specifies the series labels for the series label levels.

XlSheetType

Specifies the worksheet type.

XlSheetVisibility

Specifies whether the object is visible.

XlSizeRepresents

Specifies what the bubble size represents on a bubble chart.

XlSlicerCacheType

Designates the type of slicer or slicer cache.

XlSlicerCrossFilterType

Specifies the type of cross filtering used by the specified slicer cache and how it is visualized.

XlSlicerSort

Specifies whether items displayed in the slicer are sorted, and if they are sorted, whether they are sorted in ascending or descending order by item captions.

XlSmartTagControlType

Specifies the type of Smart Document control displayed in the Document Actions task pane.

XlSmartTagDisplayMode

Specifies the display features for smart tags.

XlSortDataOption

Specifies how to sort text.

XlSortMethod

Specifies the type of sort.

XlSortMethodOld

Specifies how to sort when using East Asian sorting methods.

XlSortOn

Specifies the parameter on which the data should be sorted.

XlSortOrder

Specifies the sort order for the specified field or range.

XlSortOrientation

Specifies the sort orientation.

XlSortType

Specifies which elements are to be sorted. Use this argument only when sorting PivotTable reports.

XlSourceType

Identifies the source object.

XlSpanishModes

Specifies the mode for checking the spelling of Spanish.

XlSparklineRowCol

Specifies how to plot the sparkline when the data on which it is based is in a square-shaped range.

XlSparkScale

Specifies how the minimum or maximum value of the vertical axis of the sparkline is scaled relative to other sparklines in the group.

XlSparkType

Specifies the type of sparkline.

XlSpeakDirection

Specifies the order in which the cells are spoken.

XlSpecialCellsValue

Specifies cells with a particular type of value to include in the result.

XlStdColorScale

Specifies the standard color scale.

XlSubscribeToFormat

Specifies the format to use when subscribing to a published edition.

XlSubtototalLocationType

Specifies where the subtotal will be displayed on the worksheet.

XlSummaryColumn

Specifies the location of the summary columns in the outline.

XlSummaryReportType

Specifies the type of summary to be created for scenarios.

XlSummaryRow

Specifies the location of the summary rows in the outline.

XlTableStyleElementType

Specifies the table style element used.

XlTabPosition

Specifies the first or last tab position.

XlTextParsingType

Specifies the column format for the data in the text file that you’re importing into a query table.

XlTextQualifier

Specifies the delimiter to use to specify text.

XlTextVisualLayoutType

Specifies whether the visual layout of the text being imported is left-to-right or right-to-left.

XlThemeColor

Specifies the theme color to be used.

XlThemeFont

Specifies the theme font to use.

XlThreadMode

Specifies the control over the multi-threaded calculation mode.

XlTickLabelOrientation

Specifies the text orientation for tick-mark labels.

XlTickLabelPosition

Specifies the position of tick-mark labels on the specified axis.

XlTickMark

Specifies the position of major and minor tick marks for an axis.

XlTimelineLevel

One of the built-in hierarchy levels that Timeline supports.

XlTimePeriods

Specifies the time period.

XlTimeUnit

Specifies unit of time for chart axis and data series.

XlToolbarProtection

Specifies which properties of a toolbar are restricted. Options may be combined using Or.

XlTopBottom

Specifies the top 10 values from the top or bottom of a series of values.

XlTotalsCalculation

Specifies the type of calculation in the Totals row of a list column.

XlTrendlineType

Specifies how the trendline that smoothes out fluctuations in the data is calculated.

XlUnderlineStyle

Specifies the type of underline applied to a font.

XlUpdateLinks

Specifies a workbook's setting for updating embedded OLE links.

XlVAlign

Specifies the vertical alignment for the object.

XlWBATemplate

Specifies the type of workbook to create.

XlWebFormatting

Specifies how much formatting from a Web page, if any, is applied when a Web page is imported into a query table.

XlWebSelectionType

Specifies whether an entire Web page, all tables on the Web page, or only a specific table is imported into a query table.

XlWindowState

Specifies the state of the window.

XlWindowType

Specifies how the chart is displayed.

XlWindowView

Specifies the view showing in the window.

XlXLMMacroType

Specifies, in a Microsoft Excel version 4 macro worksheet, what type of macro a name refers to or whether the name refers to a macro.

XlXmlExportResult

Specifies the results of the save or export operation.

XlXmlImportResult

Specifies the results of the refresh or import operation.

XlXmlLoadOption

Specifies how Excel opens the XML data file.

XlYesNoGuess

Specifies whether or not the first row contains headers.

Delegates

AppEvents_AfterCalculateEventHandler

A Delegate type used to add an event handler for the AfterCalculate event. The AfterCalculate event occurs when all pending refresh activity (both synchronous and asynchronous) and all of the resultant calculation activities have been completed.

AppEvents_NewWorkbookEventHandler

A Delegate type used to add an event handler for the NewWorkbook event. The NewWorkbook event occurs when a new workbook is created.

AppEvents_ProtectedViewWindowActivateEventHandler

A Delegate type used to add an event handler for the ProtectedViewWindowActivate event. The ProtectedViewWindowActivate event occurs when a Protected View window is activated.

AppEvents_ProtectedViewWindowBeforeCloseEventHandler

A Delegate type used to add an event handler for the ProtectedViewWindowBeforeClose event. The ProtectedViewWindowBeforeClose event occurs immediately before a Protected View window or a workbook in a Protected View window closes.

AppEvents_ProtectedViewWindowBeforeEditEventHandler

A Delegate type used to add an event handler for the ProtectedViewWindowBeforeEdit event. The ProtectedViewWindowBeforeEdit event occurs immediately before editing is enabled on the workbook in the specified Protected View window.

AppEvents_ProtectedViewWindowDeactivateEventHandler

A Delegate type used to add an event handler for the ProtectedViewWindowDeactivate event. The ProtectedViewWindowDeactivate event occurs when a Protected View window is deactivated.

AppEvents_ProtectedViewWindowOpenEventHandler

A Delegate type used to add an event handler for the ProtectedViewWindowOpen event. The ProtectedViewWindowOpen event occurs when a workbook is opened in a Protected View window.

AppEvents_ProtectedViewWindowResizeEventHandler

A Delegate type used to add an event handler for the ProtectedViewWindowResize event. The ProtectedViewWindowResize event occurs when any Protected View window is resized.

AppEvents_SheetActivateEventHandler

A Delegate type used to add an event handler for the SheetActivate event. The SheetActivate event occurs when any sheet is activated.

AppEvents_SheetBeforeDeleteEventHandler

A Delegate type used to add an event handler for the SheetBeforeDelete event. The SheetBeforeDelete event occurs before any sheet is deleted.

AppEvents_SheetBeforeDoubleClickEventHandler

A Delegate type used to add an event handler for the SheetBeforeDoubleClick event. The SheetBeforeDoubleClick event occurs when any worksheet is double-clicked, before the default double-click action.

AppEvents_SheetBeforeRightClickEventHandler

A Delegate type used to add an event handler for the SheetBeforeRightClick event. The SheetBeforeRightClick event occurs when any worksheet is right-clicked, before the default right-click action.

AppEvents_SheetCalculateEventHandler

A Delegate type used to add an event handler for the SheetCalculate event. The SheetCalculate event occurs after any worksheet is recalculated or after any changed data is plotted on a chart.

AppEvents_SheetChangeEventHandler

A Delegate type used to add an event handler for the SheetChange event. The SheetChange event occurs when cells in any worksheet are changed by the user or by an external link.

AppEvents_SheetDeactivateEventHandler

A Delegate type used to add an event handler for the SheetDeactivate event. The SheetDeactivate event occurs when any sheet is deactivated.

AppEvents_SheetFollowHyperlinkEventHandler

A Delegate type used to add an event handler for the SheetFollowHyperlink event. The SheetFollowHyperlink event occurs when you click any hyperlink in Microsoft Excel.

AppEvents_SheetLensGalleryRenderCompleteEventHandler

A Delegate type used to add an event handler for the SheetLensGalleryRenderComplete event. The SheetLensGalleryRenderComplete event occurs after a callout gallery’s icons (dynamic and static) have finished rendering.

AppEvents_SheetPivotTableAfterValueChangeEventHandler

A Delegate type used to add an event handler for the SheetPivotTableAfterValueChange event. The SheetPivotTableAfterValueChange event occurs after a cell or range of cells inside a PivotTable are edited or recalculated (for cells that contain formulas).

AppEvents_SheetPivotTableBeforeAllocateChangesEventHandler

A Delegate type used to add an event handler for the SheetPivotTableBeforeAllocateChanges event. The SheetPivotTableBeforeAllocateChanges event occurs before changes are applied to a PivotTable.

AppEvents_SheetPivotTableBeforeCommitChangesEventHandler

A Delegate type used to add an event handler for the SheetPivotTableBeforeCommitChanges event. The SheetPivotTableBeforeCommitChanges event occurs before changes are committed against the OLAP data source for a PivotTable.

AppEvents_SheetPivotTableBeforeDiscardChangesEventHandler

A Delegate type used to add an event handler for the SheetPivotTableBeforeDiscardChanges event. The SheetPivotTableBeforeDiscardChanges event occurs before changes to a PivotTable are discarded.

AppEvents_SheetPivotTableUpdateEventHandler

A Delegate type used to add an event handler for the SheetPivotTableUpdate event. The SheetPivotTableUpdate event occurs after the sheet of the PivotTable report has been updated.

AppEvents_SheetSelectionChangeEventHandler

A Delegate type used to add an event handler for the SheetSelectionChange event. The SheetSelectionChange event occurs when the selection changes on any worksheet.

AppEvents_SheetTableUpdateEventHandler

A Delegate type used to add an event handler for the SheetTableUpdate event. The SheetTableUpdate event occurs when a table on a worksheet is updated.

AppEvents_WindowActivateEventHandler

A Delegate type used to add an event handler for the WindowActivate event. The WindowActivate event occurs when any workbook window is activated.

AppEvents_WindowDeactivateEventHandler

A Delegate type used to add an event handler for the WindowDeactivate event. The WindowDeactivate event occurs when any workbook window is deactivated.

AppEvents_WindowResizeEventHandler

A Delegate type used to add an event handler for the WindowResize event. The WindowResize event occurs when any workbook window is resized.

AppEvents_WorkbookActivateEventHandler

A Delegate type used to add an event handler for the WorkbookActivate event. The WorkbookActivate event occurs when any workbook is activated.

AppEvents_WorkbookAddinInstallEventHandler

A Delegate type used to add an event handler for the WorkbookAddinInstall event. The WorkbookAddinInstall event occurs when a workbook is installed as an add-in.

AppEvents_WorkbookAddinUninstallEventHandler

A Delegate type used to add an event handler for the WorkbookAddinUninstall event. The WorkbookAddinUninstall event occurs when any add-in workbook is uninstalled.

AppEvents_WorkbookAfterSaveEventHandler

A Delegate type used to add an event handler for the WorkbookAfterSave event. The WorkbookAfterSave event occurs after the workbook is saved.

AppEvents_WorkbookAfterXmlExportEventHandler

A Delegate type used to add an event handler for the WorkbookAfterXmlExport event. The WorkbookAfterXmlExport event occurs after Microsoft Excel saves or exports data from any open workbook to an XML data file.

AppEvents_WorkbookAfterXmlImportEventHandler

A Delegate type used to add an event handler for the WorkbookAfterXmlImport event. The WorkbookAfterXmlImport event occurs after an existing XML data connection is refreshed, or new XML data is imported into any open Microsoft Excel workbook.

AppEvents_WorkbookBeforeCloseEventHandler

A Delegate type used to add an event handler for the WorkbookBeforeClose event. The WorkbookBeforeClose event occurs immediately before any open workbook closes.

AppEvents_WorkbookBeforePrintEventHandler

A Delegate type used to add an event handler for the WorkbookBeforePrint event. The WorkbookBeforePrint event occurs before any open workbook is printed.

AppEvents_WorkbookBeforeSaveEventHandler

A Delegate type used to add an event handler for the WorkbookBeforeSave event. The WorkbookBeforeSave event occurs before any open workbook is saved.

AppEvents_WorkbookBeforeXmlExportEventHandler

A Delegate type used to add an event handler for the WorkbookBeforeXmlExport event. The WorkbookBeforeXmlExport event occurs before Microsoft Excel saves or exports data from any open workbook to an XML data file.

AppEvents_WorkbookBeforeXmlImportEventHandler

A Delegate type used to add an event handler for the WorkbookBeforeXmlImport event. The WorkbookBeforeXmlImport event occurs before an existing XML data connection is refreshed, or new XML data is imported into any open Microsoft Excel workbook.

AppEvents_WorkbookDeactivateEventHandler

A Delegate type used to add an event handler for the WorkbookDeactivate event. The WorkbookDeactivate event occurs when any open workbook is deactivated.

AppEvents_WorkbookModelChangeEventHandler

A Delegate type used to add an event handler for the WorkbookModelChange event. The WorkbookModelChange event occurs when the data model is updated.

AppEvents_WorkbookNewChartEventHandler

A Delegate type used to add an event handler for the WorkbookNewChart event. The WorkbookNewChart event occurs when a new chart is created in any open workbook.

AppEvents_WorkbookNewSheetEventHandler

A Delegate type used to add an event handler for the WorkbookNewSheet event. The WorkbookNewSheet event occurs when a new sheet is created in any open workbook.

AppEvents_WorkbookOpenEventHandler

A Delegate type used to add an event handler for the WorkbookOpen event. The WorkbookOpen event occurs when a workbook is opened.

AppEvents_WorkbookPivotTableCloseConnectionEventHandler

A Delegate type used to add an event handler for the WorkbookPivotTableCloseConnection event. The WorkbookPivotTableCloseConnection event occurs after a PivotTable report connection has been closed.

AppEvents_WorkbookPivotTableOpenConnectionEventHandler

A Delegate type used to add an event handler for the WorkbookPivotTableOpenConnection event. The WorkbookPivotTableOpenConnection event occurs after a PivotTable report connection has been opened.

AppEvents_WorkbookRowsetCompleteEventHandler

A Delegate type used to add an event handler for the WorkbookRowsetComplete event. The WorkbookRowsetComplete event occurs when the user either drills through the recordset or invokes the rowset action on an OLAP PivotTable.

AppEvents_WorkbookSyncEventHandler

A Delegate type used to add an event handler for the WorkbookSync event. The WorkbookSync event occurs when the local copy of a workbook that is part of a Document Workspace is synchronized with the copy on the server.

ChartEvents_ActivateEventHandler

A Delegate type used to add an event handler for the Activate event. The Activate event occurs when a chart sheet or embedded chart is activated.

ChartEvents_BeforeDoubleClickEventHandler

A Delegate type used to add an event handler for the BeforeDoubleClick event. The BeforeDoubleClick event occurs when an embedded chart is double-clicked, before the default double-click action.

ChartEvents_BeforeRightClickEventHandler

A Delegate type used to add an event handler for the BeforeRightClick event. The BeforeRightClick event occurs when an embedded chart is right-clicked, before the default right-click action.

ChartEvents_CalculateEventHandler

A Delegate type used to add an event handler for the Calculate event. The Calculate event occurs after the chart plots new or changed data.

ChartEvents_DeactivateEventHandler

A Delegate type used to add an event handler for the Deactivate event. The Deactivate event occurs when the chart is deactivated.

ChartEvents_DragOverEventHandler

A Delegate type used to add an event handler for the DragOver event. The DragOver event occurs when a range of cells is dragged over a chart.

ChartEvents_DragPlotEventHandler

A Delegate type used to add an event handler for the DragPlot event. The DragPlot event occurs when a range of cells is dragged and dropped on a chart.

ChartEvents_MouseDownEventHandler

A Delegate type used to add an event handler for the MouseDown event. The MouseDown event occurs when a mouse button is pressed while the pointer is over a chart.

ChartEvents_MouseMoveEventHandler

A Delegate type used to add an event handler for the MouseMove event. The MouseMove event occurs when the position of the mouse pointer changes over a chart.

ChartEvents_MouseUpEventHandler

A Delegate type used to add an event handler for the MouseUp event. The MouseUp event occurs when a mouse button is released while the pointer is over a chart.

ChartEvents_ResizeEventHandler

A Delegate type used to add an event handler for the Resize event. The Resize event occurs when the chart is resized.

ChartEvents_SelectEventHandler

A Delegate type used to add an event handler for the Select event. The Select event occurs when a chart element is selected.

ChartEvents_SeriesChangeEventHandler

A Delegate type used to add an event handler for the SeriesChange event. The SeriesChange event occurs when the user changes the value of a chart data point.

DocEvents_ActivateEventHandler

A Delegate type used to add an event handler for the Activate event. The Activate event occurs when a worksheet is activated.

DocEvents_BeforeDeleteEventHandler

A Delegate type used to add an event handler for the Microsoft.Office.Interop.Excel.AppEvents_Event.BeforeDelete event. The BeforeDelete event occurs before any sheet is deleted.

DocEvents_BeforeDoubleClickEventHandler

A Delegate type used to add an event handler for the BeforeDoubleClick event. The BeforeDoubleClick event occurs when a worksheet is double-clicked, before the default double-click action.

DocEvents_BeforeRightClickEventHandler

A Delegate type used to add an event handler for the BeforeRightClick event. The BeforeRightClick event occurs when a worksheet is right-clicked, before the default right-click action.

DocEvents_CalculateEventHandler

A Delegate type used to add an event handler for the Calculate event. The Calculate event occurs after the worksheet is recalculated.

DocEvents_ChangeEventHandler

A Delegate type used to add an event handler for the Change event. The Change event occurs when cells on the worksheet are changed by the user or by an external link.

DocEvents_DeactivateEventHandler

A Delegate type used to add an event handler for the Deactivate event. The Deactivate event occurs when the worksheet is deactivated.

DocEvents_FollowHyperlinkEventHandler

A Delegate type used to add an event handler for the FollowHyperlink event. The FollowHyperlink event occurs when you click any hyperlink on a worksheet.

DocEvents_LensGalleryRenderCompleteEventHandler

Occurs when a callout gallery’s icons (dynamic and static) have completed rendering.

DocEvents_PivotTableAfterValueChangeEventHandler

A Delegate type used to add an event handler for the PivotTableAfterValueChange event. The PivotTableAfterValueChange event occurs after a cell or range of cells inside a PivotTable are edited or recalculated (for cells that contain formulas).

DocEvents_PivotTableBeforeAllocateChangesEventHandler

A Delegate type used to add an event handler for the PivotTableBeforeAllocateChanges event. The PivotTableBeforeAllocateChanges event occurs before changes are applied to a PivotTable.

DocEvents_PivotTableBeforeCommitChangesEventHandler

A Delegate type used to add an event handler for the PivotTableBeforeCommitChanges event. The PivotTableBeforeCommitChanges event occurs before changes are committed against the OLAP data source for a PivotTable.

DocEvents_PivotTableBeforeDiscardChangesEventHandler

A Delegate type used to add an event handler for the PivotTableBeforeDiscardChanges event. The PivotTableBeforeDiscardChanges event occurs before changes to a PivotTable are discarded.

DocEvents_PivotTableChangeSyncEventHandler

A Delegate type used to add an event handler for the PivotTableChangeSync event. The PivotTableChangeSync event occurs after changes to a PivotTable.

DocEvents_PivotTableUpdateEventHandler

A Delegate type used to add an event handler for the PivotTableUpdate event. The PivotTableUpdate event occurs after a PivotTable report is updated on a worksheet.

DocEvents_SelectionChangeEventHandler

A Delegate type used to add an event handler for the SelectionChange event. The SelectionChange event occurs when the selection changes on a worksheet.

DocEvents_TableUpdateEventHandler

A Delegate type used to add an event handler for the TableUpdate event. The TableUpdate event occurs after a Query table connected to the Data Model is updated on a worksheet.

OLEObjectEvents_GotFocusEventHandler

A Delegate type used to add an event handler for the GotFocus event. The GotFocus event occurs when an ActiveX control gets input focus.

OLEObjectEvents_LostFocusEventHandler

A Delegate type used to add an event handler for the LostFocus event. The LostFocus event occurs when an ActiveX control loses input focus.

RefreshEvents_AfterRefreshEventHandler

A Delegate type used to add an event handler for the AfterRefresh event. The AfterRefresh event occurs after a query is completed or canceled.

RefreshEvents_BeforeRefreshEventHandler

A Delegate type used to add an event handler for the BeforeRefresh event. The BeforeRefresh event occurs before any refreshes of the query table.

WorkbookEvents_ActivateEventHandler

A Delegate type used to add an event handler for the Activate event. The Activate event occurs when a workbook is activated.

WorkbookEvents_AddinInstallEventHandler

A Delegate type used to add an event handler for the AddinInstall event. The AddinInstall event occurs when the workbook is installed as an add-in.

WorkbookEvents_AddinUninstallEventHandler

A Delegate type used to add an event handler for the AddinUninstall event. The AddinUninstall event occurs when the workbook is uninstalled as an add-in.

WorkbookEvents_AfterSaveEventHandler

A Delegate type used to add an event handler for the AfterSave event. The AfterSave event occurs after the workbook is saved.

WorkbookEvents_AfterXmlExportEventHandler

A Delegate type used to add an event handler for the AfterXmlExport event. The AfterXmlExport event occurs after Microsoft Excel saves or exports data from the specified workbook to an XML data file.

WorkbookEvents_AfterXmlImportEventHandler

A Delegate type used to add an event handler for the AfterXmlImport event. The AfterXmlImport event occurs after an existing XML data connection is refreshed or after new XML data is imported into the specified Microsoft Excel workbook.

WorkbookEvents_BeforeCloseEventHandler

A Delegate type used to add an event handler for the BeforeClose event. The BeforeClose event occurs before the workbook closes. If the workbook has been changed, this event occurs before the user is asked to save changes.

WorkbookEvents_BeforePrintEventHandler

A Delegate type used to add an event handler for the BeforePrint event. The BeforePrint event occurs before the workbook (or anything in it) is printed.

WorkbookEvents_BeforeSaveEventHandler

A Delegate type used to add an event handler for the BeforeSave event. The BeforeSave event occurs before the workbook is saved.

WorkbookEvents_BeforeXmlExportEventHandler

A Delegate type used to add an event handler for the BeforeXmlExport event. The BeforeXmlExport event occurs before Microsoft Excel saves or exports data from the specified workbook to an XML data file.

WorkbookEvents_BeforeXmlImportEventHandler

A Delegate type used to add an event handler for the BeforeXmlImport event. The BeforeXmlImport event occurs before an existing XML data connection is refreshed or before new XML data is imported into a Microsoft Excel workbook.

WorkbookEvents_DeactivateEventHandler

A Delegate type used to add an event handler for the Deactivate event. The Deactivate event occurs when the workbook is deactivated.

WorkbookEvents_ModelChangeEventHandler

A Delegate type used to add an event handler for the ModelChange event. The ModelChange event occurs after the Excel data model is changed.

WorkbookEvents_NewChartEventHandler

A Delegate type used to add an event handler for the NewChart event. The NewChart event occurs when a new chart is created in the workbook.

WorkbookEvents_NewSheetEventHandler

A Delegate type used to add an event handler for the NewSheet event. The NewSheet event occurs when a new sheet is created in the workbook.

WorkbookEvents_OpenEventHandler

A Delegate type used to add an event handler for the Open event. The Open event occurs when the workbook is opened.

WorkbookEvents_PivotTableCloseConnectionEventHandler

A Delegate type used to add an event handler for the PivotTableCloseConnection event. The PivotTableCloseConnection event occurs after a PivotTable report closes the connection to its data source.

WorkbookEvents_PivotTableOpenConnectionEventHandler

A Delegate type used to add an event handler for the PivotTableOpenConnection event. The PivotTableOpenConnection event occurs after a PivotTable report opens the connection to its data source.

WorkbookEvents_RowsetCompleteEventHandler

A Delegate type used to add an event handler for the RowsetComplete event. The RowsetComplete event occurs when the user either drills through the recordset or invokes the rowset action on an OLAP PivotTable.

WorkbookEvents_SheetActivateEventHandler

A Delegate type used to add an event handler for the SheetActivate event. The SheetActivate event occurs when any sheet is activated.

WorkbookEvents_SheetBeforeDeleteEventHandler

A Delegate type used to add an event handler for the SheetBeforeDelete event. The SheetBeforeDelete event occurs before any worksheet is deleted.

WorkbookEvents_SheetBeforeDoubleClickEventHandler

A Delegate type used to add an event handler for the SheetBeforeDoubleClick event. The SheetBeforeDoubleClick event occurs when any worksheet is double-clicked, before the default double-click action.

WorkbookEvents_SheetBeforeRightClickEventHandler

A Delegate type used to add an event handler for the SheetBeforeRightClick event. The SheetBeforeRightClick event occurs when any worksheet is right-clicked, before the default right-click action.

WorkbookEvents_SheetCalculateEventHandler

A Delegate type used to add an event handler for the SheetCalculate event. The SheetCalculate event occurs after any worksheet is recalculated or after any changed data is plotted on a chart.

WorkbookEvents_SheetChangeEventHandler

A Delegate type used to add an event handler for the SheetChange event. The SheetChange event occurs when cells in any worksheet are changed by the user or by an external link.

WorkbookEvents_SheetDeactivateEventHandler

A Delegate type used to add an event handler for the SheetDeactivate event. The SheetDeactivate event occurs when any sheet is deactivated.

WorkbookEvents_SheetFollowHyperlinkEventHandler

A Delegate type used to add an event handler for the SheetFollowHyperlink event. The SheetFollowHyperlink event occurs when you click any hyperlink in Microsoft Excel.

WorkbookEvents_SheetLensGalleryRenderCompleteEventHandler

A Delegate type used to add an event handler for the SheetLensGalleryRenderComplete event. The SheetLensGalleryRenderComplete event occurs when a callout gallery’s icons (dynamic and static) have completed rendering for a worksheet.

WorkbookEvents_SheetPivotTableAfterValueChangeEventHandler

A Delegate type used to add an event handler for the SheetPivotTableAfterValueChange event. The SheetPivotTableAfterValueChange event occurs after a cell or range of cells inside a PivotTable are edited or recalculated (for cells that contain formulas).

WorkbookEvents_SheetPivotTableBeforeAllocateChangesEventHandler

A Delegate type used to add an event handler for the SheetPivotTableBeforeAllocateChanges event. The SheetPivotTableBeforeAllocateChanges event occurs before changes are applied to a PivotTable.

WorkbookEvents_SheetPivotTableBeforeCommitChangesEventHandler

A Delegate type used to add an event handler for the SheetPivotTableBeforeCommitChanges event. The SheetPivotTableBeforeCommitChanges event occurs before changes are committed against the OLAP data source for a PivotTable.

WorkbookEvents_SheetPivotTableBeforeDiscardChangesEventHandler

A Delegate type used to add an event handler for the SheetPivotTableBeforeDiscardChanges event. The SheetPivotTableBeforeDiscardChanges event occurs before changes to a PivotTable are discarded.

WorkbookEvents_SheetPivotTableChangeSyncEventHandler

A Delegate type used to add an event handler for the SheetPivotTableChangeSync event. The SheetPivotTableChangeSync event occurs after changes to a PivotTable.

WorkbookEvents_SheetPivotTableUpdateEventHandler

A Delegate type used to add an event handler for the SheetPivotTableUpdate event. The SheetPivotTableUpdate event occurs after the sheet of the PivotTable report has been updated.

WorkbookEvents_SheetSelectionChangeEventHandler

A Delegate type used to add an event handler for the SheetSelectionChange event. The SheetSelectionChange event occurs when the selection changes on any worksheet (doesn't occur if the selection is on a chart sheet).

WorkbookEvents_SheetTableUpdateEventHandler

A Delegate type used to add an event handler for the SheetTableUpdate event. The SheetTableUpdate event occurs after the sheet table has been updated.

WorkbookEvents_SyncEventHandler

A Delegate type used to add an event handler for the Sync event. The Sync event occurs when the local copy of a worksheet that is part of a Document Workspace is synchronized with the copy on the server.

WorkbookEvents_WindowActivateEventHandler

A Delegate type used to add an event handler for the WindowActivate event. The WindowActivate event occurs when any workbook window is activated.

WorkbookEvents_WindowDeactivateEventHandler

A Delegate type used to add an event handler for the WindowDeactivate event. The WindowDeactivate event occurs when any workbook window is deactivated.

WorkbookEvents_WindowResizeEventHandler

A Delegate type used to add an event handler for the WindowResize event. The WindowResize event occurs when any workbook window is resized.