Microsoft.Office.Interop.Excel Namespace
Important
Some information relates to prerelease product that may be substantially modified before it’s released. Microsoft makes no warranties, express or implied, with respect to the information provided here.
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 | |
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 |
Scenarios |
A collection of all the Scenario objects on the specified worksheet. A scenario is a group of input values (called |
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. |