Export (0) Print
Expand All
Expand Minimize

Microsoft.Office.Interop.Excel Namespace

The types and members of the Microsoft.Office.Interop.Excel namespace provide support for interoperability between the COM object model of Microsoft Excel 2010 and managed applications that automate Excel 2010.

  ClassDescription
Public classAppEvents_SinkHelperReserved for internal use.
Public classApplicationClassReserved for internal use.
Public classChartClassReserved for internal use.
Public classChartEvents_SinkHelperReserved for internal use.
Public classDocEvents_SinkHelperReserved for internal use.
Public classGlobalClassReserved for internal use.
Public classOLEObjectClassReserved for internal use.
Public classOLEObjectEvents_SinkHelperReserved for internal use.
Public classQueryTableClassReserved for internal use.
Public classRefreshEvents_SinkHelperReserved for internal use.
Public classWorkbookClassReserved for internal use.
Public classWorkbookEvents_SinkHelperReserved for internal use.
Public classWorksheetClassReserved for internal use.

  InterfaceDescription
Public interface_ApplicationRepresents the entire Microsoft Excel application.
Public interface_ChartRepresents a chart in a workbook. The chart can be either an embedded chart (contained in a ChartObject) or a separate chart sheet.
Public interface_GlobalReserved for internal use.
Public interface_IOLEObjectReserved for internal use.
Public interface_IQueryTableReserved for internal use.
Public interface_OLEObjectRepresents 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.
Public interface_QueryTableRepresents 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.
Public interface_WorkbookRepresents a Microsoft Excel workbook.
Public interface_WorksheetRepresents a worksheet.
Public interfaceAboveAverageRepresents 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.
Public interfaceActionRepresents an action to be executed in PivotTable or Worksheetdata.
Public interfaceActionsA collection of all Action objects for the specified series.
Public interfaceAddInRepresents a single add-in, either installed or not installed.
Public interfaceAddInsA 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).
Public interfaceAddIns2A 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.
Public interfaceAdjustmentsContains a collection of adjustment values for the specified AutoShape, WordArt object, or connector.
Public interfaceAllowEditRangeRepresents the cells that can be edited on a protected worksheet.
Public interfaceAllowEditRangesA collection of all the AllowEditRange objects that represent the cells that can be edited on a protected worksheet.
Public interfaceAppEventsReserved for internal use.
Public interfaceAppEvents_EventEvents interface for Microsoft Excel Application object events.
Public interfaceApplicationRepresents the entire Microsoft Excel application.
Public interfaceArcReserved for internal use.
Public interfaceArcsReserved for internal use.
Public interfaceAreasA collection of the areas, or contiguous blocks of cells, within a selection.
Public interfaceAutoCorrectContains Microsoft Excel AutoCorrect attributes (capitalization of names of days, correction of two initial capital letters, automatic correction list, and so on).
Public interfaceAutoFilterRepresents autofiltering for the specified worksheet.
Public interfaceAutoRecoverRepresents the automatic recovery features of a workbook.
Public interfaceAxesA collection of all the Axis objects in the specified chart.
Public interfaceAxisRepresents a single axis in a chart.
Public interfaceAxisTitleRepresents a chart axis title.
Public interfaceBorderRepresents the border of an object.
Public interfaceBordersA collection of four Border objects that represent the four borders of a Range or Style object.
Public interfaceButtonReserved for internal use.
Public interfaceButtonsReserved for internal use.
Public interfaceCalculatedFieldsA collection of PivotField objects that represents all the calculated fields in the specified PivotTable report.
Public interfaceCalculatedItemsA collection of PivotItem objects that represent all the calculated items in the specified PivotTable report.
Public interfaceCalculatedMemberRepresents the calculated fields and calculated items for PivotTables with Online Analytical Processing (OLAP) data sources.
Public interfaceCalculatedMembersA collection of all the CalculatedMember objects on the specified PivotTable.
Public interfaceCalloutFormatContains properties and methods that apply to line callouts.
Public interfaceCellFormatRepresents the search criteria for the cell format.
Public interfaceCharactersRepresents characters in an object that contains text. The Characters object lets you modify any sequence of characters contained in the full text string.
Public interfaceChartRepresents a chart in a workbook. The chart can be either an embedded chart (contained in a ChartObject) or a separate chart sheet.
Public interfaceChartAreaRepresents 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.
Public interfaceChartColorFormatUsed 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.
Public interfaceChartEventsReserved for internal use.
Public interfaceChartEvents_EventEvents interface for Microsoft Excel Chart object events.
Public interfaceChartFillFormatUsed only with charts. Represents fill formatting for chart elements.
Public interfaceChartFormatProvides access to the Office Art formatting for chart elements.
Public interfaceChartGroupRepresents one or more series plotted in a chart with the same format. The ChartGroup object is a member of the ChartGroups collection.
Public interfaceChartGroupsA collection of all the ChartGroup objects in the specified chart.
Public interfaceChartObjectRepresents an embedded chart on a worksheet.
Public interfaceChartObjectsA collection of all the ChartObject objects on the specified chart sheet, dialog sheet, or worksheet.
Public interfaceChartsA 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.
Public interfaceChartTitleRepresents the chart title.
Public interfaceChartViewRepresents a view of a chart.
Public interfaceCheckBoxReserved for internal use.
Public interfaceCheckBoxesReserved for internal use.
Public interfaceColorFormatRepresents 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.
Public interfaceColorScaleRepresents a color scale conditional formatting rule.
Public interfaceColorScaleCriteriaA 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.
Public interfaceColorScaleCriterionRepresents the criteria for the minimum, midpoint, or maximum thresholds for a color format conditional format.
Public interfaceColorStopRepresents the color stop point for a gradient fill in an range or selection.
Public interfaceColorStopsA collection of all the ColorStop objects for the specified series.
Public interfaceCommentRepresents a cell comment.
Public interfaceCommentsA collection of cell comments. Each comment is represented by a Comment object.
Public interfaceConditionValueRepresents how the shortest bar or longest bar is evaluated for a data bar conditional formatting rule.
Public interfaceConnectionsA collection of Connection objects for the specified workbook.
Public interfaceConnectorFormatContains properties and methods that apply to connectors.
Public interfaceControlFormatContains Microsoft Excel control properties.
Public interfaceCornersRepresents the corners of a 3-D chart.
Public interfaceCubeFieldRepresents a hierarchy or measure field from an OLAP cube.
Public interfaceCubeFieldsA collection of all CubeField objects in a PivotTable report that is based on an OLAP cube.
Public interfaceCustomPropertiesA collection of CustomProperty objects that represent additional information. The information can be used as metadata for XML.
Public interfaceCustomPropertyRepresents identifier information. Identifier information can be used as metadata for XML.
Public interfaceCustomViewRepresents a custom workbook view.
Public interfaceCustomViewsA collection of custom workbook views. Each view is represented by a CustomView object.
Public interfaceDatabarRepresents 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.
Public interfaceDataBarBorderRepresents the border of the data bars specified by a conditional formatting rule.
Public interfaceDataLabelRepresents the data label on a chart point or trendline.
Public interfaceDataLabelsA 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.
Public interfaceDataTableRepresents a chart data table.
Public interfaceDefaultWebOptionsContains global application-level attributes used by Microsoft Excel when you save a document as a Web page or open a Web page.
Public interfaceDiagramRepresents a diagram.
Public interfaceDiagramNodeRepresents a node in a diagram.
Public interfaceDiagramNodeChildrenA collection of DiagramNode objects that represents child nodes in a diagram.
Public interfaceDiagramNodesA collection of DiagramNode objects that represents all the nodes in a diagram.
Public interfaceDialogRepresents a built-in Microsoft Excel dialog box.
Public interfaceDialogFrameReserved for internal use.
Public interfaceDialogsA collection of all the Dialog objects in Microsoft Excel.
Public interfaceDialogSheetReserved for internal use.
Public interfaceDialogSheetsReserved for internal use.
Public interfaceDialogSheetViewRepresents the current Dialogsheet view in a workbook.
Public interfaceDisplayFormatRepresents the display settings for an associated Range object.
Public interfaceDisplayUnitLabelRepresents a unit label on an axis in the specified chart.
Public interfaceDocEventsReserved for internal use.
Public interfaceDocEvents_EventEvents interface for Microsoft Excel Worksheet object events.
Public interfaceDownBarsRepresents the down bars in a chart group.
Public interfaceDrawingReserved for internal use.
Public interfaceDrawingObjectsReserved for internal use.
Public interfaceDrawingsReserved for internal use.
Public interfaceDropDownReserved for internal use.
Public interfaceDropDownsReserved for internal use.
Public interfaceDropLinesRepresents the drop lines in a chart group.
Public interfaceEditBoxReserved for internal use.
Public interfaceEditBoxesReserved for internal use.
Public interfaceErrorRepresents a spreadsheet error for a range.
Public interfaceErrorBarsRepresents the error bars on a chart series.
Public interfaceErrorCheckingOptionsRepresents the error-checking options for an application.
Public interfaceErrorsRepresents the various spreadsheet errors for a range.
Public interfaceFileExportConverterRepresents a file converter that is used to save files.
Public interfaceFileExportConvertersA collection of FileExportConverter objects that represent all the file converters available for saving files.
Public interfaceFillFormatRepresents fill formatting for a shape.
Public interfaceFilterRepresents 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.
Public interfaceFiltersA collection of Filter objects that represents all the filters in an autofiltered range.
Public interfaceFloorRepresents the floor of a 3-D chart.
Public interfaceFontContains the font attributes (font name, font size, color, and so on) for an object.
Public interfaceFormatColorRepresents 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.
Public interfaceFormatConditionRepresents a conditional format.
Public interfaceFormatConditionsRepresents the collection of conditional formats for a single range.
Public interfaceFreeformBuilderRepresents the geometry of a freeform while it’s being built.
Public interfaceGlobalReserved for internal use.
Public interfaceGraphicContains properties that apply to header and footer picture objects.
Public interfaceGridlinesRepresents major or minor gridlines on a chart axis.
Public interfaceGroupBoxReserved for internal use.
Public interfaceGroupBoxesReserved for internal use.
Public interfaceGroupObjectReserved for internal use.
Public interfaceGroupObjectsReserved for internal use.
Public interfaceGroupShapesRepresents the individual shapes within a grouped shape.
Public interfaceHeaderFooterRepresents a single header or footer.
Public interfaceHiLoLinesRepresents the high-low lines in a chart group.
Public interfaceHPageBreakRepresents a horizontal page break.
Public interfaceHPageBreaksThe collection of horizontal page breaks within the print area. Each horizontal page break is represented by an HPageBreak object.
Public interfaceHyperlinkRepresents a hyperlink.
Public interfaceHyperlinksRepresents the collection of hyperlinks for a worksheet or range. Each hyperlink is represented by a Hyperlink object.
Public interfaceIAboveAverageReserved for internal use.
Public interfaceIActionReserved for internal use.
Public interfaceIActionsReserved for internal use.
Public interfaceIAddInReserved for internal use.
Public interfaceIAddInsReserved for internal use.
Public interfaceIAddIns2Reserved for internal use.
Public interfaceIAllowEditRangeReserved for internal use.
Public interfaceIAllowEditRangesReserved for internal use.
Public interfaceIAppEventsReserved for internal use.
Public interfaceIArcReserved for internal use.
Public interfaceIArcsReserved for internal use.
Public interfaceIAreasReserved for internal use.
Public interfaceIAutoCorrectReserved for internal use.
Public interfaceIAutoFilterReserved for internal use.
Public interfaceIAutoRecoverReserved for internal use.
Public interfaceIAxesReserved for internal use.
Public interfaceIAxisReserved for internal use.
Public interfaceIAxisTitleReserved for internal use.
Public interfaceIBorderReserved for internal use.
Public interfaceIBordersReserved for internal use.
Public interfaceIButtonReserved for internal use.
Public interfaceIButtonsReserved for internal use.
Public interfaceICalculatedFieldsReserved for internal use.
Public interfaceICalculatedItemsReserved for internal use.
Public interfaceICalculatedMemberReserved for internal use.
Public interfaceICalculatedMembersReserved for internal use.
Public interfaceICanvasShapesReserved for internal use.
Public interfaceICellFormatReserved for internal use.
Public interfaceICharactersReserved for internal use.
Public interfaceIChartAreaReserved for internal use.
Public interfaceIChartColorFormatReserved for internal use.
Public interfaceIChartEventsReserved for internal use.
Public interfaceIChartFillFormatReserved for internal use.
Public interfaceIChartFormatReserved for internal use.
Public interfaceIChartGroupReserved for internal use.
Public interfaceIChartGroupsReserved for internal use.
Public interfaceIChartObjectReserved for internal use.
Public interfaceIChartObjectsReserved for internal use.
Public interfaceIChartsReserved for internal use.
Public interfaceIChartTitleReserved for internal use.
Public interfaceIChartViewReserved for internal use.
Public interfaceICheckBoxReserved for internal use.
Public interfaceICheckBoxesReserved for internal use.
Public interfaceIColorScaleReserved for internal use.
Public interfaceIColorScaleCriteriaReserved for internal use.
Public interfaceIColorScaleCriterionReserved for internal use.
Public interfaceIColorStopReserved for internal use.
Public interfaceIColorStopsReserved for internal use.
Public interfaceICommentReserved for internal use.
Public interfaceICommentsReserved for internal use.
Public interfaceIconRepresents a single icon in an icon set used in a conditional formatting rule.
Public interfaceIconCriteriaRepresents the collection of IconCriterion objects. Each IconCriterion represents the values and threshold type for each icon in an icon set conditional formatting rule.
Public interfaceIconCriterionRepresents 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.
Public interfaceIConditionValueReserved for internal use.
Public interfaceIConnectionsReserved for internal use.
Public interfaceIConnectorFormatReserved for internal use.
Public interfaceIconSetRepresents a single set of icons that are used in an icon set conditional formatting rule.
Public interfaceIconSetConditionRepresents an icon set conditional formatting rule.
Public interfaceIconSetsRepresents a collection of icon sets used in an icon set conditional formatting rule.
Public interfaceIControlFormatReserved for internal use.
Public interfaceICornersReserved for internal use.
Public interfaceICustomPropertiesReserved for internal use.
Public interfaceICustomPropertyReserved for internal use.
Public interfaceICustomViewReserved for internal use.
Public interfaceICustomViewsReserved for internal use.
Public interfaceIDatabarReserved for internal use.
Public interfaceIDataBarBorder
Public interfaceIDataLabelReserved for internal use.
Public interfaceIDataLabelsReserved for internal use.
Public interfaceIDataTableReserved for internal use.
Public interfaceIDiagramReserved for internal use.
Public interfaceIDialogReserved for internal use.
Public interfaceIDialogFrameReserved for internal use.
Public interfaceIDialogsReserved for internal use.
Public interfaceIDialogSheetReserved for internal use.
Public interfaceIDialogSheetsReserved for internal use.
Public interfaceIDialogSheetViewReserved for internal use.
Public interfaceIDisplayFormat
Public interfaceIDisplayUnitLabelReserved for internal use.
Public interfaceIDocEventsReserved for internal use.
Public interfaceIDownBarsReserved for internal use.
Public interfaceIDrawingReserved for internal use.
Public interfaceIDrawingObjectsReserved for internal use.
Public interfaceIDrawingsReserved for internal use.
Public interfaceIDropDownReserved for internal use.
Public interfaceIDropDownsReserved for internal use.
Public interfaceIDropLinesReserved for internal use.
Public interfaceIDummyReserved for internal use.
Public interfaceIEditBoxReserved for internal use.
Public interfaceIEditBoxesReserved for internal use.
Public interfaceIErrorReserved for internal use.
Public interfaceIErrorBarsReserved for internal use.
Public interfaceIErrorCheckingOptionsReserved for internal use.
Public interfaceIErrorsReserved for internal use.
Public interfaceIFileExportConverterReserved for internal use.
Public interfaceIFileExportConvertersReserved for internal use.
Public interfaceIFilterReserved for internal use.
Public interfaceIFiltersReserved for internal use.
Public interfaceIFloorReserved for internal use.
Public interfaceIFontReserved for internal use.
Public interfaceIFormatColorReserved for internal use.
Public interfaceIFormatConditionReserved for internal use.
Public interfaceIFormatConditionsReserved for internal use.
Public interfaceIFreeformBuilderReserved for internal use.
Public interfaceIGraphicReserved for internal use.
Public interfaceIGridlinesReserved for internal use.
Public interfaceIGroupBoxReserved for internal use.
Public interfaceIGroupBoxesReserved for internal use.
Public interfaceIGroupObjectReserved for internal use.
Public interfaceIGroupObjectsReserved for internal use.
Public interfaceIGroupShapesReserved for internal use.
Public interfaceIHeaderFooterReserved for internal use.
Public interfaceIHiLoLinesReserved for internal use.
Public interfaceIHPageBreakReserved for internal use.
Public interfaceIHPageBreaksReserved for internal use.
Public interfaceIHyperlinkReserved for internal use.
Public interfaceIHyperlinksReserved for internal use.
Public interfaceIIconReserved for internal use.
Public interfaceIIconCriteriaReserved for internal use.
Public interfaceIIconCriterionReserved for internal use.
Public interfaceIIconSetReserved for internal use.
Public interfaceIIconSetConditionReserved for internal use.
Public interfaceIIconSetsReserved for internal use.
Public interfaceIInteriorReserved for internal use.
Public interfaceILabelReserved for internal use.
Public interfaceILabelsReserved for internal use.
Public interfaceILeaderLinesReserved for internal use.
Public interfaceILegendReserved for internal use.
Public interfaceILegendEntriesReserved for internal use.
Public interfaceILegendEntryReserved for internal use.
Public interfaceILegendKeyReserved for internal use.
Public interfaceILineReserved for internal use.
Public interfaceILinearGradientReserved for internal use.
Public interfaceILinesReserved for internal use.
Public interfaceILinkFormatReserved for internal use.
Public interfaceIListBoxReserved for internal use.
Public interfaceIListBoxesReserved for internal use.
Public interfaceIListColumnReserved for internal use.
Public interfaceIListColumnsReserved for internal use.
Public interfaceIListDataFormatReserved for internal use.
Public interfaceIListObjectReserved for internal use.
Public interfaceIListObjectsReserved for internal use.
Public interfaceIListRowReserved for internal use.
Public interfaceIListRowsReserved for internal use.
Public interfaceIMailerReserved for internal use.
Public interfaceIMenuReserved for internal use.
Public interfaceIMenuBarReserved for internal use.
Public interfaceIMenuBarsReserved for internal use.
Public interfaceIMenuItemReserved for internal use.
Public interfaceIMenuItemsReserved for internal use.
Public interfaceIMenusReserved for internal use.
Public interfaceIModuleReserved for internal use.
Public interfaceIModulesReserved for internal use.
Public interfaceIModuleViewReserved for internal use.
Public interfaceIMultiThreadedCalculationReserved for internal use.
Public interfaceINameReserved for internal use.
Public interfaceINamesReserved for internal use.
Public interfaceINegativeBarFormatReserved for internal use.
Public interfaceInteriorRepresents the interior of an object.
Public interfaceIODBCConnectionReserved for internal use.
Public interfaceIODBCErrorReserved for internal use.
Public interfaceIODBCErrorsReserved for internal use.
Public interfaceIOLEDBConnectionReserved for internal use.
Public interfaceIOLEDBErrorReserved for internal use.
Public interfaceIOLEDBErrorsReserved for internal use.
Public interfaceIOLEFormatReserved for internal use.
Public interfaceIOLEObjectEventsReserved for internal use.
Public interfaceIOLEObjectsReserved for internal use.
Public interfaceIOptionButtonReserved for internal use.
Public interfaceIOptionButtonsReserved for internal use.
Public interfaceIOutlineReserved for internal use.
Public interfaceIOvalReserved for internal use.
Public interfaceIOvalsReserved for internal use.
Public interfaceIPageReserved for internal use.
Public interfaceIPagesReserved for internal use.
Public interfaceIPageSetupReserved for internal use.
Public interfaceIPaneReserved for internal use.
Public interfaceIPanesReserved for internal use.
Public interfaceIParameterReserved for internal use.
Public interfaceIParametersReserved for internal use.
Public interfaceIPhoneticReserved for internal use.
Public interfaceIPhoneticsReserved for internal use.
Public interfaceIPictureReserved for internal use.
Public interfaceIPicturesReserved for internal use.
Public interfaceIPivotAxisReserved for internal use.
Public interfaceIPivotCacheReserved for internal use.
Public interfaceIPivotCachesReserved for internal use.
Public interfaceIPivotCellReserved for internal use.
Public interfaceIPivotFieldReserved for internal use.
Public interfaceIPivotFieldsReserved for internal use.
Public interfaceIPivotFilterReserved for internal use.
Public interfaceIPivotFiltersReserved for internal use.
Public interfaceIPivotFormulaReserved for internal use.
Public interfaceIPivotFormulasReserved for internal use.
Public interfaceIPivotItemReserved for internal use.
Public interfaceIPivotItemListReserved for internal use.
Public interfaceIPivotItemsReserved for internal use.
Public interfaceIPivotLayoutReserved for internal use.
Public interfaceIPivotLineReserved for internal use.
Public interfaceIPivotLineCellsReserved for internal use.
Public interfaceIPivotLinesReserved for internal use.
Public interfaceIPivotTableReserved for internal use.
Public interfaceIPivotTableChangeList
Public interfaceIPivotTablesReserved for internal use.
Public interfaceIPlotAreaReserved for internal use.
Public interfaceIPointReserved for internal use.
Public interfaceIPointsReserved for internal use.
Public interfaceIProtectedViewWindowReserved for internal use.
Public interfaceIProtectedViewWindowsReserved for internal use.
Public interfaceIProtectionReserved for internal use.
Public interfaceIPublishObjectsReserved for internal use.
Public interfaceIQueryTablesReserved for internal use.
Public interfaceIRangeReserved for internal use.
Public interfaceIRangesReserved for internal use.
Public interfaceIRecentFileReserved for internal use.
Public interfaceIRecentFilesReserved for internal use.
Public interfaceIRectangleReserved for internal use.
Public interfaceIRectanglesReserved for internal use.
Public interfaceIRectangularGradientReserved for internal use.
Public interfaceIRefreshEventsReserved for internal use.
Public interfaceIResearchReserved for internal use.
Public interfaceIRoutingSlipReserved for internal use.
Public interfaceIRTDReserved for internal use.
Public interfaceIRtdServerRepresents an interface for a real-time data server.
Public interfaceIRTDUpdateEventRepresents real-time data update events.
Public interfaceIScenarioReserved for internal use.
Public interfaceIScenariosReserved for internal use.
Public interfaceIScrollBarReserved for internal use.
Public interfaceIScrollBarsReserved for internal use.
Public interfaceISeriesReserved for internal use.
Public interfaceISeriesCollectionReserved for internal use.
Public interfaceISeriesLinesReserved for internal use.
Public interfaceIServerViewableItemsReserved for internal use.
Public interfaceIShapeReserved for internal use.
Public interfaceIShapeRangeReserved for internal use.
Public interfaceIShapesReserved for internal use.
Public interfaceISheetViewsReserved for internal use.
Public interfaceISlicerReserved for internal use.
Public interfaceISlicerCacheReserved for internal use.
Public interfaceISlicerCacheLevelReserved for internal use.
Public interfaceISlicerCacheLevelsReserved for internal use.
Public interfaceISlicerCachesReserved for internal use.
Public interfaceISlicerItemReserved for internal use.
Public interfaceISlicerItemsReserved for internal use.
Public interfaceISlicerPivotTablesReserved for internal use.
Public interfaceISlicersReserved for internal use.
Public interfaceISmartTagReserved for internal use.
Public interfaceISmartTagActionReserved for internal use.
Public interfaceISmartTagActionsReserved for internal use.
Public interfaceISmartTagOptionsReserved for internal use.
Public interfaceISmartTagRecognizerReserved for internal use.
Public interfaceISmartTagRecognizersReserved for internal use.
Public interfaceISmartTagsReserved for internal use.
Public interfaceISortReserved for internal use.
Public interfaceISortFieldReserved for internal use.
Public interfaceISortFieldsReserved for internal use.
Public interfaceISoundNoteReserved for internal use.
Public interfaceISparkAxesReserved for internal use.
Public interfaceISparkColorReserved for internal use.
Public interfaceISparkHorizontalAxisReserved for internal use.
Public interfaceISparklineReserved for internal use.
Public interfaceISparklineGroupReserved for internal use.
Public interfaceISparklineGroupsReserved for internal use.
Public interfaceISparkPointsReserved for internal use.
Public interfaceISparkVerticalAxisReserved for internal use.
Public interfaceISpeechReserved for internal use.
Public interfaceISpellingOptionsReserved for internal use.
Public interfaceISpinnerReserved for internal use.
Public interfaceISpinnersReserved for internal use.
Public interfaceIStyleReserved for internal use.
Public interfaceIStylesReserved for internal use.
Public interfaceITabReserved for internal use.
Public interfaceITableStyleReserved for internal use.
Public interfaceITableStyleElementReserved for internal use.
Public interfaceITableStyleElementsReserved for internal use.
Public interfaceITableStylesReserved for internal use.
Public interfaceITextBoxReserved for internal use.
Public interfaceITextBoxesReserved for internal use.
Public interfaceITextFrameReserved for internal use.
Public interfaceITickLabelsReserved for internal use.
Public interfaceIToolbarReserved for internal use.
Public interfaceIToolbarButtonReserved for internal use.
Public interfaceIToolbarButtonsReserved for internal use.
Public interfaceIToolbarsReserved for internal use.
Public interfaceITop10Reserved for internal use.
Public interfaceITrendlineReserved for internal use.
Public interfaceITrendlinesReserved for internal use.
Public interfaceIUniqueValuesReserved for internal use.
Public interfaceIUpBarsReserved for internal use.
Public interfaceIUsedObjectsReserved for internal use.
Public interfaceIUserAccessReserved for internal use.
Public interfaceIUserAccessListReserved for internal use.
Public interfaceIValidationReserved for internal use.
Public interfaceIValueChangeReserved for internal use.
Public interfaceIVPageBreakReserved for internal use.
Public interfaceIVPageBreaksReserved for internal use.
Public interfaceIWallsReserved for internal use.
Public interfaceIWatchReserved for internal use.
Public interfaceIWatchesReserved for internal use.
Public interfaceIWindowReserved for internal use.
Public interfaceIWindowsReserved for internal use.
Public interfaceIWorkbookConnectionReserved for internal use.
Public interfaceIWorkbookEventsReserved for internal use.
Public interfaceIWorksheetFunctionReserved for internal use.
Public interfaceIWorksheetsReserved for internal use.
Public interfaceIWorksheetViewReserved for internal use.
Public interfaceIXmlDataBindingReserved for internal use.
Public interfaceIXmlMapReserved for internal use.
Public interfaceIXmlMapsReserved for internal use.
Public interfaceIXmlNamespaceReserved for internal use.
Public interfaceIXmlNamespacesReserved for internal use.
Public interfaceIXmlSchemaReserved for internal use.
Public interfaceIXmlSchemasReserved for internal use.
Public interfaceIXPathReserved for internal use.
Public interfaceLabelReserved for internal use.
Public interfaceLabelsReserved for internal use.
Public interfaceLeaderLinesRepresents leader lines on a chart.
Public interfaceLegendRepresents the legend in a chart.
Public interfaceLegendEntriesA collection of all the LegendEntry objects in the specified chart legend.
Public interfaceLegendEntryRepresents a legend entry in a chart legend.
Public interfaceLegendKeyRepresents a legend key in a chart legend.
Public interfaceLineReserved for internal use.
Public interfaceLinearGradientThe LinearGradient object transitions through a series of colors in a linear manner along a specific angle.
Public interfaceLineFormatRepresents line and arrowhead formatting.
Public interfaceLinesReserved for internal use.
Public interfaceLinkFormatContains linked OLE object properties.
Public interfaceListBoxReserved for internal use.
Public interfaceListBoxesReserved for internal use.
Public interfaceListColumnRepresents 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).
Public interfaceListColumnsA collection of all the ListColumn objects in the specified ListObject object. Each ListColumn object represents a column in the list.
Public interfaceListDataFormatThe ListDataFormat object holds all the data type properties of the ListColumn object. These properties are read-only.
Public interfaceListObjectRepresents a list object on a worksheet.
Public interfaceListObjectsA collection of all the ListObject objects on a worksheet. Each ListObject object represents a list in the worksheet.
Public interfaceListRowRepresents 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.
Public interfaceListRowsA collection of all the ListRow objects in the specified ListObject object. Each ListRow object represents a row in the list.
Public interfaceMailerYou 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.
Public interfaceMenuReserved for internal use.
Public interfaceMenuBarReserved for internal use.
Public interfaceMenuBarsReserved for internal use.
Public interfaceMenuItemReserved for internal use.
Public interfaceMenuItemsReserved for internal use.
Public interfaceMenusReserved for internal use.
Public interfaceModuleReserved for internal use.
Public interfaceModulesReserved for internal use.
Public interfaceModuleViewRepresents existing Moduleviews in the workbook.
Public interfaceMultiThreadedCalculationReturns or sets the concurrent calculation mode.
Public interfaceNameRepresents a defined name for a range of cells.
Public interfaceNamesA 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.
Public interfaceNegativeBarFormatRepresents the color settings of the data bars for negative values that are defined by a data bar conditional formating rule.
Public interfaceODBCConnectionRepresents the ODBC connection.
Public interfaceODBCErrorRepresents an ODBC error generated by the most recent ODBC query.
Public interfaceODBCErrorsA collection of ODBCError objects.
Public interfaceOLEDBConnectionRepresents the OLE DB connection.
Public interfaceOLEDBErrorRepresents an OLE DB error returned by the most recent OLE DB query.
Public interfaceOLEDBErrorsA collection of OLEDBError objects.
Public interfaceOLEFormatContains OLE object properties.
Public interfaceOLEObjectRepresents 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.
Public interfaceOLEObjectEventsReserved for internal use.
Public interfaceOLEObjectEvents_EventEvents interface for Microsoft Excel OLEObject object events.
Public interfaceOLEObjectsA collection of all the OLEObject objects on the specified worksheet. Each OLEObject object represents an ActiveX control or a linked or embedded OLE object.
Public interfaceOptionButtonReserved for internal use.
Public interfaceOptionButtonsReserved for internal use.
Public interfaceOutlineRepresents an outline on a worksheet.
Public interfaceOvalReserved for internal use.
Public interfaceOvalsReserved for internal use.
Public interfacePageRepresents a page in a workbook. Use the PageSetup object and the related methods and properties for programmatically defining page layout in a workbook.
Public interfacePagesA collection of pages in a document. Use the Pages collection and the related objects and properties for programmatically defining page layout in a workbook.
Public interfacePageSetupRepresents the page setup description. The PageSetup object contains all page setup attributes (left margin, bottom margin, paper size, and so on) as properties.
Public interfacePaneRepresents a pane of a window.
Public interfacePanesA collection of all the Pane objects shown in the specified window.
Public interfaceParameterRepresents a single parameter used in a parameter query. The Parameter object is a member of the Parameters collection.
Public interfaceParametersA 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.
Public interfacePhoneticContains information about a specific phonetic text string in a cell.
Public interfacePhoneticsA collection of all the Phonetic objects in the specified range. Each Phonetic object contains information about a specific phonetic text string.
Public interfacePictureReserved for internal use.
Public interfacePictureFormatContains properties and methods that apply to pictures and OLE objects.
Public interfacePicturesReserved for internal use.
Public interfacePivotAxis
Public interfacePivotCacheRepresents the memory cache for a PivotTable report.
Public interfacePivotCachesRepresents the collection of memory caches from the PivotTable reports in a workbook.
Public interfacePivotCellRepresents a cell in a PivotTable report.
Public interfacePivotFieldRepresents 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.
Public interfacePivotFieldsA collection of all the PivotField objects in a PivotTable report.
Public interfacePivotFilterA PivotFilter is applied to a PivotField object.
Public interfacePivotFiltersThe PivotFilters object is a collection of PivotFilter objects.
Public interfacePivotFormulaRepresents a formula used to calculate results in a PivotTable report.
Public interfacePivotFormulasRepresents the collection of formulas for a PivotTable report. Each formula is represented by a PivotFormula object.
Public interfacePivotItemRepresents 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.
Public interfacePivotItemListA collection of all the PivotItem objects in the specified PivotTable. Each PivotItem represents an item in a PivotTable field.
Public interfacePivotItemsA collection of all the PivotItem objects in a PivotTable field. The items are the individual data entries in a field category.
Public interfacePivotLayoutRepresents the placement of fields in a PivotChart report.
Public interfacePivotLineA PivotLine object is a line of rows or columns in an Excel PivotTable.
Public interfacePivotLineCellsCollection of PivotCell objects for a specific PivotLine.
Public interfacePivotLinesThe 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.
Public interfacePivotTableRepresents 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.
Public interfacePivotTableChangeListRepresents the list of changes a user has made to value cells in a PivotTable report based on an OLAP data source.
Public interfacePivotTablesA collection of all the PivotTable objects on the specified worksheet.
Public interfacePlotAreaRepresents the plot area of a chart. This is the area where your chart data is plotted.
Public interfacePointRepresents a single point in a series in a chart.
Public interfacePointsA collection of all the Point objects in the specified series in a chart.
Public interfaceProtectedViewWindowRepresents a Protected View window.
Public interfaceProtectedViewWindowsA collection of the ProtectedViewWindow objects that represent all the Protected View windows that are currently open in the application.
Public interfaceProtectionRepresents the various types of protection options available for a worksheet.
Public interfacePublishObjectRepresents 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.
Public interfacePublishObjectsA 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.
Public interfaceQueryTableRepresents 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.
Public interfaceQueryTablesA collection of QueryTable objects. Each QueryTable object represents a worksheet table built from data returned from an external data source.
Public interfaceRangeRepresents a cell, a row, a column, a selection of cells containing one or more contiguous blocks of cells, or a 3-D range.
Public interfaceRangesA collection of Range objects.
Public interfaceRecentFileRepresents a file in the list of recently used files.
Public interfaceRecentFilesRepresents the list of recently used files. Each file is represented by a RecentFile object.
Public interfaceRectangleReserved for internal use.
Public interfaceRectanglesReserved for internal use.
Public interfaceRectangularGradientThe RectangularGradient object transitions through a series of colors in a linear manner along a specific angle.
Public interfaceRefreshEventsReserved for internal use.
Public interfaceRefreshEvents_EventEvents interface for Microsoft Excel QueryTable object events.
Public interfaceResearchRepresents the controls of a Research query.
Public interfaceRoutingSlipRepresents the routing slip for a workbook. The routing slip is used to send a workbook through the electronic mail system.
Public interfaceRTDRepresents a real-time data object.
Public interfaceScenarioRepresents a scenario on a worksheet. A scenario is a group of input values (called changing cells) that’s named and saved.
Public interfaceScenariosA collection of all the Scenario objects on the specified worksheet. A scenario is a group of input values (called changing cells) that’s named and saved.
Public interfaceScrollBarReserved for internal use.
Public interfaceScrollBarsReserved for internal use.
Public interfaceSeriesRepresents a series in a chart. The Series object is a member of the SeriesCollection collection.
Public interfaceSeriesCollectionA collection of all the Series objects in the specified chart or chart group.
Public interfaceSeriesLinesRepresents series lines in a chart group. Series lines connect the data values from each series.
Public interfaceServerViewableItemsA collection of objects that have been marked as viewable on the server.
Public interfaceShadowFormatRepresents shadow formatting for a Shape.
Public interfaceShapeRepresents 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.
Public interfaceShapeNodeRepresents the geometry and the geometry-editing properties of the nodes in a user-defined freeform.
Public interfaceShapeNodesA collection of all the ShapeNode objects in the specified freeform.
Public interfaceShapeRangeRepresents a shape range, which is a set of shapes on a document.
Public interfaceShapesA collection of all the Shape objects on the specified sheet.
Public interfaceSheetsA collection of all the sheets in the specified or active workbook.
Public interfaceSheetViewsA collection of all the sheet views in the specified or active workbook window.
Public interfaceSlicerRepresents a slicer in a workbook.
Public interfaceSlicerCacheRepresents the current filter state for a slicer and information about which PivotCache or WorkbookConnection the slicer is connected to.
Public interfaceSlicerCacheLevelRepresents a level of a hierarchy in an OLAP data source being filtered by a slicer.
Public interfaceSlicerCacheLevelsRepresents the collection of hierarchy levels for the OLAP data source that is filtered by a slicer.
Public interfaceSlicerCachesRepresents the collection of slicer caches associated with the specified workbook.
Public interfaceSlicerItemRepresents an item in a slicer.
Public interfaceSlicerItemsRepresents the collection of SlicerItem objects contained in a SlicerCache or SlicerCacheLevel object.
Public interfaceSlicerPivotTablesRepresents information about the collection of PivotTables associated with the specified SlicerCache object.
Public interfaceSlicersA collection of Slicer objects.
Public interfaceSmartTagRepresents an identifier that is assigned to a cell.
Public interfaceSmartTagActionRepresents the actions that can be performed with smart tags.
Public interfaceSmartTagActionsA collection of SmartTagAction objects that represent the actions that can be performed with smart tags.
Public interfaceSmartTagOptionsRepresents the options that can be performed with smart tags.
Public interfaceSmartTagRecognizerRepresents recognition engines which label data with types of information as you work in Microsoft Excel.
Public interfaceSmartTagRecognizersA collection of SmartTagRecognizer objects that represent recognition engines that label data with types of information as you work in Microsoft Excel.
Public interfaceSmartTagsA collection of SmartTag objects that represent the identifiers assigned to each cell.
Public interfaceSortRepresents a sort of a range of data.
Public interfaceSortFieldThe SortField object contains all the sort information for the Worksheet, ListObject, and AutoFilter objects.
Public interfaceSortFieldsThe SortFields collection is a collection of SortField objects. It allows developers to store a sort state on workbooks, lists, and autofilters.
Public interfaceSoundNoteThis object should not be used. Sound notes have been removed from Microsoft Excel.
Public interfaceSparkAxesRepresents the settings for the horizontal and vertical axes of a group of sparklines.
Public interfaceSparkColorRepresents the color of the markers for points in a sparkline.
Public interfaceSparkHorizontalAxisRepresents the settings for the horizontal axes of a group of sparklines.
Public interfaceSparklineRepresents a single sparkline.
Public interfaceSparklineGroupRepresents a group of sparklines.
Public interfaceSparklineGroupsRepresents a collection of sparkline groups.
Public interfaceSparkPointsRepresents the settings of the markers for points of data on a sparkline.
Public interfaceSparkVerticalAxisRepresents the settings for the vertical axes of a group of sparklines.
Public interfaceSpeechContains methods and properties that pertain to speech.
Public interfaceSpellingOptionsRepresents the various spell-checking options for a worksheet.
Public interfaceSpinnerReserved for internal use.
Public interfaceSpinnersReserved for internal use.
Public interfaceStyleRepresents a style description for a range.
Public interfaceStylesA collection of all the Style objects in the specified or active workbook.
Public interfaceTabRepresents a tab in a chart or a worksheet.
Public interfaceTableStyleRepresents a single style that can be applied to a table.
Public interfaceTableStyleElementRepresents a single table style element.
Public interfaceTableStyleElementsRepresents table style elements.
Public interfaceTableStylesRepresents styles that can be applied to a table.
Public interfaceTextBoxReserved for internal use.
Public interfaceTextBoxesReserved for internal use.
Public interfaceTextEffectFormatContains properties and methods that apply to WordArt objects.
Public interfaceTextFrameRepresents 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.
Public interfaceTextFrame2Represents the text frame in a Shape, ShapeRange, or ChartFormat object.
Public interfaceThreeDFormatRepresents a shape's three-dimensional formatting.
Public interfaceTickLabelsRepresents the tick mark labels associated with tick marks on a chart axis.
Public interfaceToolbarReserved for internal use.
Public interfaceToolbarButtonReserved for internal use.
Public interfaceToolbarButtonsReserved for internal use.
Public interfaceToolbarsReserved for internal use.
Public interfaceTop10Represents 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.
Public interfaceTreeviewControlRepresents 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.
Public interfaceTrendlineRepresents a trendline in a chart. A trendline shows the trend, or direction, of data in a series.
Public interfaceTrendlinesA 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.
Public interfaceUniqueValuesThe 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.
Public interfaceUpBarsRepresents 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).
Public interfaceUsedObjectsRepresents objects that have been allocated in a workbook.
Public interfaceUserAccessRepresents the user access for a protected range.
Public interfaceUserAccessListA collection of UserAccess objects that represent the user access for protected ranges.
Public interfaceValidationRepresents data validation for a worksheet range.
Public interfaceValueChangeRepresents a value that has been changed in a PivotTable report that is based on an OLAP data source.
Public interfaceVPageBreakRepresents a vertical page break.
Public interfaceVPageBreaksA collection of vertical page breaks within the print area. Each vertical page break is represented by a VPageBreak object.
Public interfaceWallsRepresents the walls of a 3-D chart.
Public interfaceWatchRepresents a range which is tracked when the worksheet is recalculated.
Public interfaceWatchesA collection of all the Watch objects in a specified application.
Public interfaceWebOptionsContains workbook-level attributes used by Microsoft Excel when you save a document as a Web page or open a Web page.
Public interfaceWindowRepresents a window. Many worksheet characteristics, such as scroll bars and gridlines, are actually properties of the window.
Public interfaceWindowsA collection of all the Window objects in Microsoft Excel.
Public interfaceWorkbookRepresents a Microsoft Excel workbook.
Public interfaceWorkbookConnectionA connection is a set of information needed to obtain data from an external data source other than an 1st_Excel12 workbook.
Public interfaceWorkbookEventsReserved for internal use.
Public interfaceWorkbookEvents_EventEvents interface for Microsoft Excel Workbook object events.
Public interfaceWorkbooksA collection of all the Workbook objects that are currently open in the Microsoft Excel application.
Public interfaceWorksheetRepresents a worksheet.
Public interfaceWorksheetFunctionUsed as a container for Microsoft Excel worksheet functions that can be called from Visual Basic.
Public interfaceWorksheetsA collection of all the Worksheet objects in the specified or active workbook. Each Worksheet object represents a worksheet.
Public interfaceWorksheetViewA collection of all the WorksheetView objects in the specified or active workbook.
Public interfaceXmlDataBindingRepresents the connection to the source data for an XmlMap object.
Public interfaceXmlMapRepresents an XML map that has been added to a workbook.
Public interfaceXmlMapsRepresents the collection of XmlMap objects that have been added to a workbook.
Public interfaceXmlNamespaceRepresents a namespace that has been added to a workbook.
Public interfaceXmlNamespacesRepresents the collection of XmlNamespace objects in a workbook.
Public interfaceXmlSchemaRepresents an XML schema contained by an XmlMap object.
Public interfaceXmlSchemasRepresents the collection of XmlSchema objects contained by an XmlMap object.
Public interfaceXPathRepresents an XPath that has been mapped to a Range or ListColumn object.

  DelegateDescription
Public delegateAppEvents_AfterCalculateEventHandlerA 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.
Public delegateAppEvents_NewWorkbookEventHandlerA Delegate type used to add an event handler for the NewWorkbook event. The NewWorkbook event occurs when a new workbook is created.
Public delegateAppEvents_ProtectedViewWindowActivateEventHandlerA Delegate type used to add an event handler for the ProtectedViewWindowActivate event. The ProtectedViewWindowActivate event occurs when a Protected View window is activated.
Public delegateAppEvents_ProtectedViewWindowBeforeCloseEventHandlerA 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.
Public delegateAppEvents_ProtectedViewWindowBeforeEditEventHandlerA 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.
Public delegateAppEvents_ProtectedViewWindowDeactivateEventHandlerA Delegate type used to add an event handler for the ProtectedViewWindowDeactivate event. The ProtectedViewWindowDeactivate event occurs when a Protected View window is deactivated.
Public delegateAppEvents_ProtectedViewWindowOpenEventHandlerA 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.
Public delegateAppEvents_ProtectedViewWindowResizeEventHandlerA Delegate type used to add an event handler for the ProtectedViewWindowResize event. The ProtectedViewWindowResize event occurs when any Protected View window is resized.
Public delegateAppEvents_SheetActivateEventHandlerA Delegate type used to add an event handler for the SheetActivate event. The SheetActivate event occurs when any sheet is activated.
Public delegateAppEvents_SheetBeforeDoubleClickEventHandlerA 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.
Public delegateAppEvents_SheetBeforeRightClickEventHandlerA 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.
Public delegateAppEvents_SheetCalculateEventHandlerA 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.
Public delegateAppEvents_SheetChangeEventHandlerA 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.
Public delegateAppEvents_SheetDeactivateEventHandlerA Delegate type used to add an event handler for the SheetDeactivate event. The SheetDeactivate event occurs when any sheet is deactivated.
Public delegateAppEvents_SheetFollowHyperlinkEventHandlerA Delegate type used to add an event handler for the SheetFollowHyperlink event. The SheetFollowHyperlink event occurs when you click any hyperlink in Microsoft Excel.
Public delegateAppEvents_SheetPivotTableAfterValueChangeEventHandlerA 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).
Public delegateAppEvents_SheetPivotTableBeforeAllocateChangesEventHandlerA Delegate type used to add an event handler for the SheetPivotTableBeforeAllocateChanges event. The SheetPivotTableBeforeAllocateChanges event occurs before changes are applied to a PivotTable.
Public delegateAppEvents_SheetPivotTableBeforeCommitChangesEventHandlerA 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.
Public delegateAppEvents_SheetPivotTableBeforeDiscardChangesEventHandlerA Delegate type used to add an event handler for the SheetPivotTableBeforeDiscardChanges event. The SheetPivotTableBeforeDiscardChanges event occurs before changes to a PivotTable are discarded.
Public delegateAppEvents_SheetPivotTableUpdateEventHandlerA 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.
Public delegateAppEvents_SheetSelectionChangeEventHandlerA Delegate type used to add an event handler for the SheetSelectionChange event. The SheetSelectionChange event occurs when the selection changes on any worksheet.
Public delegateAppEvents_WindowActivateEventHandlerA Delegate type used to add an event handler for the WindowActivate event. The WindowActivate event occurs when any workbook window is activated.
Public delegateAppEvents_WindowDeactivateEventHandlerA Delegate type used to add an event handler for the WindowDeactivate event. The WindowDeactivate event occurs when any workbook window is deactivated.
Public delegateAppEvents_WindowResizeEventHandlerA Delegate type used to add an event handler for the WindowResize event. The WindowResize event occurs when any workbook window is resized.
Public delegateAppEvents_WorkbookActivateEventHandlerA Delegate type used to add an event handler for the WorkbookActivate event. The WorkbookActivate event occurs when any workbook is activated.
Public delegateAppEvents_WorkbookAddinInstallEventHandlerA 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.
Public delegateAppEvents_WorkbookAddinUninstallEventHandlerA Delegate type used to add an event handler for the WorkbookAddinUninstall event. The WorkbookAddinUninstall event occurs when any add-in workbook is uninstalled.
Public delegateAppEvents_WorkbookAfterSaveEventHandlerA Delegate type used to add an event handler for the WorkbookAfterSave event. The WorkbookAfterSave event occurs after the workbook is saved.
Public delegateAppEvents_WorkbookAfterXmlExportEventHandlerA 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.
Public delegateAppEvents_WorkbookAfterXmlImportEventHandlerA 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.
Public delegateAppEvents_WorkbookBeforeCloseEventHandlerA Delegate type used to add an event handler for the WorkbookBeforeClose event. The WorkbookBeforeClose event occurs immediately before any open workbook closes.
Public delegateAppEvents_WorkbookBeforePrintEventHandlerA Delegate type used to add an event handler for the WorkbookBeforePrint event. The WorkbookBeforePrint event occurs before any open workbook is printed.
Public delegateAppEvents_WorkbookBeforeSaveEventHandlerA Delegate type used to add an event handler for the WorkbookBeforeSave event. The WorkbookBeforeSave event occurs before any open workbook is saved.
Public delegateAppEvents_WorkbookBeforeXmlExportEventHandlerA 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.
Public delegateAppEvents_WorkbookBeforeXmlImportEventHandlerA 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.
Public delegateAppEvents_WorkbookDeactivateEventHandlerA Delegate type used to add an event handler for the WorkbookDeactivate event. The WorkbookDeactivate event occurs when any open workbook is deactivated.
Public delegateAppEvents_WorkbookNewChartEventHandlerA 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.
Public delegateAppEvents_WorkbookNewSheetEventHandlerA 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.
Public delegateAppEvents_WorkbookOpenEventHandlerA Delegate type used to add an event handler for the WorkbookOpen event. The WorkbookOpen event occurs when a workbook is opened.
Public delegateAppEvents_WorkbookPivotTableCloseConnectionEventHandlerA Delegate type used to add an event handler for the WorkbookPivotTableCloseConnection event. The WorkbookPivotTableCloseConnection event occurs after a PivotTable report connection has been closed.
Public delegateAppEvents_WorkbookPivotTableOpenConnectionEventHandlerA Delegate type used to add an event handler for the WorkbookPivotTableOpenConnection event. The WorkbookPivotTableOpenConnection event occurs after a PivotTable report connection has been opened.
Public delegateAppEvents_WorkbookRowsetCompleteEventHandlerA 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.
Public delegateAppEvents_WorkbookSyncEventHandlerA 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.
Public delegateChartEvents_ActivateEventHandlerA 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.
Public delegateChartEvents_BeforeDoubleClickEventHandlerA 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.
Public delegateChartEvents_BeforeRightClickEventHandlerA 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.
Public delegateChartEvents_CalculateEventHandlerA Delegate type used to add an event handler for the Calculate event. The Calculate event occurs after the chart plots new or changed data.
Public delegateChartEvents_DeactivateEventHandlerA Delegate type used to add an event handler for the Deactivate event. The Deactivate event occurs when the chart is deactivated.
Public delegateChartEvents_DragOverEventHandlerA 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.
Public delegateChartEvents_DragPlotEventHandlerA 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.
Public delegateChartEvents_MouseDownEventHandlerA 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.
Public delegateChartEvents_MouseMoveEventHandlerA 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.
Public delegateChartEvents_MouseUpEventHandlerA 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.
Public delegateChartEvents_ResizeEventHandlerA Delegate type used to add an event handler for the Resize event. The Resize event occurs when the chart is resized.
Public delegateChartEvents_SelectEventHandlerA Delegate type used to add an event handler for the Select event. The Select event occurs when a chart element is selected.
Public delegateChartEvents_SeriesChangeEventHandlerA 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.
Public delegateDocEvents_ActivateEventHandlerA Delegate type used to add an event handler for the Activate event. The Activate event occurs when a worksheet is activated.
Public delegateDocEvents_BeforeDoubleClickEventHandlerA 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.
Public delegateDocEvents_BeforeRightClickEventHandlerA 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.
Public delegateDocEvents_CalculateEventHandlerA Delegate type used to add an event handler for the Calculate event. The Calculate event occurs after the worksheet is recalculated.
Public delegateDocEvents_ChangeEventHandlerA 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.
Public delegateDocEvents_DeactivateEventHandlerA Delegate type used to add an event handler for the Deactivate event. The Deactivate event occurs when the worksheet is deactivated.
Public delegateDocEvents_FollowHyperlinkEventHandlerA Delegate type used to add an event handler for the FollowHyperlink event. The FollowHyperlink event occurs when you click any hyperlink on a worksheet.
Public delegateDocEvents_PivotTableAfterValueChangeEventHandlerA 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).
Public delegateDocEvents_PivotTableBeforeAllocateChangesEventHandlerA Delegate type used to add an event handler for the PivotTableBeforeAllocateChanges event. The PivotTableBeforeAllocateChanges event occurs before changes are applied to a PivotTable.
Public delegateDocEvents_PivotTableBeforeCommitChangesEventHandlerA 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.
Public delegateDocEvents_PivotTableBeforeDiscardChangesEventHandlerA Delegate type used to add an event handler for the PivotTableBeforeDiscardChanges event. The PivotTableBeforeDiscardChanges event occurs before changes to a PivotTable are discarded.
Public delegateDocEvents_PivotTableChangeSyncEventHandlerA Delegate type used to add an event handler for the PivotTableChangeSync event. The PivotTableChangeSync event occurs after changes to a PivotTable.
Public delegateDocEvents_PivotTableUpdateEventHandlerA 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.
Public delegateDocEvents_SelectionChangeEventHandlerA Delegate type used to add an event handler for the SelectionChange event. The SelectionChange event occurs when the selection changes on a worksheet.
Public delegateOLEObjectEvents_GotFocusEventHandlerA Delegate type used to add an event handler for the GotFocus event. The GotFocus event occurs when an ActiveX control gets input focus.
Public delegateOLEObjectEvents_LostFocusEventHandlerA Delegate type used to add an event handler for the LostFocus event. The LostFocus event occurs when an ActiveX control loses input focus.
Public delegateRefreshEvents_AfterRefreshEventHandlerA Delegate type used to add an event handler for the AfterRefresh event. The AfterRefresh event occurs after a query is completed or canceled.
Public delegateRefreshEvents_BeforeRefreshEventHandlerA Delegate type used to add an event handler for the BeforeRefresh event. The BeforeRefresh event occurs before any refreshes of the query table.
Public delegateWorkbookEvents_ActivateEventHandlerA Delegate type used to add an event handler for the Activate event. The Activate event occurs when a workbook is activated.
Public delegateWorkbookEvents_AddinInstallEventHandlerA 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.
Public delegateWorkbookEvents_AddinUninstallEventHandlerA 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.
Public delegateWorkbookEvents_AfterSaveEventHandlerA Delegate type used to add an event handler for the AfterSave event. The AfterSave event occurs after the workbook is saved.
Public delegateWorkbookEvents_AfterXmlExportEventHandlerA 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.
Public delegateWorkbookEvents_AfterXmlImportEventHandlerA 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.
Public delegateWorkbookEvents_BeforeCloseEventHandlerA 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.
Public delegateWorkbookEvents_BeforePrintEventHandlerA 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.
Public delegateWorkbookEvents_BeforeSaveEventHandlerA Delegate type used to add an event handler for the BeforeSave event. The BeforeSave event occurs before the workbook is saved.
Public delegateWorkbookEvents_BeforeXmlExportEventHandlerA 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.
Public delegateWorkbookEvents_BeforeXmlImportEventHandlerA 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.
Public delegateWorkbookEvents_DeactivateEventHandlerA Delegate type used to add an event handler for the Deactivate event. The Deactivate event occurs when the workbook is deactivated.
Public delegateWorkbookEvents_NewChartEventHandlerA 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.
Public delegateWorkbookEvents_NewSheetEventHandlerA 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.
Public delegateWorkbookEvents_OpenEventHandlerA Delegate type used to add an event handler for the Open event. The Open event occurs when the workbook is opened.
Public delegateWorkbookEvents_PivotTableCloseConnectionEventHandlerA 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.
Public delegateWorkbookEvents_PivotTableOpenConnectionEventHandlerA 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.
Public delegateWorkbookEvents_RowsetCompleteEventHandlerA 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.
Public delegateWorkbookEvents_SheetActivateEventHandlerA Delegate type used to add an event handler for the SheetActivate event. The SheetActivate event occurs when any sheet is activated.
Public delegateWorkbookEvents_SheetBeforeDoubleClickEventHandlerA 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.
Public delegateWorkbookEvents_SheetBeforeRightClickEventHandlerA 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.
Public delegateWorkbookEvents_SheetCalculateEventHandlerA 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.
Public delegateWorkbookEvents_SheetChangeEventHandlerA 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.
Public delegateWorkbookEvents_SheetDeactivateEventHandlerA Delegate type used to add an event handler for the SheetDeactivate event. The SheetDeactivate event occurs when any sheet is deactivated.
Public delegateWorkbookEvents_SheetFollowHyperlinkEventHandlerA Delegate type used to add an event handler for the SheetFollowHyperlink event. The SheetFollowHyperlink event occurs when you click any hyperlink in Microsoft Excel.
Public delegateWorkbookEvents_SheetPivotTableAfterValueChangeEventHandlerA 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).
Public delegateWorkbookEvents_SheetPivotTableBeforeAllocateChangesEventHandlerA Delegate type used to add an event handler for the SheetPivotTableBeforeAllocateChanges event. The SheetPivotTableBeforeAllocateChanges event occurs before changes are applied to a PivotTable.
Public delegateWorkbookEvents_SheetPivotTableBeforeCommitChangesEventHandlerA 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.
Public delegateWorkbookEvents_SheetPivotTableBeforeDiscardChangesEventHandlerA Delegate type used to add an event handler for the SheetPivotTableBeforeDiscardChanges event. The SheetPivotTableBeforeDiscardChanges event occurs before changes to a PivotTable are discarded.
Public delegateWorkbookEvents_SheetPivotTableChangeSyncEventHandlerA Delegate type used to add an event handler for the SheetPivotTableChangeSync event. The SheetPivotTableChangeSync event occurs after changes to a PivotTable.
Public delegateWorkbookEvents_SheetPivotTableUpdateEventHandlerA 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.
Public delegateWorkbookEvents_SheetSelectionChangeEventHandlerA 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).
Public delegateWorkbookEvents_SyncEventHandlerA 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.
Public delegateWorkbookEvents_WindowActivateEventHandlerA Delegate type used to add an event handler for the WindowActivate event. The WindowActivate event occurs when any workbook window is activated.
Public delegateWorkbookEvents_WindowDeactivateEventHandlerA Delegate type used to add an event handler for the WindowDeactivate event. The WindowDeactivate event occurs when any workbook window is deactivated.
Public delegateWorkbookEvents_WindowResizeEventHandlerA Delegate type used to add an event handler for the WindowResize event. The WindowResize event occurs when any workbook window is resized.

  EnumerationDescription
Public enumerationConstantsSpecifies global constants used in Microsoft Excel.
Public enumerationXlAboveBelowSpecifies if the values are above or below average.
Public enumerationXlActionTypeSpecifies the action that should be performed.
Public enumerationXlAllocationSpecifies when to calculate changes when performing what-if analysis on a PivotTable based on an OLAP data source.
Public enumerationXlAllocationMethodSpecifies the method to use to allocate values when performing what-if analysis on a PivotTable report based on an OLAP data source.
Public enumerationXlAllocationValueSpecifies what value to allocate when performing what-if analysis on a PivotTable report based on an OLAP data source.
Public enumerationXlApplicationInternationalSpecifies country/region and international settings.
Public enumerationXlApplyNamesOrderSpecifies which range name is listed first when a cell reference is replaced by a row-oriented and column-oriented range name.
Public enumerationXlArabicModesSpecifies spelling rules for the Arabic spelling checker.
Public enumerationXlArrangeStyleSpecifies how windows are arranged on the screen.
Public enumerationXlArrowHeadLengthSpecifies the length of the arrowhead at the end of a line.
Public enumerationXlArrowHeadStyleSpecifies the type of arrowhead to apply to the line end.
Public enumerationXlArrowHeadWidthSpecifies the width of the arrowhead at the line end.
Public enumerationXlAutoFillTypeSpecifies how the target range is to be filled, based on the contents of the source range.
Public enumerationXlAutoFilterOperatorSpecifies the operator to use to associate two criteria applied by a filter.
Public enumerationXlAxisCrossesSpecifies the point on the specified axis where the other axis crosses.
Public enumerationXlAxisGroupSpecifies the type of axis group.
Public enumerationXlAxisTypeSpecifies the axis type.
Public enumerationXlBackgroundSpecifies the background type for text in charts.
Public enumerationXlBarShapeSpecifies the shape used with the 3-D bar or column chart.
Public enumerationXlBordersIndexSpecifies the border to be retrieved.
Public enumerationXlBorderWeightSpecifies the weight of the border around a range.
Public enumerationXlBuiltInDialogSpecifies which dialog box to display.
Public enumerationXlCalcForSpecifies what should be calculated.
Public enumerationXlCalculatedMemberTypeSpecifies the type of a calculated member in a pivot table.
Public enumerationXlCalculationSpecifies the calculation mode.
Public enumerationXlCalculationInterruptKeySpecifies which key interrupts recalculation.
Public enumerationXlCalculationStateSpecifies the calculation state of the application.
Public enumerationXlCategoryTypeSpecifies the type of the category axis.
Public enumerationXlCellChangedStateSpecifies whether a PivotTable value cell has been edited or recalculated since the PivotTable report was created or the last commit operation was performed.
Public enumerationXlCellInsertionModeSpecifies the way rows on the specified worksheet are added or deleted to accommodate the number of rows in a recordset returned by a query.
Public enumerationXlCellTypeSpecifies the type of cells.
Public enumerationXlChartElementPositionSpecifies the position of the chart element.
Public enumerationXlChartGallerySpecifies a chart gallery.
Public enumerationXlChartItemSpecifies the type of the chart item.
Public enumerationXlChartLocationSpecifies where to relocate a chart.
Public enumerationXlChartPicturePlacementSpecifies the placement of a user-selected picture on a bar in a 3-D bar or column.
Public enumerationXlChartPictureTypeSpecifies how pictures are displayed on a column, bar picture chart, or legend key.
Public enumerationXlChartSplitTypeSpecifies the values displayed in the second chart in a pie chart or a bar of pie chart.
Public enumerationXlChartTypeSpecifies the chart type.
Public enumerationXlCheckInVersionTypeSpecifies the type of version for the document checked in when using the CheckIn method. Applies to workbooks stored in a SharePoint library.
Public enumerationXlClipboardFormatSpecifies the format of an item on the Windows clipboard.
Public enumerationXlCmdTypeSpecifies the value of the CommandText property.
Public enumerationXlColorIndexSpecifies the color of a selected feature such as border, font, or fill.
Public enumerationXlColumnDataTypeSpecifies how a column is to be parsed.
Public enumerationXlCommandUnderlinesSpecifies the state of the command underlines in Microsoft Excel for the Macintosh.
Public enumerationXlCommentDisplayModeSpecifies the way cells display comments and comment indicators.
Public enumerationXlConditionValueTypesSpecifies the types of condition values that can be used.
Public enumerationXlConnectionTypeSpecifies the type of database connection.
Public enumerationXlConsolidationFunctionSpecifies the subtotal function.
Public enumerationXlContainsOperatorSpecifies the operator used in a function.
Public enumerationXlCopyPictureFormatSpecifies the format of the picture being copied.
Public enumerationXlCorruptLoadSpecifies the processing for a file when it is opened.
Public enumerationXlCreatorSpecifies the 32-bit creator code for Excel for Macintosh (decimal 1480803660, Hex 5843454C, string XCEL).
Public enumerationXlCredentialsMethodSpecifies the type of credentials method used.
Public enumerationXlCubeFieldSubTypeSpecifies the subtype of the CubeField.
Public enumerationXlCubeFieldTypeSpecifies whether the OLAP field is a hierarchy, set, or measure field.
Public enumerationXlCutCopyModeSpecifies whether status is Copy mode or Cut mode.
Public enumerationXlCVErrorSpecifies the cell error number and value.
Public enumerationXlDataBarAxisPositionSpecifies the axis position for a range of cells with conditional formatting as data bars.
Public enumerationXlDataBarBorderTypeSpecifies the border of a data bar.
Public enumerationXlDataBarFillTypeSpecifies how a data bar is filled with color.
Public enumerationXlDataBarNegativeColorTypeSpecifies whether to use the same border and fill color as postive data bars.
Public enumerationXlDataLabelPositionSpecifies where the data label is positioned.
Public enumerationXlDataLabelSeparatorSpecifies the separator used with data labels.
Public enumerationXlDataLabelsTypeSpecifies the type of data label to apply.
Public enumerationXlDataSeriesDateSpecifies the type of date to apply to a data series.
Public enumerationXlDataSeriesTypeSpecifies the data series to create.
Public enumerationXlDeleteShiftDirectionSpecifies how to shift cells to replace deleted cells.
Public enumerationXlDirectionSpecifies the direction in which to move.
Public enumerationXlDisplayBlanksAsSpecifies how blank cells are plotted on a chart.
Public enumerationXlDisplayDrawingObjectsSpecifies how shapes are displayed.
Public enumerationXlDisplayUnitSpecifies the display unit label for an axis.
Public enumerationXlDupeUniqueSpecifies whether duplicate or unique values shoud be displayed.
Public enumerationXlDVAlertStyleSpecifies the icon used in message boxes displayed during validation.
Public enumerationXlDVTypeSpecifies the type of validation test to be performed in conjunction with values.
Public enumerationXlDynamicFilterCriteriaSpecifies the filter criterion.
Public enumerationXlEditionFormatSpecifies the format of the published edition. This is Macintosh only and should not be used.
Public enumerationXlEditionOptionsOptionThis enumeration is for Macintosh only and should not be used.
Public enumerationXlEditionTypeSpecifies the type of edition to be changed.
Public enumerationXlEnableCancelKeySpecifies how Microsoft Excel handles CTRL+BREAK (or ESC or COMMAND+PERIOD) user interruptions to the running procedure.
Public enumerationXlEnableSelectionSpecifies what can be selected on the sheet.
Public enumerationXlEndStyleCapSpecifies the end style for error bars.
Public enumerationXlErrorBarDirectionSpecifies which axis values are to receive error bars.
Public enumerationXlErrorBarIncludeSpecifies which error bar parts to include.
Public enumerationXlErrorBarTypeSpecifies the range marked by error bars.
Public enumerationXlErrorChecksSpecifies the type of error object to be retrieved from the Errors collection.
Public enumerationXlFileAccessSpecifies the new access mode for the object.
Public enumerationXlFileFormatSpecifies the file format when saving the spreadsheet.
Public enumerationXlFileValidationPivotModeSpecifies how to validate the data caches for PivotTable reports.
Public enumerationXlFillWithSpecifies how to copy the range.
Public enumerationXlFilterActionSpecifies whether data is to be copied or left in place during a filter operation.
Public enumerationXlFilterAllDatesInPeriodSpecifies how dates should be filtered in the specified period.
Public enumerationXlFindLookInSpecifies the type of data to search.
Public enumerationXlFixedFormatQualitySpecifies the quality of speadsheets saved in different fixed formats.
Public enumerationXlFixedFormatTypeSpecifies the type of file format.
Public enumerationXlFormatConditionOperatorSpecifies the operator to use to compare a formula against the value in a cell or, for xlBetween and xlNotBetween, to compare two formulas.
Public enumerationXlFormatConditionTypeSpecifies whether the conditional format is based on a cell value or an expression.
Public enumerationXlFormatFilterTypesSpecifies the types of format filters.
Public enumerationXlFormControlSpecifies the type of the form control.
Public enumerationXlFormulaLabelSpecifies the formula label type for the specified range.
Public enumerationXlGenerateTableRefsSpecifies the type of table references.
Public enumerationXlGradientFillTypeSpecifies the type of gradient fill.
Public enumerationXlHAlignSpecifies the horizontal alignment for the object.
Public enumerationXlHebrewModesSpecifies the mode for the Hebrew spelling checker.
Public enumerationXlHighlightChangesTimeSpecifies which set of changes is shown in a shared workbook.
Public enumerationXlHtmlTypeSpecifies 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.
Public enumerationXlIconSpecifies the icon for a criterion in an icon set conditional formatting rule.
Public enumerationXlIconSetSpecifies the type of icon set.
Public enumerationXlIMEModeSpecifies the description of the Japanese input rules.
Public enumerationXlImportDataAsSpecifies the format in which to return data from a database.
Public enumerationXlInsertFormatOriginSpecifies from where to copy the format for inserted rows.
Public enumerationXlInsertShiftDirectionSpecifies the direction in which to shift cells during an insertion.
Public enumerationXlLayoutFormTypeSpecifies the way the specified PivotTable items appear—in table format or in outline format.
Public enumerationXlLayoutRowTypeSpecifies the type of layout row.
Public enumerationXlLegendPositionSpecifies the position of the legend on a chart.
Public enumerationXlLineStyleSpecifies the line style for the border.
Public enumerationXlLinkSpecifies the type of link.
Public enumerationXlLinkInfoSpecifies the type of information to be returned.
Public enumerationXlLinkInfoTypeSpecifies the type of link.
Public enumerationXlLinkStatusSpecifies the status of a link.
Public enumerationXlLinkTypeSpecifies the type of link.
Public enumerationXlListConflictSpecifies 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.
Public enumerationXlListDataTypeSpecifies the data type of a list column connected to a Microsoft Windows SharePoint Services site.
Public enumerationXlListObjectSourceTypeSpecifies the current source of the list.
Public enumerationXlLocationInTableSpecifies the part of the PivotTable report that contains the upper-left corner of a range.
Public enumerationXlLookAtSpecifies whether a match is made against the whole of the search text or any part of the search text.
Public enumerationXlLookForSpecifies what to look for in searches.
Public enumerationXlMailSystemSpecifies the mail system that is installed on the host machine.
Public enumerationXlMarkerStyleSpecifies the marker style for a point or series in a line chart, scatter chart, or radar chart.
Public enumerationXlMeasurementUnitsSpecifies the measurement units.
Public enumerationXlMouseButtonSpecifies which mouse button was pressed.
Public enumerationXlMousePointerSpecifies the appearance of the mouse pointer in Microsoft Excel.
Public enumerationXlMSApplicationSpecifies a Microsoft application.
Public enumerationXlOartHorizontalOverflowSpecifies the horizontal overflow setting for a text frame.
Public enumerationXlOartVerticalOverflowSpecifies the vertical overflow setting for a text frame.
Public enumerationXlObjectSizeSpecifies the way a chart is scaled to fit on a page.
Public enumerationXlOLETypeSpecifies the OLE object type.
Public enumerationXlOLEVerbSpecifies the verb that the server of the OLE object should act on.
Public enumerationXlOrderSpecifies the order in which cells are processed.
Public enumerationXlOrientationSpecifies the text orientation.
Public enumerationXlPageBreakSpecifies page break location in the worksheet.
Public enumerationXlPageBreakExtentSpecifies whether a page break is full screen or applies only within the print area.
Public enumerationXlPageOrientationSpecifies the page orientation when the worksheet is printed.
Public enumerationXlPaperSizeSpecifies the size of the paper.
Public enumerationXlParameterDataTypeSpecifies the data type of a query parameter.
Public enumerationXlParameterTypeSpecifies how to determine the value of the parameter for the specified query table.
Public enumerationXlPasteSpecialOperationSpecifies how numeric data will be calculated with the destinations cells in the worksheet.
Public enumerationXlPasteTypeSpecifies the part of the range to be pasted.
Public enumerationXlPatternSpecifies the interior pattern of a chart or interior object.
Public enumerationXlPhoneticAlignmentSpecifies the alignment for phonetic text.
Public enumerationXlPhoneticCharacterTypeSpecifies the type of phonetic text in a cell.
Public enumerationXlPictureAppearanceSpecifies how the picture should be copied.
Public enumerationXlPictureConvertorTypeSpecifies how to convert a graphic.
Public enumerationXlPieSliceIndexSpecifies which position on the slice to return the coordinate of.
Public enumerationXlPieSliceLocationSpecifies 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.
Public enumerationXlPivotCellTypeSpecifies the PivotTable entity the cell corresponds to.
Public enumerationXlPivotConditionScopeThis enumeration specifies the conditional formatting applied for filtering values from the PivotTable object.
Public enumerationXlPivotFieldCalculationSpecifies the type of calculation performed by a data PivotField when a custom calculation is used.
Public enumerationXlPivotFieldDataTypeSpecifies the type of data in the PivotTable field.
Public enumerationXlPivotFieldOrientationSpecifies the location of the field in a PivotTable report.
Public enumerationXlPivotFieldRepeatLabelsSpecifies whether to repeat all field item labels in a PivotTable report.
Public enumerationXlPivotFilterTypeThe type of filter applied.
Public enumerationXlPivotFormatTypeSpecifies the type of report formatting to be applied to the specified PivotTable report.
Public enumerationXlPivotLineTypeSpecifies the type of the PivotLine.
Public enumerationXlPivotTableMissingItemsSpecifies the maximum number of unique items per PivotField allowed.
Public enumerationXlPivotTableSourceTypeSpecifies the source of the report data.
Public enumerationXlPivotTableVersionListSpecifies 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.
Public enumerationXlPlacementSpecifies the way an object is attached to its underlying cells.
Public enumerationXlPlatformSpecifies the platform that a text file originated on.
Public enumerationXlPortugueseReformSpecifies the mode for checking the spelling of Portuguese.
Public enumerationXlPrintErrorsSpecifies the type of print error displayed.
Public enumerationXlPrintLocationSpecifies the way comments are printed with the sheet.
Public enumerationXlPrioritySpecifies the priority of a SendMailer message.
Public enumerationXlPropertyDisplayedInSpecifies where to display the property.
Public enumerationXlProtectedViewCloseReasonSpecifies how the Protected View window was closed.
Public enumerationXlProtectedViewWindowStateSpecifies the state of the Protected View window.
Public enumerationXlPTSelectionModeSpecifies what may be selected in a PivotTable during a structured selection. These constants may be combined to select multiple types.
Public enumerationXlQueryTypeSpecifies the type of query used by Microsoft Excel to populate the query table or PivotTable cache.
Public enumerationXlRangeAutoFormatSpecifies the predefined format when a range is automatically formatted.
Public enumerationXlRangeValueDataTypeSpecifies the range value data type.
Public enumerationXlReferenceStyleSpecifies the reference style.
Public enumerationXlReferenceTypeSpecifies cell reference style when a formula is being converted.
Public enumerationXlRemoveDocInfoTypeSpecifies the type information to be removed from the document information.
Public enumerationXlRgbColorSpecifies the RGB color.
Public enumerationXlRobustConnectSpecifies how the PivotTable cache connects to its data source.
Public enumerationXlRoutingSlipDeliverySpecifies the routing delivery method.
Public enumerationXlRoutingSlipStatusSpecifies the status of the routing slip.
Public enumerationXlRowColSpecifies whether the values corresponding to a particular data series are in rows or columns.
Public enumerationXlRunAutoMacroSpecifies the automatic macro to run.
Public enumerationXlSaveActionSpecifies during file close if the file will be saved.
Public enumerationXlSaveAsAccessModeSpecifies the access mode for the Save As function.
Public enumerationXlSaveConflictResolutionSpecifies the way conflicts are to be resolved whenever a shared workbook is updated.
Public enumerationXlScaleTypeSpecifies the scale type of the value axis.
Public enumerationXlSearchDirectionSpecifies the search direction when searching a range.
Public enumerationXlSearchOrderSpecifies the order in which to search the range.
Public enumerationXlSearchWithinSpecifies the extent of the search for the range.
Public enumerationXlSheetTypeSpecifies the worksheet type.
Public enumerationXlSheetVisibilitySpecifies whether the object is visible.
Public enumerationXlSizeRepresentsSpecifies what the bubble size represents on a bubble chart.
Public enumerationXlSlicerCrossFilterTypeSpecifies the type of cross filtering used by the specified slicer cache and how it is visualized.
Public enumerationXlSlicerSortSpecifies 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.
Public enumerationXlSmartTagControlTypeSpecifies the type of Smart Document control displayed in the Document Actions task pane.
Public enumerationXlSmartTagDisplayModeSpecifies the display features for smart tags.
Public enumerationXlSortDataOptionSpecifies how to sort text.
Public enumerationXlSortMethodSpecifies the type of sort.
Public enumerationXlSortMethodOldSpecifies how to sort when using East Asian sorting methods.
Public enumerationXlSortOnSpecifies the parameter on which the data should be sorted.
Public enumerationXlSortOrderSpecifies the sort order for the specified field or range.
Public enumerationXlSortOrientationSpecifies the sort orientation.
Public enumerationXlSortTypeSpecifies which elements are to be sorted. Use this argument only when sorting PivotTable reports.
Public enumerationXlSourceTypeIdentifies the source object.
Public enumerationXlSpanishModesSpecifies the mode for checking the spelling of Spanish.
Public enumerationXlSparklineRowColSpecifies how to plot the sparkline when the data on which it is based is in a square-shaped range.
Public enumerationXlSparkScaleSpecifies how the minimum or maximum value of the vertical axis of the sparkline is scaled relative to other sparklines in the group.
Public enumerationXlSparkTypeSpecifies the type of sparkline.
Public enumerationXlSpeakDirectionSpecifies the order in which the cells are spoken.
Public enumerationXlSpecialCellsValueSpecifies cells with a particular type of value to include in the result.
Public enumerationXlStdColorScaleSpecifies the standard color scale.
Public enumerationXlSubscribeToFormatSpecifies the format to use when subscribing to a published edition.
Public enumerationXlSubtototalLocationTypeSpecifies where the subtotal will be displayed on the worksheet.
Public enumerationXlSummaryColumnSpecifies the location of the summary columns in the outline.
Public enumerationXlSummaryReportTypeSpecifies the type of summary to be created for scenarios.
Public enumerationXlSummaryRowSpecifies the location of the summary rows in the outline.
Public enumerationXlTableStyleElementTypeSpecifies the table style element used.
Public enumerationXlTabPositionSpecifies the first or last tab position.
Public enumerationXlTextParsingTypeSpecifies the column format for the data in the text file that you’re importing into a query table.
Public enumerationXlTextQualifierSpecifies the delimiter to use to specify text.
Public enumerationXlTextVisualLayoutTypeSpecifies whether the visual layout of the text being imported is left-to-right or right-to-left.
Public enumerationXlThemeColorSpecifies the theme color to be used.
Public enumerationXlThemeFontSpecifies the theme font to use.
Public enumerationXlThreadModeSpecifies the control over the multi-threaded calculation mode.
Public enumerationXlTickLabelOrientationSpecifies the text orientation for tick-mark labels.
Public enumerationXlTickLabelPositionSpecifies the position of tick-mark labels on the specified axis.
Public enumerationXlTickMarkSpecifies the position of major and minor tick marks for an axis.
Public enumerationXlTimePeriodsSpecifies the time period.
Public enumerationXlTimeUnitSpecifies unit of time for chart axis and data series.
Public enumerationXlToolbarProtectionSpecifies which properties of a toolbar are restricted. Options may be combined using Or.
Public enumerationXlTopBottomSpecifies the top 10 values from the top or bottom of a series of values.
Public enumerationXlTotalsCalculationSpecifies the type of calculation in the Totals row of a list column.
Public enumerationXlTrendlineTypeSpecifies how the trendline that smoothes out fluctuations in the data is calculated.
Public enumerationXlUnderlineStyleSpecifies the type of underline applied to a font.
Public enumerationXlUpdateLinksSpecifies a workbook's setting for updating embedded OLE links.
Public enumerationXlVAlignSpecifies the vertical alignment for the object.
Public enumerationXlWBATemplateSpecifies the type of workbook to create.
Public enumerationXlWebFormattingSpecifies how much formatting from a Web page, if any, is applied when a Web page is imported into a query table.
Public enumerationXlWebSelectionTypeSpecifies whether an entire Web page, all tables on the Web page, or only a specific table is imported into a query table.
Public enumerationXlWindowStateSpecifies the state of the window.
Public enumerationXlWindowTypeSpecifies how the chart is displayed.
Public enumerationXlWindowViewSpecifies the view showing in the window.
Public enumerationXlXLMMacroTypeSpecifies, in a Microsoft Excel version 4 macro worksheet, what type of macro a name refers to or whether the name refers to a macro.
Public enumerationXlXmlExportResultSpecifies the results of the save or export operation.
Public enumerationXlXmlImportResultSpecifies the results of the refresh or import operation.
Public enumerationXlXmlLoadOptionSpecifies how Excel opens the XML data file.
Public enumerationXlYesNoGuessSpecifies whether or not the first row contains headers.

Community Additions

ADD
Show:
© 2014 Microsoft