Compartir a través de

Microsoft.Office.Interop.Excel Namespace

  • Artículo

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.

Classes

  Class Description
Public class AppEvents_SinkHelper Reserved for internal use.
Public class ApplicationClass Reserved for internal use.
Public class ChartClass Reserved for internal use.
Public class ChartEvents_SinkHelper Reserved for internal use.
Public class DocEvents_SinkHelper Reserved for internal use.
Public class GlobalClass Reserved for internal use.
Public class OLEObjectClass Reserved for internal use.
Public class OLEObjectEvents_SinkHelper Reserved for internal use.
Public class QueryTableClass Reserved for internal use.
Public class RefreshEvents_SinkHelper Reserved for internal use.
Public class WorkbookClass Reserved for internal use.
Public class WorkbookEvents_SinkHelper Reserved for internal use.
Public class WorksheetClass Reserved for internal use.

Interfaces

  Interface Description
Public interface _Application Represents the entire Microsoft Excel application.
Public interface _Chart Represents a chart in a workbook. The chart can be either an embedded chart (contained in a ChartObject) or a separate chart sheet.
Public interface _Global Reserved for internal use.
Public interface _IOLEObject Reserved for internal use.
Public interface _IQueryTable Reserved for internal use.
Public interface _OLEObject Represents an ActiveX control or a linked or embedded OLE object on a worksheet. The OLEObject object is a member of the OLEObjects collection. The OLEObjects collection contains all the OLE objects on a single worksheet.
Public interface _QueryTable Represents a worksheet table built from data returned from an external data source, such as a SQL server or a Microsoft Access database. The QueryTable object is a member of the QueryTables collection.
Public interface _Workbook Represents a Microsoft Excel workbook.
Public interface _Worksheet Represents a worksheet.
Public interface AboveAverage Represents an above average visual of a conditional formatting rule. Applying a color or fill to a range or selection to help you see the value of a cells relative to other cells.
Public interface Action Represents an action to be executed in PivotTable or Worksheetdata.
Public interface Actions A collection of all Action objects for the specified series.
Public interface AddIn Represents a single add-in, either installed or not installed.
Public interface AddIns A collection of AddIn objects that represents all the add-ins available to Microsoft Excel, regardless of whether they’re installed. This list corresponds to the list of add-ins displayed in the Add-Ins dialog box (Tools menu).
Public interface AddIns2 A collection of AddIn objects that represent all the add-ins that are currently available or open in Microsoft Excel, regardless of whether they are installed.
Public interface Adjustments Contains a collection of adjustment values for the specified AutoShape, WordArt object, or connector.
Public interface AllowEditRange Represents the cells that can be edited on a protected worksheet.
Public interface AllowEditRanges A collection of all the AllowEditRange objects that represent the cells that can be edited on a protected worksheet.
Public interface AppEvents Reserved for internal use.
Public interface AppEvents_Event Events interface for Microsoft Excel Application object events.
Public interface Application Represents the entire Microsoft Excel application.
Public interface Arc Reserved for internal use.
Public interface Arcs Reserved for internal use.
Public interface Areas A collection of the areas, or contiguous blocks of cells, within a selection.
Public interface AutoCorrect Contains Microsoft Excel AutoCorrect attributes (capitalization of names of days, correction of two initial capital letters, automatic correction list, and so on).
Public interface AutoFilter Represents autofiltering for the specified worksheet.
Public interface AutoRecover Represents the automatic recovery features of a workbook.
Public interface Axes A collection of all the Axis objects in the specified chart.
Public interface Axis Represents a single axis in a chart.
Public interface AxisTitle Represents a chart axis title.
Public interface Border Represents the border of an object.
Public interface Borders A collection of four Border objects that represent the four borders of a Range or Style object.
Public interface Button Reserved for internal use.
Public interface Buttons Reserved for internal use.
Public interface CalculatedFields A collection of PivotField objects that represents all the calculated fields in the specified PivotTable report.
Public interface CalculatedItems A collection of PivotItem objects that represent all the calculated items in the specified PivotTable report.
Public interface CalculatedMember Represents the calculated fields and calculated items for PivotTables with Online Analytical Processing (OLAP) data sources.
Public interface CalculatedMembers A collection of all the CalculatedMember objects on the specified PivotTable.
Public interface CalloutFormat Contains properties and methods that apply to line callouts.
Public interface CellFormat Represents the search criteria for the cell format.
Public interface Characters Represents characters in an object that contains text. The Characters object lets you modify any sequence of characters contained in the full text string.
Public interface Chart Represents a chart in a workbook. The chart can be either an embedded chart (contained in a ChartObject) or a separate chart sheet.
Public interface ChartArea Represents the chart area of a chart. The chart area on a 2-D chart contains the axes, the chart title, the axis titles, and the legend. The chart area on a 3-D chart contains the chart title and the legend; it doesn’t include the plot area (the area within the chart area where the data is plotted). For information about formatting the plot area, see the PlotArea object.
Public interface ChartColorFormat Used only with charts. Represents the color of a one-color object or the foreground or background color of an object with a gradient or patterned fill.
Public interface ChartEvents Reserved for internal use.
Public interface ChartEvents_Event Events interface for Microsoft Excel Chart object events.
Public interface ChartFillFormat Used only with charts. Represents fill formatting for chart elements.
Public interface ChartFormat Provides access to the Office Art formatting for chart elements.
Public interface ChartGroup Represents one or more series plotted in a chart with the same format. The ChartGroup object is a member of the ChartGroups collection.
Public interface ChartGroups A collection of all the ChartGroup objects in the specified chart.
Public interface ChartObject Represents an embedded chart on a worksheet.
Public interface ChartObjects A collection of all the ChartObject objects on the specified chart sheet, dialog sheet, or worksheet.
Public interface Charts A collection of all the chart sheets in the specified or active workbook. Each chart sheet is represented by a Chart object. This doesn’t include charts embedded on worksheets or dialog sheets. For information about embedded charts, see the ChartObject object.
Public interface ChartTitle Represents the chart title.
Public interface ChartView Represents a view of a chart.
Public interface CheckBox Reserved for internal use.
Public interface CheckBoxes Reserved for internal use.
Public interface ColorFormat Represents the color of a one-color object, the foreground or background color of an object with a gradient or patterned fill, or the pointer color.
Public interface ColorScale Represents a color scale conditional formatting rule.
Public interface ColorScaleCriteria A collection of ColorScaleCriterion objects that represents all of the criteria for a color scale conditional format. Each criterion specifies the minimum, midpoint, or maximum threshold for the color scale.
Public interface ColorScaleCriterion Represents the criteria for the minimum, midpoint, or maximum thresholds for a color format conditional format.
Public interface ColorStop Represents the color stop point for a gradient fill in an range or selection.
Public interface ColorStops A collection of all the ColorStop objects for the specified series.
Public interface Comment Represents a cell comment.
Public interface Comments A collection of cell comments. Each comment is represented by a Comment object.
Public interface ConditionValue Represents how the shortest bar or longest bar is evaluated for a data bar conditional formatting rule.
Public interface Connections A collection of Connection objects for the specified workbook.
Public interface ConnectorFormat Contains properties and methods that apply to connectors.
Public interface ControlFormat Contains Microsoft Excel control properties.
Public interface Corners Represents the corners of a 3-D chart.
Public interface CubeField Represents a hierarchy or measure field from an OLAP cube.
Public interface CubeFields A collection of all CubeField objects in a PivotTable report that is based on an OLAP cube.
Public interface CustomProperties A collection of CustomProperty objects that represent additional information. The information can be used as metadata for XML.
Public interface CustomProperty Represents identifier information. Identifier information can be used as metadata for XML.
Public interface CustomView Represents a custom workbook view.
Public interface CustomViews A collection of custom workbook views. Each view is represented by a CustomView object.
Public interface Databar Represents a data bar conditional formating rule. Applying a data bar to a range helps you see the value of a cell relative to other cells.
Public interface DataBarBorder Represents the border of the data bars specified by a conditional formatting rule.
Public interface DataLabel Represents the data label on a chart point or trendline.
Public interface DataLabels A collection of all the DataLabel objects for the specified series. Each DataLabel object represents a data label for a point or trendline. For a series without definable points (such as an area series), the DataLabels collection contains a single data label.
Public interface DataTable Represents a chart data table.
Public interface DefaultWebOptions Contains global application-level attributes used by Microsoft Excel when you save a document as a Web page or open a Web page.
Public interface Diagram Represents a diagram.
Public interface DiagramNode Represents a node in a diagram.
Public interface DiagramNodeChildren A collection of DiagramNode objects that represents child nodes in a diagram.
Public interface DiagramNodes A collection of DiagramNode objects that represents all the nodes in a diagram.
Public interface Dialog Represents a built-in Microsoft Excel dialog box.
Public interface DialogFrame Reserved for internal use.
Public interface Dialogs A collection of all the Dialog objects in Microsoft Excel.
Public interface DialogSheet Reserved for internal use.
Public interface DialogSheets Reserved for internal use.
Public interface DialogSheetView Represents the current Dialogsheet view in a workbook.
Public interface DisplayFormat Represents the display settings for an associated Range object.
Public interface DisplayUnitLabel Represents a unit label on an axis in the specified chart.
Public interface DocEvents Reserved for internal use.
Public interface DocEvents_Event Events interface for Microsoft Excel Worksheet object events.
Public interface DownBars Represents the down bars in a chart group.
Public interface Drawing Reserved for internal use.
Public interface DrawingObjects Reserved for internal use.
Public interface Drawings Reserved for internal use.
Public interface DropDown Reserved for internal use.
Public interface DropDowns Reserved for internal use.
Public interface DropLines Represents the drop lines in a chart group.
Public interface EditBox Reserved for internal use.
Public interface EditBoxes Reserved for internal use.
Public interface Error Represents a spreadsheet error for a range.
Public interface ErrorBars Represents the error bars on a chart series.
Public interface ErrorCheckingOptions Represents the error-checking options for an application.
Public interface Errors Represents the various spreadsheet errors for a range.
Public interface FileExportConverter Represents a file converter that is used to save files.
Public interface FileExportConverters A collection of FileExportConverter objects that represent all the file converters available for saving files.
Public interface FillFormat Represents fill formatting for a shape.
Public interface Filter Represents a filter for a single column. The Filter object is a member of the Filters collection. The Filters collection contains all the filters in an autofiltered range.
Public interface Filters A collection of Filter objects that represents all the filters in an autofiltered range.
Public interface Floor Represents the floor of a 3-D chart.
Public interface Font Contains the font attributes (font name, font size, color, and so on) for an object.
Public interface FormatColor Represents the fill color specified for a threshold of a color scale conditional format or the color of the bar in a data bar conditional format.
Public interface FormatCondition Represents a conditional format.
Public interface FormatConditions Represents the collection of conditional formats for a single range.
Public interface FreeformBuilder Represents the geometry of a freeform while it’s being built.
Public interface Global Reserved for internal use.
Public interface Graphic Contains properties that apply to header and footer picture objects.
Public interface Gridlines Represents major or minor gridlines on a chart axis.
Public interface GroupBox Reserved for internal use.
Public interface GroupBoxes Reserved for internal use.
Public interface GroupObject Reserved for internal use.
Public interface GroupObjects Reserved for internal use.
Public interface GroupShapes Represents the individual shapes within a grouped shape.
Public interface HeaderFooter Represents a single header or footer.
Public interface HiLoLines Represents the high-low lines in a chart group.
Public interface HPageBreak Represents a horizontal page break.
Public interface HPageBreaks The collection of horizontal page breaks within the print area. Each horizontal page break is represented by an HPageBreak object.
Public interface Hyperlink Represents a hyperlink.
Public interface Hyperlinks Represents the collection of hyperlinks for a worksheet or range. Each hyperlink is represented by a Hyperlink object.
Public interface IAboveAverage Reserved for internal use.
Public interface IAction Reserved for internal use.
Public interface IActions Reserved for internal use.
Public interface IAddIn Reserved for internal use.
Public interface IAddIns Reserved for internal use.
Public interface IAddIns2 Reserved for internal use.
Public interface IAllowEditRange Reserved for internal use.
Public interface IAllowEditRanges Reserved for internal use.
Public interface IAppEvents Reserved for internal use.
Public interface IArc Reserved for internal use.
Public interface IArcs Reserved for internal use.
Public interface IAreas Reserved for internal use.
Public interface IAutoCorrect Reserved for internal use.
Public interface IAutoFilter Reserved for internal use.
Public interface IAutoRecover Reserved for internal use.
Public interface IAxes Reserved for internal use.
Public interface IAxis Reserved for internal use.
Public interface IAxisTitle Reserved for internal use.
Public interface IBorder Reserved for internal use.
Public interface IBorders Reserved for internal use.
Public interface IButton Reserved for internal use.
Public interface IButtons Reserved for internal use.
Public interface ICalculatedFields Reserved for internal use.
Public interface ICalculatedItems Reserved for internal use.
Public interface ICalculatedMember Reserved for internal use.
Public interface ICalculatedMembers Reserved for internal use.
Public interface ICanvasShapes Reserved for internal use.
Public interface ICellFormat Reserved for internal use.
Public interface ICharacters Reserved for internal use.
Public interface IChartArea Reserved for internal use.
Public interface IChartColorFormat Reserved for internal use.
Public interface IChartEvents Reserved for internal use.
Public interface IChartFillFormat Reserved for internal use.
Public interface IChartFormat Reserved for internal use.
Public interface IChartGroup Reserved for internal use.
Public interface IChartGroups Reserved for internal use.
Public interface IChartObject Reserved for internal use.
Public interface IChartObjects Reserved for internal use.
Public interface ICharts Reserved for internal use.
Public interface IChartTitle Reserved for internal use.
Public interface IChartView Reserved for internal use.
Public interface ICheckBox Reserved for internal use.
Public interface ICheckBoxes Reserved for internal use.
Public interface IColorScale Reserved for internal use.
Public interface IColorScaleCriteria Reserved for internal use.
Public interface IColorScaleCriterion Reserved for internal use.
Public interface IColorStop Reserved for internal use.
Public interface IColorStops Reserved for internal use.
Public interface IComment Reserved for internal use.
Public interface IComments Reserved for internal use.
Public interface Icon Represents a single icon in an icon set used in a conditional formatting rule.
Public interface IconCriteria Represents the collection of IconCriterion objects. Each IconCriterion represents the values and threshold type for each icon in an icon set conditional formatting rule.
Public interface IconCriterion Represents the criterion for an individual icon in an icon set. The criterion specifies the range of values and the threshold type associated with the icon in an icon set conditional formatting rule.
Public interface IConditionValue Reserved for internal use.
Public interface IConnections Reserved for internal use.
Public interface IConnectorFormat Reserved for internal use.
Public interface IconSet Represents a single set of icons that are used in an icon set conditional formatting rule.
Public interface IconSetCondition Represents an icon set conditional formatting rule.
Public interface IconSets Represents a collection of icon sets used in an icon set conditional formatting rule.
Public interface IControlFormat Reserved for internal use.
Public interface ICorners Reserved for internal use.
Public interface ICustomProperties Reserved for internal use.
Public interface ICustomProperty Reserved for internal use.
Public interface ICustomView Reserved for internal use.
Public interface ICustomViews Reserved for internal use.
Public interface IDatabar Reserved for internal use.
Public interface IDataBarBorder
Public interface IDataLabel Reserved for internal use.
Public interface IDataLabels Reserved for internal use.
Public interface IDataTable Reserved for internal use.
Public interface IDiagram Reserved for internal use.
Public interface IDialog Reserved for internal use.
Public interface IDialogFrame Reserved for internal use.
Public interface IDialogs Reserved for internal use.
Public interface IDialogSheet Reserved for internal use.
Public interface IDialogSheets Reserved for internal use.
Public interface IDialogSheetView Reserved for internal use.
Public interface IDisplayFormat
Public interface IDisplayUnitLabel Reserved for internal use.
Public interface IDocEvents Reserved for internal use.
Public interface IDownBars Reserved for internal use.
Public interface IDrawing Reserved for internal use.
Public interface IDrawingObjects Reserved for internal use.
Public interface IDrawings Reserved for internal use.
Public interface IDropDown Reserved for internal use.
Public interface IDropDowns Reserved for internal use.
Public interface IDropLines Reserved for internal use.
Public interface IDummy Reserved for internal use.
Public interface IEditBox Reserved for internal use.
Public interface IEditBoxes Reserved for internal use.
Public interface IError Reserved for internal use.
Public interface IErrorBars Reserved for internal use.
Public interface IErrorCheckingOptions Reserved for internal use.
Public interface IErrors Reserved for internal use.
Public interface IFileExportConverter Reserved for internal use.
Public interface IFileExportConverters Reserved for internal use.
Public interface IFilter Reserved for internal use.
Public interface IFilters Reserved for internal use.
Public interface IFloor Reserved for internal use.
Public interface IFont Reserved for internal use.
Public interface IFormatColor Reserved for internal use.
Public interface IFormatCondition Reserved for internal use.
Public interface IFormatConditions Reserved for internal use.
Public interface IFreeformBuilder Reserved for internal use.
Public interface IGraphic Reserved for internal use.
Public interface IGridlines Reserved for internal use.
Public interface IGroupBox Reserved for internal use.
Public interface IGroupBoxes Reserved for internal use.
Public interface IGroupObject Reserved for internal use.
Public interface IGroupObjects Reserved for internal use.
Public interface IGroupShapes Reserved for internal use.
Public interface IHeaderFooter Reserved for internal use.
Public interface IHiLoLines Reserved for internal use.
Public interface IHPageBreak Reserved for internal use.
Public interface IHPageBreaks Reserved for internal use.
Public interface IHyperlink Reserved for internal use.
Public interface IHyperlinks Reserved for internal use.
Public interface IIcon Reserved for internal use.
Public interface IIconCriteria Reserved for internal use.
Public interface IIconCriterion Reserved for internal use.
Public interface IIconSet Reserved for internal use.
Public interface IIconSetCondition Reserved for internal use.
Public interface IIconSets Reserved for internal use.
Public interface IInterior Reserved for internal use.
Public interface ILabel Reserved for internal use.
Public interface ILabels Reserved for internal use.
Public interface ILeaderLines Reserved for internal use.
Public interface ILegend Reserved for internal use.
Public interface ILegendEntries Reserved for internal use.
Public interface ILegendEntry Reserved for internal use.
Public interface ILegendKey Reserved for internal use.
Public interface ILine Reserved for internal use.
Public interface ILinearGradient Reserved for internal use.
Public interface ILines Reserved for internal use.
Public interface ILinkFormat Reserved for internal use.
Public interface IListBox Reserved for internal use.
Public interface IListBoxes Reserved for internal use.
Public interface IListColumn Reserved for internal use.
Public interface IListColumns Reserved for internal use.
Public interface IListDataFormat Reserved for internal use.
Public interface IListObject Reserved for internal use.
Public interface IListObjects Reserved for internal use.
Public interface IListRow Reserved for internal use.
Public interface IListRows Reserved for internal use.
Public interface IMailer Reserved for internal use.
Public interface IMenu Reserved for internal use.
Public interface IMenuBar Reserved for internal use.
Public interface IMenuBars Reserved for internal use.
Public interface IMenuItem Reserved for internal use.
Public interface IMenuItems Reserved for internal use.
Public interface IMenus Reserved for internal use.
Public interface IModule Reserved for internal use.
Public interface IModules Reserved for internal use.
Public interface IModuleView Reserved for internal use.
Public interface IMultiThreadedCalculation Reserved for internal use.
Public interface IName Reserved for internal use.
Public interface INames Reserved for internal use.
Public interface INegativeBarFormat Reserved for internal use.
Public interface Interior Represents the interior of an object.
Public interface IODBCConnection Reserved for internal use.
Public interface IODBCError Reserved for internal use.
Public interface IODBCErrors Reserved for internal use.
Public interface IOLEDBConnection Reserved for internal use.
Public interface IOLEDBError Reserved for internal use.
Public interface IOLEDBErrors Reserved for internal use.
Public interface IOLEFormat Reserved for internal use.
Public interface IOLEObjectEvents Reserved for internal use.
Public interface IOLEObjects Reserved for internal use.
Public interface IOptionButton Reserved for internal use.
Public interface IOptionButtons Reserved for internal use.
Public interface IOutline Reserved for internal use.
Public interface IOval Reserved for internal use.
Public interface IOvals Reserved for internal use.
Public interface IPage Reserved for internal use.
Public interface IPages Reserved for internal use.
Public interface IPageSetup Reserved for internal use.
Public interface IPane Reserved for internal use.
Public interface IPanes Reserved for internal use.
Public interface IParameter Reserved for internal use.
Public interface IParameters Reserved for internal use.
Public interface IPhonetic Reserved for internal use.
Public interface IPhonetics Reserved for internal use.
Public interface IPicture Reserved for internal use.
Public interface IPictures Reserved for internal use.
Public interface IPivotAxis Reserved for internal use.
Public interface IPivotCache Reserved for internal use.
Public interface IPivotCaches Reserved for internal use.
Public interface IPivotCell Reserved for internal use.
Public interface IPivotField Reserved for internal use.
Public interface IPivotFields Reserved for internal use.
Public interface IPivotFilter Reserved for internal use.
Public interface IPivotFilters Reserved for internal use.
Public interface IPivotFormula Reserved for internal use.
Public interface IPivotFormulas Reserved for internal use.
Public interface IPivotItem Reserved for internal use.
Public interface IPivotItemList Reserved for internal use.
Public interface IPivotItems Reserved for internal use.
Public interface IPivotLayout Reserved for internal use.
Public interface IPivotLine Reserved for internal use.
Public interface IPivotLineCells Reserved for internal use.
Public interface IPivotLines Reserved for internal use.
Public interface IPivotTable Reserved for internal use.
Public interface IPivotTableChangeList
Public interface IPivotTables Reserved for internal use.
Public interface IPlotArea Reserved for internal use.
Public interface IPoint Reserved for internal use.
Public interface IPoints Reserved for internal use.
Public interface IProtectedViewWindow Reserved for internal use.
Public interface IProtectedViewWindows Reserved for internal use.
Public interface IProtection Reserved for internal use.
Public interface IPublishObjects Reserved for internal use.
Public interface IQueryTables Reserved for internal use.
Public interface IRange Reserved for internal use.
Public interface IRanges Reserved for internal use.
Public interface IRecentFile Reserved for internal use.
Public interface IRecentFiles Reserved for internal use.
Public interface IRectangle Reserved for internal use.
Public interface IRectangles Reserved for internal use.
Public interface IRectangularGradient Reserved for internal use.
Public interface IRefreshEvents Reserved for internal use.
Public interface IResearch Reserved for internal use.
Public interface IRoutingSlip Reserved for internal use.
Public interface IRTD Reserved for internal use.
Public interface IRtdServer Represents an interface for a real-time data server.
Public interface IRTDUpdateEvent Represents real-time data update events.
Public interface IScenario Reserved for internal use.
Public interface IScenarios Reserved for internal use.
Public interface IScrollBar Reserved for internal use.
Public interface IScrollBars Reserved for internal use.
Public interface ISeries Reserved for internal use.
Public interface ISeriesCollection Reserved for internal use.
Public interface ISeriesLines Reserved for internal use.
Public interface IServerViewableItems Reserved for internal use.
Public interface IShape Reserved for internal use.
Public interface IShapeRange Reserved for internal use.
Public interface IShapes Reserved for internal use.
Public interface ISheetViews Reserved for internal use.
Public interface ISlicer Reserved for internal use.
Public interface ISlicerCache Reserved for internal use.
Public interface ISlicerCacheLevel Reserved for internal use.
Public interface ISlicerCacheLevels Reserved for internal use.
Public interface ISlicerCaches Reserved for internal use.
Public interface ISlicerItem Reserved for internal use.
Public interface ISlicerItems Reserved for internal use.
Public interface ISlicerPivotTables Reserved for internal use.
Public interface ISlicers Reserved for internal use.
Public interface ISmartTag Reserved for internal use.
Public interface ISmartTagAction Reserved for internal use.
Public interface ISmartTagActions Reserved for internal use.
Public interface ISmartTagOptions Reserved for internal use.
Public interface ISmartTagRecognizer Reserved for internal use.
Public interface ISmartTagRecognizers Reserved for internal use.
Public interface ISmartTags Reserved for internal use.
Public interface ISort Reserved for internal use.
Public interface ISortField Reserved for internal use.
Public interface ISortFields Reserved for internal use.
Public interface ISoundNote Reserved for internal use.
Public interface ISparkAxes Reserved for internal use.
Public interface ISparkColor Reserved for internal use.
Public interface ISparkHorizontalAxis Reserved for internal use.
Public interface ISparkline Reserved for internal use.
Public interface ISparklineGroup Reserved for internal use.
Public interface ISparklineGroups Reserved for internal use.
Public interface ISparkPoints Reserved for internal use.
Public interface ISparkVerticalAxis Reserved for internal use.
Public interface ISpeech Reserved for internal use.
Public interface ISpellingOptions Reserved for internal use.
Public interface ISpinner Reserved for internal use.
Public interface ISpinners Reserved for internal use.
Public interface IStyle Reserved for internal use.
Public interface IStyles Reserved for internal use.
Public interface ITab Reserved for internal use.
Public interface ITableStyle Reserved for internal use.
Public interface ITableStyleElement Reserved for internal use.
Public interface ITableStyleElements Reserved for internal use.
Public interface ITableStyles Reserved for internal use.
Public interface ITextBox Reserved for internal use.
Public interface ITextBoxes Reserved for internal use.
Public interface ITextFrame Reserved for internal use.
Public interface ITickLabels Reserved for internal use.
Public interface IToolbar Reserved for internal use.
Public interface IToolbarButton Reserved for internal use.
Public interface IToolbarButtons Reserved for internal use.
Public interface IToolbars Reserved for internal use.
Public interface ITop10 Reserved for internal use.
Public interface ITrendline Reserved for internal use.
Public interface ITrendlines Reserved for internal use.
Public interface IUniqueValues Reserved for internal use.
Public interface IUpBars Reserved for internal use.
Public interface IUsedObjects Reserved for internal use.
Public interface IUserAccess Reserved for internal use.
Public interface IUserAccessList Reserved for internal use.
Public interface IValidation Reserved for internal use.
Public interface IValueChange Reserved for internal use.
Public interface IVPageBreak Reserved for internal use.
Public interface IVPageBreaks Reserved for internal use.
Public interface IWalls Reserved for internal use.
Public interface IWatch Reserved for internal use.
Public interface IWatches Reserved for internal use.
Public interface IWindow Reserved for internal use.
Public interface IWindows Reserved for internal use.
Public interface IWorkbookConnection Reserved for internal use.
Public interface IWorkbookEvents Reserved for internal use.
Public interface IWorksheetFunction Reserved for internal use.
Public interface IWorksheets Reserved for internal use.
Public interface IWorksheetView Reserved for internal use.
Public interface IXmlDataBinding Reserved for internal use.
Public interface IXmlMap Reserved for internal use.
Public interface IXmlMaps Reserved for internal use.
Public interface IXmlNamespace Reserved for internal use.
Public interface IXmlNamespaces Reserved for internal use.
Public interface IXmlSchema Reserved for internal use.
Public interface IXmlSchemas Reserved for internal use.
Public interface IXPath Reserved for internal use.
Public interface Label Reserved for internal use.
Public interface Labels Reserved for internal use.
Public interface LeaderLines Represents leader lines on a chart.
Public interface Legend Represents the legend in a chart.
Public interface LegendEntries A collection of all the LegendEntry objects in the specified chart legend.
Public interface LegendEntry Represents a legend entry in a chart legend.
Public interface LegendKey Represents a legend key in a chart legend.
Public interface Line Reserved for internal use.
Public interface LinearGradient The LinearGradient object transitions through a series of colors in a linear manner along a specific angle.
Public interface LineFormat Represents line and arrowhead formatting.
Public interface Lines Reserved for internal use.
Public interface LinkFormat Contains linked OLE object properties.
Public interface ListBox Reserved for internal use.
Public interface ListBoxes Reserved for internal use.
Public interface ListColumn Represents a column in a list. The ListColumn object is a member of the ListColumns collection. The ListColumns collection contains all the columns in a list (ListObject object).
Public interface ListColumns A collection of all the ListColumn objects in the specified ListObject object. Each ListColumn object represents a column in the list.
Public interface ListDataFormat The ListDataFormat object holds all the data type properties of the ListColumn object. These properties are read-only.
Public interface ListObject Represents a list object on a worksheet.
Public interface ListObjects A collection of all the ListObject objects on a worksheet. Each ListObject object represents a list in the worksheet.
Public interface ListRow Represents a row in a List object. The ListRow object is a member of the ListRows collection. The ListRows collection contains all the rows in a list object.
Public interface ListRows A collection of all the ListRow objects in the specified ListObject object. Each ListRow object represents a row in the list.
Public interface Mailer You have requested Help for a Visual Basic keyword used only on the Macintosh. For information about this keyword, consult the language reference Help included with Microsoft Office Macintosh Edition.
Public interface Menu Reserved for internal use.
Public interface MenuBar Reserved for internal use.
Public interface MenuBars Reserved for internal use.
Public interface MenuItem Reserved for internal use.
Public interface MenuItems Reserved for internal use.
Public interface Menus Reserved for internal use.
Public interface Module Reserved for internal use.
Public interface Modules Reserved for internal use.
Public interface ModuleView Represents existing Moduleviews in the workbook.
Public interface MultiThreadedCalculation Returns or sets the concurrent calculation mode.
Public interface Name Represents a defined name for a range of cells.
Public interface Names A collection of all the Name objects in the application or workbook. Each Name object represents a defined name for a range of cells. Names can be either built-in names — such as Database, Print_Area, and Auto_Open — or custom names.
Public interface NegativeBarFormat Represents the color settings of the data bars for negative values that are defined by a data bar conditional formating rule.
Public interface ODBCConnection Represents the ODBC connection.
Public interface ODBCError Represents an ODBC error generated by the most recent ODBC query.
Public interface ODBCErrors A collection of ODBCError objects.
Public interface OLEDBConnection Represents the OLE DB connection.
Public interface OLEDBError Represents an OLE DB error returned by the most recent OLE DB query.
Public interface OLEDBErrors A collection of OLEDBError objects.
Public interface OLEFormat Contains OLE object properties.
Public interface OLEObject Represents an ActiveX control or a linked or embedded OLE object on a worksheet. The OLEObject object is a member of the OLEObjects collection. The OLEObjects collection contains all the OLE objects on a single worksheet.
Public interface OLEObjectEvents Reserved for internal use.
Public interface OLEObjectEvents_Event Events interface for Microsoft Excel OLEObject object events.
Public interface OLEObjects A collection of all the OLEObject objects on the specified worksheet. Each OLEObject object represents an ActiveX control or a linked or embedded OLE object.
Public interface OptionButton Reserved for internal use.
Public interface OptionButtons Reserved for internal use.
Public interface Outline Represents an outline on a worksheet.
Public interface Oval Reserved for internal use.
Public interface Ovals Reserved for internal use.
Public interface Page Represents a page in a workbook. Use the PageSetup object and the related methods and properties for programmatically defining page layout in a workbook.
Public interface Pages A collection of pages in a document. Use the Pages collection and the related objects and properties for programmatically defining page layout in a workbook.
Public interface PageSetup Represents the page setup description. The PageSetup object contains all page setup attributes (left margin, bottom margin, paper size, and so on) as properties.
Public interface Pane Represents a pane of a window.
Public interface Panes A collection of all the Pane objects shown in the specified window.
Public interface Parameter Represents a single parameter used in a parameter query. The Parameter object is a member of the Parameters collection.
Public interface Parameters A collection of Parameter objects for the specified query table. Each Parameter object represents a single query parameter. Every query table contains a Parameters collection, but the collection is empty unless the query table is using a parameter query.
Public interface Phonetic Contains information about a specific phonetic text string in a cell.
Public interface Phonetics A collection of all the Phonetic objects in the specified range. Each Phonetic object contains information about a specific phonetic text string.
Public interface Picture Reserved for internal use.
Public interface PictureFormat Contains properties and methods that apply to pictures and OLE objects.
Public interface Pictures Reserved for internal use.
Public interface PivotAxis
Public interface PivotCache Represents the memory cache for a PivotTable report.
Public interface PivotCaches Represents the collection of memory caches from the PivotTable reports in a workbook.
Public interface PivotCell Represents a cell in a PivotTable report.
Public interface PivotField Represents a field in a PivotTable report. The PivotField object is a member of the PivotFields collection. The PivotFields collection contains all the fields in a PivotTable report, including hidden fields.
Public interface PivotFields A collection of all the PivotField objects in a PivotTable report.
Public interface PivotFilter A PivotFilter is applied to a PivotField object.
Public interface PivotFilters The PivotFilters object is a collection of PivotFilter objects.
Public interface PivotFormula Represents a formula used to calculate results in a PivotTable report.
Public interface PivotFormulas Represents the collection of formulas for a PivotTable report. Each formula is represented by a PivotFormula object.
Public interface PivotItem Represents an item in a PivotTable field. The items are the individual data entries in a field category. The PivotItem object is a member of the PivotItems collection. The PivotItems collection contains all the items in a PivotField object.
Public interface PivotItemList A collection of all the PivotItem objects in the specified PivotTable. Each PivotItem represents an item in a PivotTable field.
Public interface PivotItems A collection of all the PivotItem objects in a PivotTable field. The items are the individual data entries in a field category.
Public interface PivotLayout Represents the placement of fields in a PivotChart report.
Public interface PivotLine A PivotLine object is a line of rows or columns in an Excel PivotTable.
Public interface PivotLineCells Collection of PivotCell objects for a specific PivotLine.
Public interface PivotLines The PivotLines object is a collection of lines in a PivotTable, containing all lines on rows or columns of the pivot. Each line is a set of PivotCells.
Public interface PivotTable Represents a PivotTable report on a worksheet. The PivotTable object is a member of the PivotTables collection. The PivotTables collection contains all the PivotTable objects on a single worksheet.
Public interface PivotTableChangeList Represents the list of changes a user has made to value cells in a PivotTable report based on an OLAP data source.
Public interface PivotTables A collection of all the PivotTable objects on the specified worksheet.
Public interface PlotArea Represents the plot area of a chart. This is the area where your chart data is plotted.
Public interface Point Represents a single point in a series in a chart.
Public interface Points A collection of all the Point objects in the specified series in a chart.
Public interface ProtectedViewWindow Represents a Protected View window.
Public interface ProtectedViewWindows A collection of the ProtectedViewWindow objects that represent all the Protected View windows that are currently open in the application.
Public interface Protection Represents the various types of protection options available for a worksheet.
Public interface PublishObject Represents an item in a workbook that has been saved to a Web page and can be refreshed according to values specified by the properties and methods of the PublishObject object.
Public interface PublishObjects A collection of all PublishObject objects in the workbook. Each PublishObject object represents an item in a workbook that has been saved to a Web page and can be refreshed according to values specified by the properties and methods of the object.
Public interface QueryTable Represents a worksheet table built from data returned from an external data source, such as a SQL server or a Microsoft Access database. The QueryTable object is a member of the QueryTables collection.
Public interface QueryTables A collection of QueryTable objects. Each QueryTable object represents a worksheet table built from data returned from an external data source.
Public interface Range Represents a cell, a row, a column, a selection of cells containing one or more contiguous blocks of cells, or a 3-D range.
Public interface Ranges A collection of Range objects.
Public interface RecentFile Represents a file in the list of recently used files.
Public interface RecentFiles Represents the list of recently used files. Each file is represented by a RecentFile object.
Public interface Rectangle Reserved for internal use.
Public interface Rectangles Reserved for internal use.
Public interface RectangularGradient The RectangularGradient object transitions through a series of colors in a linear manner along a specific angle.
Public interface RefreshEvents Reserved for internal use.
Public interface RefreshEvents_Event Events interface for Microsoft Excel QueryTable object events.
Public interface Research Represents the controls of a Research query.
Public interface RoutingSlip Represents the routing slip for a workbook. The routing slip is used to send a workbook through the electronic mail system.
Public interface RTD Represents a real-time data object.
Public interface Scenario Represents a scenario on a worksheet. A scenario is a group of input values (called changing cells) that’s named and saved.
Public interface Scenarios A collection of all the Scenario objects on the specified worksheet. A scenario is a group of input values (called changing cells) that’s named and saved.
Public interface ScrollBar Reserved for internal use.
Public interface ScrollBars Reserved for internal use.
Public interface Series Represents a series in a chart. The Series object is a member of the SeriesCollection collection.
Public interface SeriesCollection A collection of all the Series objects in the specified chart or chart group.
Public interface SeriesLines Represents series lines in a chart group. Series lines connect the data values from each series.
Public interface ServerViewableItems A collection of objects that have been marked as viewable on the server.
Public interface ShadowFormat Represents shadow formatting for a Shape.
Public interface Shape Represents an object in the drawing layer, such as an AutoShape, freeform, OLE object, or picture. The Shape object is a member of the Shapes collection. The Shapes collection contains all the shapes on a slide.
Public interface ShapeNode Represents the geometry and the geometry-editing properties of the nodes in a user-defined freeform.
Public interface ShapeNodes A collection of all the ShapeNode objects in the specified freeform.
Public interface ShapeRange Represents a shape range, which is a set of shapes on a document.
Public interface Shapes A collection of all the Shape objects on the specified sheet.
Public interface Sheets A collection of all the sheets in the specified or active workbook.
Public interface SheetViews A collection of all the sheet views in the specified or active workbook window.
Public interface Slicer Represents a slicer in a workbook.
Public interface SlicerCache Represents the current filter state for a slicer and information about which PivotCache or WorkbookConnection the slicer is connected to.
Public interface SlicerCacheLevel Represents a level of a hierarchy in an OLAP data source being filtered by a slicer.
Public interface SlicerCacheLevels Represents the collection of hierarchy levels for the OLAP data source that is filtered by a slicer.
Public interface SlicerCaches Represents the collection of slicer caches associated with the specified workbook.
Public interface SlicerItem Represents an item in a slicer.
Public interface SlicerItems Represents the collection of SlicerItem objects contained in a SlicerCache or SlicerCacheLevel object.
Public interface SlicerPivotTables Represents information about the collection of PivotTables associated with the specified SlicerCache object.
Public interface Slicers A collection of Slicer objects.
Public interface SmartTag Represents an identifier that is assigned to a cell.
Public interface SmartTagAction Represents the actions that can be performed with smart tags.
Public interface SmartTagActions A collection of SmartTagAction objects that represent the actions that can be performed with smart tags.
Public interface SmartTagOptions Represents the options that can be performed with smart tags.
Public interface SmartTagRecognizer Represents recognition engines which label data with types of information as you work in Microsoft Excel.
Public interface SmartTagRecognizers A collection of SmartTagRecognizer objects that represent recognition engines that label data with types of information as you work in Microsoft Excel.
Public interface SmartTags A collection of SmartTag objects that represent the identifiers assigned to each cell.
Public interface Sort Represents a sort of a range of data.
Public interface SortField The SortField object contains all the sort information for the Worksheet, ListObject, and AutoFilter objects.
Public interface SortFields The SortFields collection is a collection of SortField objects. It allows developers to store a sort state on workbooks, lists, and autofilters.
Public interface SoundNote This object should not be used. Sound notes have been removed from Microsoft Excel.
Public interface SparkAxes Represents the settings for the horizontal and vertical axes of a group of sparklines.
Public interface SparkColor Represents the color of the markers for points in a sparkline.
Public interface SparkHorizontalAxis Represents the settings for the horizontal axes of a group of sparklines.
Public interface Sparkline Represents a single sparkline.
Public interface SparklineGroup Represents a group of sparklines.
Public interface SparklineGroups Represents a collection of sparkline groups.
Public interface SparkPoints Represents the settings of the markers for points of data on a sparkline.
Public interface SparkVerticalAxis Represents the settings for the vertical axes of a group of sparklines.
Public interface Speech Contains methods and properties that pertain to speech.
Public interface SpellingOptions Represents the various spell-checking options for a worksheet.
Public interface Spinner Reserved for internal use.
Public interface Spinners Reserved for internal use.
Public interface Style Represents a style description for a range.
Public interface Styles A collection of all the Style objects in the specified or active workbook.
Public interface Tab Represents a tab in a chart or a worksheet.
Public interface TableStyle Represents a single style that can be applied to a table.
Public interface TableStyleElement Represents a single table style element.
Public interface TableStyleElements Represents table style elements.
Public interface TableStyles Represents styles that can be applied to a table.
Public interface TextBox Reserved for internal use.
Public interface TextBoxes Reserved for internal use.
Public interface TextEffectFormat Contains properties and methods that apply to WordArt objects.
Public interface TextFrame Represents the text frame in a Shape object. Contains the text in the text frame as well as the properties and methods that control the alignment and anchoring of the text frame.
Public interface TextFrame2 Represents the text frame in a Shape, ShapeRange, or ChartFormat object.
Public interface ThreeDFormat Represents a shape's three-dimensional formatting.
Public interface TickLabels Represents the tick mark labels associated with tick marks on a chart axis.
Public interface Toolbar Reserved for internal use.
Public interface ToolbarButton Reserved for internal use.
Public interface ToolbarButtons Reserved for internal use.
Public interface Toolbars Reserved for internal use.
Public interface Top10 Represents a top ten visual of a conditional formatting rule. Applying a color to a range helps you see the value of a cell relative to other cells.
Public interface TreeviewControl Represents the hierarchical member-selection control of a cube field. You use this object primarily for macro recording; it is not intended for any other use.
Public interface Trendline Represents a trendline in a chart. A trendline shows the trend, or direction, of data in a series.
Public interface Trendlines A collection of all the Trendline objects for the specified series. Each Trendline object represents a trendline in a chart. A trendline shows the trend, or direction, of data in a series.
Public interface UniqueValues The UniqueValues object uses the DupeUnique property to returns or sets an enum that determines whether the rule should look for duplicate or unique values in the range.
Public interface UpBars Represents the up bars in a chart group. Up bars connect points on series one with higher values on the last series in the chart group (the lines go up from series one).
Public interface UsedObjects Represents objects that have been allocated in a workbook.
Public interface UserAccess Represents the user access for a protected range.
Public interface UserAccessList A collection of UserAccess objects that represent the user access for protected ranges.
Public interface Validation Represents data validation for a worksheet range.
Public interface ValueChange Represents a value that has been changed in a PivotTable report that is based on an OLAP data source.
Public interface VPageBreak Represents a vertical page break.
Public interface VPageBreaks A collection of vertical page breaks within the print area. Each vertical page break is represented by a VPageBreak object.
Public interface Walls Represents the walls of a 3-D chart.
Public interface Watch Represents a range which is tracked when the worksheet is recalculated.
Public interface Watches A collection of all the Watch objects in a specified application.
Public interface WebOptions Contains workbook-level attributes used by Microsoft Excel when you save a document as a Web page or open a Web page.
Public interface Window Represents a window. Many worksheet characteristics, such as scroll bars and gridlines, are actually properties of the window.
Public interface Windows A collection of all the Window objects in Microsoft Excel.
Public interface Workbook Represents a Microsoft Excel workbook.
Public interface WorkbookConnection A connection is a set of information needed to obtain data from an external data source other than an 1st_Excel12 workbook.
Public interface WorkbookEvents Reserved for internal use.
Public interface WorkbookEvents_Event Events interface for Microsoft Excel Workbook object events.
Public interface Workbooks A collection of all the Workbook objects that are currently open in the Microsoft Excel application.
Public interface Worksheet Represents a worksheet.
Public interface WorksheetFunction Used as a container for Microsoft Excel worksheet functions that can be called from Visual Basic.
Public interface Worksheets A collection of all the Worksheet objects in the specified or active workbook. Each Worksheet object represents a worksheet.
Public interface WorksheetView A collection of all the WorksheetView objects in the specified or active workbook.
Public interface XmlDataBinding Represents the connection to the source data for an XmlMap object.
Public interface XmlMap Represents an XML map that has been added to a workbook.
Public interface XmlMaps Represents the collection of XmlMap objects that have been added to a workbook.
Public interface XmlNamespace Represents a namespace that has been added to a workbook.
Public interface XmlNamespaces Represents the collection of XmlNamespace objects in a workbook.
Public interface XmlSchema Represents an XML schema contained by an XmlMap object.
Public interface XmlSchemas Represents the collection of XmlSchema objects contained by an XmlMap object.
Public interface XPath Represents an XPath that has been mapped to a Range or ListColumn object.

Delegates

  Delegate Description
Public delegate AppEvents_AfterCalculateEventHandler A Delegate type used to add an event handler for the AfterCalculate event. The AfterCalculate event occurs when all pending refresh activity (both synchronous and asynchronous) and all of the resultant calculation activities have been completed.
Public delegate AppEvents_NewWorkbookEventHandler A Delegate type used to add an event handler for the NewWorkbook event. The NewWorkbook event occurs when a new workbook is created.
Public delegate AppEvents_ProtectedViewWindowActivateEventHandler A Delegate type used to add an event handler for the ProtectedViewWindowActivate event. The ProtectedViewWindowActivate event occurs when a Protected View window is activated.
Public delegate AppEvents_ProtectedViewWindowBeforeCloseEventHandler A Delegate type used to add an event handler for the ProtectedViewWindowBeforeClose event. The ProtectedViewWindowBeforeClose event occurs immediately before a Protected View window or a workbook in a Protected View window closes.
Public delegate AppEvents_ProtectedViewWindowBeforeEditEventHandler A Delegate type used to add an event handler for the ProtectedViewWindowBeforeEdit event. The ProtectedViewWindowBeforeEdit event occurs immediately before editing is enabled on the workbook in the specified Protected View window.
Public delegate AppEvents_ProtectedViewWindowDeactivateEventHandler A Delegate type used to add an event handler for the ProtectedViewWindowDeactivate event. The ProtectedViewWindowDeactivate event occurs when a Protected View window is deactivated.
Public delegate AppEvents_ProtectedViewWindowOpenEventHandler A Delegate type used to add an event handler for the ProtectedViewWindowOpen event. The ProtectedViewWindowOpen event occurs when a workbook is opened in a Protected View window.
Public delegate AppEvents_ProtectedViewWindowResizeEventHandler A Delegate type used to add an event handler for the ProtectedViewWindowResize event. The ProtectedViewWindowResize event occurs when any Protected View window is resized.
Public delegate AppEvents_SheetActivateEventHandler A Delegate type used to add an event handler for the SheetActivate event. The SheetActivate event occurs when any sheet is activated.
Public delegate AppEvents_SheetBeforeDoubleClickEventHandler A Delegate type used to add an event handler for the SheetBeforeDoubleClick event. The SheetBeforeDoubleClick event occurs when any worksheet is double-clicked, before the default double-click action.
Public delegate AppEvents_SheetBeforeRightClickEventHandler A Delegate type used to add an event handler for the SheetBeforeRightClick event. The SheetBeforeRightClick event occurs when any worksheet is right-clicked, before the default right-click action.
Public delegate AppEvents_SheetCalculateEventHandler A Delegate type used to add an event handler for the SheetCalculate event. The SheetCalculate event occurs after any worksheet is recalculated or after any changed data is plotted on a chart.
Public delegate AppEvents_SheetChangeEventHandler A Delegate type used to add an event handler for the SheetChange event. The SheetChange event occurs when cells in any worksheet are changed by the user or by an external link.
Public delegate AppEvents_SheetDeactivateEventHandler A Delegate type used to add an event handler for the SheetDeactivate event. The SheetDeactivate event occurs when any sheet is deactivated.
Public delegate AppEvents_SheetFollowHyperlinkEventHandler A Delegate type used to add an event handler for the SheetFollowHyperlink event. The SheetFollowHyperlink event occurs when you click any hyperlink in Microsoft Excel.
Public delegate AppEvents_SheetPivotTableAfterValueChangeEventHandler A Delegate type used to add an event handler for the SheetPivotTableAfterValueChange event. The SheetPivotTableAfterValueChange event occurs after a cell or range of cells inside a PivotTable are edited or recalculated (for cells that contain formulas).
Public delegate AppEvents_SheetPivotTableBeforeAllocateChangesEventHandler A Delegate type used to add an event handler for the SheetPivotTableBeforeAllocateChanges event. The SheetPivotTableBeforeAllocateChanges event occurs before changes are applied to a PivotTable.
Public delegate AppEvents_SheetPivotTableBeforeCommitChangesEventHandler A Delegate type used to add an event handler for the SheetPivotTableBeforeCommitChanges event. The SheetPivotTableBeforeCommitChanges event occurs before changes are committed against the OLAP data source for a PivotTable.
Public delegate AppEvents_SheetPivotTableBeforeDiscardChangesEventHandler A Delegate type used to add an event handler for the SheetPivotTableBeforeDiscardChanges event. The SheetPivotTableBeforeDiscardChanges event occurs before changes to a PivotTable are discarded.
Public delegate AppEvents_SheetPivotTableUpdateEventHandler A Delegate type used to add an event handler for the SheetPivotTableUpdate event. The SheetPivotTableUpdate event occurs after the sheet of the PivotTable report has been updated.
Public delegate AppEvents_SheetSelectionChangeEventHandler A Delegate type used to add an event handler for the SheetSelectionChange event. The SheetSelectionChange event occurs when the selection changes on any worksheet.
Public delegate AppEvents_WindowActivateEventHandler A Delegate type used to add an event handler for the WindowActivate event. The WindowActivate event occurs when any workbook window is activated.
Public delegate AppEvents_WindowDeactivateEventHandler A Delegate type used to add an event handler for the WindowDeactivate event. The WindowDeactivate event occurs when any workbook window is deactivated.
Public delegate AppEvents_WindowResizeEventHandler A Delegate type used to add an event handler for the WindowResize event. The WindowResize event occurs when any workbook window is resized.
Public delegate AppEvents_WorkbookActivateEventHandler A Delegate type used to add an event handler for the WorkbookActivate event. The WorkbookActivate event occurs when any workbook is activated.
Public delegate AppEvents_WorkbookAddinInstallEventHandler A Delegate type used to add an event handler for the WorkbookAddinInstall event. The WorkbookAddinInstall event occurs when a workbook is installed as an add-in.
Public delegate AppEvents_WorkbookAddinUninstallEventHandler A Delegate type used to add an event handler for the WorkbookAddinUninstall event. The WorkbookAddinUninstall event occurs when any add-in workbook is uninstalled.
Public delegate AppEvents_WorkbookAfterSaveEventHandler A Delegate type used to add an event handler for the WorkbookAfterSave event. The WorkbookAfterSave event occurs after the workbook is saved.
Public delegate AppEvents_WorkbookAfterXmlExportEventHandler A Delegate type used to add an event handler for the WorkbookAfterXmlExport event. The WorkbookAfterXmlExport event occurs after Microsoft Excel saves or exports data from any open workbook to an XML data file.
Public delegate AppEvents_WorkbookAfterXmlImportEventHandler A Delegate type used to add an event handler for the WorkbookAfterXmlImport event. The WorkbookAfterXmlImport event occurs after an existing XML data connection is refreshed, or new XML data is imported into any open Microsoft Excel workbook.
Public delegate AppEvents_WorkbookBeforeCloseEventHandler A Delegate type used to add an event handler for the WorkbookBeforeClose event. The WorkbookBeforeClose event occurs immediately before any open workbook closes.
Public delegate AppEvents_WorkbookBeforePrintEventHandler A Delegate type used to add an event handler for the WorkbookBeforePrint event. The WorkbookBeforePrint event occurs before any open workbook is printed.
Public delegate AppEvents_WorkbookBeforeSaveEventHandler A Delegate type used to add an event handler for the WorkbookBeforeSave event. The WorkbookBeforeSave event occurs before any open workbook is saved.
Public delegate AppEvents_WorkbookBeforeXmlExportEventHandler A Delegate type used to add an event handler for the WorkbookBeforeXmlExport event. The WorkbookBeforeXmlExport event occurs before Microsoft Excel saves or exports data from any open workbook to an XML data file.
Public delegate AppEvents_WorkbookBeforeXmlImportEventHandler A Delegate type used to add an event handler for the WorkbookBeforeXmlImport event. The WorkbookBeforeXmlImport event occurs before an existing XML data connection is refreshed, or new XML data is imported into any open Microsoft Excel workbook.
Public delegate AppEvents_WorkbookDeactivateEventHandler A Delegate type used to add an event handler for the WorkbookDeactivate event. The WorkbookDeactivate event occurs when any open workbook is deactivated.
Public delegate AppEvents_WorkbookNewChartEventHandler A Delegate type used to add an event handler for the WorkbookNewChart event. The WorkbookNewChart event occurs when a new chart is created in any open workbook.
Public delegate AppEvents_WorkbookNewSheetEventHandler A Delegate type used to add an event handler for the WorkbookNewSheet event. The WorkbookNewSheet event occurs when a new sheet is created in any open workbook.
Public delegate AppEvents_WorkbookOpenEventHandler A Delegate type used to add an event handler for the WorkbookOpen event. The WorkbookOpen event occurs when a workbook is opened.
Public delegate AppEvents_WorkbookPivotTableCloseConnectionEventHandler A Delegate type used to add an event handler for the WorkbookPivotTableCloseConnection event. The WorkbookPivotTableCloseConnection event occurs after a PivotTable report connection has been closed.
Public delegate AppEvents_WorkbookPivotTableOpenConnectionEventHandler A Delegate type used to add an event handler for the WorkbookPivotTableOpenConnection event. The WorkbookPivotTableOpenConnection event occurs after a PivotTable report connection has been opened.
Public delegate AppEvents_WorkbookRowsetCompleteEventHandler A Delegate type used to add an event handler for the WorkbookRowsetComplete event. The WorkbookRowsetComplete event occurs when the user either drills through the recordset or invokes the rowset action on an OLAP PivotTable.
Public delegate AppEvents_WorkbookSyncEventHandler A Delegate type used to add an event handler for the WorkbookSync event. The WorkbookSync event occurs when the local copy of a workbook that is part of a Document Workspace is synchronized with the copy on the server.
Public delegate ChartEvents_ActivateEventHandler A Delegate type used to add an event handler for the Activate event. The Activate event occurs when a chart sheet or embedded chart is activated.
Public delegate ChartEvents_BeforeDoubleClickEventHandler A Delegate type used to add an event handler for the BeforeDoubleClick event. The BeforeDoubleClick event occurs when an embedded chart is double-clicked, before the default double-click action.
Public delegate ChartEvents_BeforeRightClickEventHandler A Delegate type used to add an event handler for the BeforeRightClick event. The BeforeRightClick event occurs when an embedded chart is right-clicked, before the default right-click action.
Public delegate ChartEvents_CalculateEventHandler A Delegate type used to add an event handler for the Calculate event. The Calculate event occurs after the chart plots new or changed data.
Public delegate ChartEvents_DeactivateEventHandler A Delegate type used to add an event handler for the Deactivate event. The Deactivate event occurs when the chart is deactivated.
Public delegate ChartEvents_DragOverEventHandler A Delegate type used to add an event handler for the DragOver event. The DragOver event occurs when a range of cells is dragged over a chart.
Public delegate ChartEvents_DragPlotEventHandler A Delegate type used to add an event handler for the DragPlot event. The DragPlot event occurs when a range of cells is dragged and dropped on a chart.
Public delegate ChartEvents_MouseDownEventHandler A Delegate type used to add an event handler for the MouseDown event. The MouseDown event occurs when a mouse button is pressed while the pointer is over a chart.
Public delegate ChartEvents_MouseMoveEventHandler A Delegate type used to add an event handler for the MouseMove event. The MouseMove event occurs when the position of the mouse pointer changes over a chart.
Public delegate ChartEvents_MouseUpEventHandler A Delegate type used to add an event handler for the MouseUp event. The MouseUp event occurs when a mouse button is released while the pointer is over a chart.
Public delegate ChartEvents_ResizeEventHandler A Delegate type used to add an event handler for the Resize event. The Resize event occurs when the chart is resized.
Public delegate ChartEvents_SelectEventHandler A Delegate type used to add an event handler for the Select event. The Select event occurs when a chart element is selected.
Public delegate ChartEvents_SeriesChangeEventHandler A Delegate type used to add an event handler for the SeriesChange event. The SeriesChange event occurs when the user changes the value of a chart data point.
Public delegate DocEvents_ActivateEventHandler A Delegate type used to add an event handler for the Activate event. The Activate event occurs when a worksheet is activated.
Public delegate DocEvents_BeforeDoubleClickEventHandler A Delegate type used to add an event handler for the BeforeDoubleClick event. The BeforeDoubleClick event occurs when a worksheet is double-clicked, before the default double-click action.
Public delegate DocEvents_BeforeRightClickEventHandler A Delegate type used to add an event handler for the BeforeRightClick event. The BeforeRightClick event occurs when a worksheet is right-clicked, before the default right-click action.
Public delegate DocEvents_CalculateEventHandler A Delegate type used to add an event handler for the Calculate event. The Calculate event occurs after the worksheet is recalculated.
Public delegate DocEvents_ChangeEventHandler A Delegate type used to add an event handler for the Change event. The Change event occurs when cells on the worksheet are changed by the user or by an external link.
Public delegate DocEvents_DeactivateEventHandler A Delegate type used to add an event handler for the Deactivate event. The Deactivate event occurs when the worksheet is deactivated.
Public delegate DocEvents_FollowHyperlinkEventHandler A Delegate type used to add an event handler for the FollowHyperlink event. The FollowHyperlink event occurs when you click any hyperlink on a worksheet.
Public delegate DocEvents_PivotTableAfterValueChangeEventHandler A Delegate type used to add an event handler for the PivotTableAfterValueChange event. The PivotTableAfterValueChange event occurs after a cell or range of cells inside a PivotTable are edited or recalculated (for cells that contain formulas).
Public delegate DocEvents_PivotTableBeforeAllocateChangesEventHandler A Delegate type used to add an event handler for the PivotTableBeforeAllocateChanges event. The PivotTableBeforeAllocateChanges event occurs before changes are applied to a PivotTable.
Public delegate DocEvents_PivotTableBeforeCommitChangesEventHandler A Delegate type used to add an event handler for the PivotTableBeforeCommitChanges event. The PivotTableBeforeCommitChanges event occurs before changes are committed against the OLAP data source for a PivotTable.
Public delegate DocEvents_PivotTableBeforeDiscardChangesEventHandler A Delegate type used to add an event handler for the PivotTableBeforeDiscardChanges event. The PivotTableBeforeDiscardChanges event occurs before changes to a PivotTable are discarded.
Public delegate DocEvents_PivotTableChangeSyncEventHandler A Delegate type used to add an event handler for the PivotTableChangeSync event. The PivotTableChangeSync event occurs after changes to a PivotTable.
Public delegate DocEvents_PivotTableUpdateEventHandler A Delegate type used to add an event handler for the PivotTableUpdate event. The PivotTableUpdate event occurs after a PivotTable report is updated on a worksheet.
Public delegate DocEvents_SelectionChangeEventHandler A Delegate type used to add an event handler for the SelectionChange event. The SelectionChange event occurs when the selection changes on a worksheet.
Public delegate OLEObjectEvents_GotFocusEventHandler A Delegate type used to add an event handler for the GotFocus event. The GotFocus event occurs when an ActiveX control gets input focus.
Public delegate OLEObjectEvents_LostFocusEventHandler A Delegate type used to add an event handler for the LostFocus event. The LostFocus event occurs when an ActiveX control loses input focus.
Public delegate RefreshEvents_AfterRefreshEventHandler A Delegate type used to add an event handler for the AfterRefresh event. The AfterRefresh event occurs after a query is completed or canceled.
Public delegate RefreshEvents_BeforeRefreshEventHandler A Delegate type used to add an event handler for the BeforeRefresh event. The BeforeRefresh event occurs before any refreshes of the query table.
Public delegate WorkbookEvents_ActivateEventHandler A Delegate type used to add an event handler for the Activate event. The Activate event occurs when a workbook is activated.
Public delegate WorkbookEvents_AddinInstallEventHandler A Delegate type used to add an event handler for the AddinInstall event. The AddinInstall event occurs when the workbook is installed as an add-in.
Public delegate WorkbookEvents_AddinUninstallEventHandler A Delegate type used to add an event handler for the AddinUninstall event. The AddinUninstall event occurs when the workbook is uninstalled as an add-in.
Public delegate WorkbookEvents_AfterSaveEventHandler A Delegate type used to add an event handler for the AfterSave event. The AfterSave event occurs after the workbook is saved.
Public delegate WorkbookEvents_AfterXmlExportEventHandler A Delegate type used to add an event handler for the AfterXmlExport event. The AfterXmlExport event occurs after Microsoft Excel saves or exports data from the specified workbook to an XML data file.
Public delegate WorkbookEvents_AfterXmlImportEventHandler A Delegate type used to add an event handler for the AfterXmlImport event. The AfterXmlImport event occurs after an existing XML data connection is refreshed or after new XML data is imported into the specified Microsoft Excel workbook.
Public delegate WorkbookEvents_BeforeCloseEventHandler A Delegate type used to add an event handler for the BeforeClose event. The BeforeClose event occurs before the workbook closes. If the workbook has been changed, this event occurs before the user is asked to save changes.
Public delegate WorkbookEvents_BeforePrintEventHandler A Delegate type used to add an event handler for the BeforePrint event. The BeforePrint event occurs before the workbook (or anything in it) is printed.
Public delegate WorkbookEvents_BeforeSaveEventHandler A Delegate type used to add an event handler for the BeforeSave event. The BeforeSave event occurs before the workbook is saved.
Public delegate WorkbookEvents_BeforeXmlExportEventHandler A Delegate type used to add an event handler for the BeforeXmlExport event. The BeforeXmlExport event occurs before Microsoft Excel saves or exports data from the specified workbook to an XML data file.
Public delegate WorkbookEvents_BeforeXmlImportEventHandler A Delegate type used to add an event handler for the BeforeXmlImport event. The BeforeXmlImport event occurs before an existing XML data connection is refreshed or before new XML data is imported into a Microsoft Excel workbook.
Public delegate WorkbookEvents_DeactivateEventHandler A Delegate type used to add an event handler for the Deactivate event. The Deactivate event occurs when the workbook is deactivated.
Public delegate WorkbookEvents_NewChartEventHandler A Delegate type used to add an event handler for the NewChart event. The NewChart event occurs when a new chart is created in the workbook.
Public delegate WorkbookEvents_NewSheetEventHandler A Delegate type used to add an event handler for the NewSheet event. The NewSheet event occurs when a new sheet is created in the workbook.
Public delegate WorkbookEvents_OpenEventHandler A Delegate type used to add an event handler for the Open event. The Open event occurs when the workbook is opened.
Public delegate WorkbookEvents_PivotTableCloseConnectionEventHandler A Delegate type used to add an event handler for the PivotTableCloseConnection event. The PivotTableCloseConnection event occurs after a PivotTable report closes the connection to its data source.
Public delegate WorkbookEvents_PivotTableOpenConnectionEventHandler A Delegate type used to add an event handler for the PivotTableOpenConnection event. The PivotTableOpenConnection event occurs after a PivotTable report opens the connection to its data source.
Public delegate WorkbookEvents_RowsetCompleteEventHandler A Delegate type used to add an event handler for the RowsetComplete event. The RowsetComplete event occurs when the user either drills through the recordset or invokes the rowset action on an OLAP PivotTable.
Public delegate WorkbookEvents_SheetActivateEventHandler A Delegate type used to add an event handler for the SheetActivate event. The SheetActivate event occurs when any sheet is activated.
Public delegate WorkbookEvents_SheetBeforeDoubleClickEventHandler A Delegate type used to add an event handler for the SheetBeforeDoubleClick event. The SheetBeforeDoubleClick event occurs when any worksheet is double-clicked, before the default double-click action.
Public delegate WorkbookEvents_SheetBeforeRightClickEventHandler A Delegate type used to add an event handler for the SheetBeforeRightClick event. The SheetBeforeRightClick event occurs when any worksheet is right-clicked, before the default right-click action.
Public delegate WorkbookEvents_SheetCalculateEventHandler A Delegate type used to add an event handler for the SheetCalculate event. The SheetCalculate event occurs after any worksheet is recalculated or after any changed data is plotted on a chart.
Public delegate WorkbookEvents_SheetChangeEventHandler A Delegate type used to add an event handler for the SheetChange event. The SheetChange event occurs when cells in any worksheet are changed by the user or by an external link.
Public delegate WorkbookEvents_SheetDeactivateEventHandler A Delegate type used to add an event handler for the SheetDeactivate event. The SheetDeactivate event occurs when any sheet is deactivated.
Public delegate WorkbookEvents_SheetFollowHyperlinkEventHandler A Delegate type used to add an event handler for the SheetFollowHyperlink event. The SheetFollowHyperlink event occurs when you click any hyperlink in Microsoft Excel.
Public delegate WorkbookEvents_SheetPivotTableAfterValueChangeEventHandler A Delegate type used to add an event handler for the SheetPivotTableAfterValueChange event. The SheetPivotTableAfterValueChange event occurs after a cell or range of cells inside a PivotTable are edited or recalculated (for cells that contain formulas).
Public delegate WorkbookEvents_SheetPivotTableBeforeAllocateChangesEventHandler A Delegate type used to add an event handler for the SheetPivotTableBeforeAllocateChanges event. The SheetPivotTableBeforeAllocateChanges event occurs before changes are applied to a PivotTable.
Public delegate WorkbookEvents_SheetPivotTableBeforeCommitChangesEventHandler A Delegate type used to add an event handler for the SheetPivotTableBeforeCommitChanges event. The SheetPivotTableBeforeCommitChanges event occurs before changes are committed against the OLAP data source for a PivotTable.
Public delegate WorkbookEvents_SheetPivotTableBeforeDiscardChangesEventHandler A Delegate type used to add an event handler for the SheetPivotTableBeforeDiscardChanges event. The SheetPivotTableBeforeDiscardChanges event occurs before changes to a PivotTable are discarded.
Public delegate WorkbookEvents_SheetPivotTableChangeSyncEventHandler A Delegate type used to add an event handler for the SheetPivotTableChangeSync event. The SheetPivotTableChangeSync event occurs after changes to a PivotTable.
Public delegate WorkbookEvents_SheetPivotTableUpdateEventHandler A Delegate type used to add an event handler for the SheetPivotTableUpdate event. The SheetPivotTableUpdate event occurs after the sheet of the PivotTable report has been updated.
Public delegate WorkbookEvents_SheetSelectionChangeEventHandler A Delegate type used to add an event handler for the SheetSelectionChange event. The SheetSelectionChange event occurs when the selection changes on any worksheet (doesn't occur if the selection is on a chart sheet).
Public delegate WorkbookEvents_SyncEventHandler A Delegate type used to add an event handler for the Sync event. The Sync event occurs when the local copy of a worksheet that is part of a Document Workspace is synchronized with the copy on the server.
Public delegate WorkbookEvents_WindowActivateEventHandler A Delegate type used to add an event handler for the WindowActivate event. The WindowActivate event occurs when any workbook window is activated.
Public delegate WorkbookEvents_WindowDeactivateEventHandler A Delegate type used to add an event handler for the WindowDeactivate event. The WindowDeactivate event occurs when any workbook window is deactivated.
Public delegate WorkbookEvents_WindowResizeEventHandler A Delegate type used to add an event handler for the WindowResize event. The WindowResize event occurs when any workbook window is resized.

Enumerations

  Enumeration Description
Public enumeration Constants Specifies global constants used in Microsoft Excel.
Public enumeration XlAboveBelow Specifies if the values are above or below average.
Public enumeration XlActionType Specifies the action that should be performed.
Public enumeration XlAllocation Specifies when to calculate changes when performing what-if analysis on a PivotTable based on an OLAP data source.
Public enumeration XlAllocationMethod Specifies the method to use to allocate values when performing what-if analysis on a PivotTable report based on an OLAP data source.
Public enumeration XlAllocationValue Specifies what value to allocate when performing what-if analysis on a PivotTable report based on an OLAP data source.
Public enumeration XlApplicationInternational Specifies country/region and international settings.
Public enumeration XlApplyNamesOrder Specifies which range name is listed first when a cell reference is replaced by a row-oriented and column-oriented range name.
Public enumeration XlArabicModes Specifies spelling rules for the Arabic spelling checker.
Public enumeration XlArrangeStyle Specifies how windows are arranged on the screen.
Public enumeration XlArrowHeadLength Specifies the length of the arrowhead at the end of a line.
Public enumeration XlArrowHeadStyle Specifies the type of arrowhead to apply to the line end.
Public enumeration XlArrowHeadWidth Specifies the width of the arrowhead at the line end.
Public enumeration XlAutoFillType Specifies how the target range is to be filled, based on the contents of the source range.
Public enumeration XlAutoFilterOperator Specifies the operator to use to associate two criteria applied by a filter.
Public enumeration XlAxisCrosses Specifies the point on the specified axis where the other axis crosses.
Public enumeration XlAxisGroup Specifies the type of axis group.
Public enumeration XlAxisType Specifies the axis type.
Public enumeration XlBackground Specifies the background type for text in charts.
Public enumeration XlBarShape Specifies the shape used with the 3-D bar or column chart.
Public enumeration XlBordersIndex Specifies the border to be retrieved.
Public enumeration XlBorderWeight Specifies the weight of the border around a range.
Public enumeration XlBuiltInDialog Specifies which dialog box to display.
Public enumeration XlCalcFor Specifies what should be calculated.
Public enumeration XlCalculatedMemberType Specifies the type of a calculated member in a pivot table.
Public enumeration XlCalculation Specifies the calculation mode.
Public enumeration XlCalculationInterruptKey Specifies which key interrupts recalculation.
Public enumeration XlCalculationState Specifies the calculation state of the application.
Public enumeration XlCategoryType Specifies the type of the category axis.
Public enumeration XlCellChangedState Specifies whether a PivotTable value cell has been edited or recalculated since the PivotTable report was created or the last commit operation was performed.
Public enumeration XlCellInsertionMode Specifies the way rows on the specified worksheet are added or deleted to accommodate the number of rows in a recordset returned by a query.
Public enumeration XlCellType Specifies the type of cells.
Public enumeration XlChartElementPosition Specifies the position of the chart element.
Public enumeration XlChartGallery Specifies a chart gallery.
Public enumeration XlChartItem Specifies the type of the chart item.
Public enumeration XlChartLocation Specifies where to relocate a chart.
Public enumeration XlChartPicturePlacement Specifies the placement of a user-selected picture on a bar in a 3-D bar or column.
Public enumeration XlChartPictureType Specifies how pictures are displayed on a column, bar picture chart, or legend key.
Public enumeration XlChartSplitType Specifies the values displayed in the second chart in a pie chart or a bar of pie chart.
Public enumeration XlChartType Specifies the chart type.
Public enumeration XlCheckInVersionType Specifies the type of version for the document checked in when using the CheckIn method. Applies to workbooks stored in a SharePoint library.
Public enumeration XlClipboardFormat Specifies the format of an item on the Windows clipboard.
Public enumeration XlCmdType Specifies the value of the CommandText property.
Public enumeration XlColorIndex Specifies the color of a selected feature such as border, font, or fill.
Public enumeration XlColumnDataType Specifies how a column is to be parsed.
Public enumeration XlCommandUnderlines Specifies the state of the command underlines in Microsoft Excel for the Macintosh.
Public enumeration XlCommentDisplayMode Specifies the way cells display comments and comment indicators.
Public enumeration XlConditionValueTypes Specifies the types of condition values that can be used.
Public enumeration XlConnectionType Specifies the type of database connection.
Public enumeration XlConsolidationFunction Specifies the subtotal function.
Public enumeration XlContainsOperator Specifies the operator used in a function.
Public enumeration XlCopyPictureFormat Specifies the format of the picture being copied.
Public enumeration XlCorruptLoad Specifies the processing for a file when it is opened.
Public enumeration XlCreator Specifies the 32-bit creator code for Excel for Macintosh (decimal 1480803660, Hex 5843454C, string XCEL).
Public enumeration XlCredentialsMethod Specifies the type of credentials method used.
Public enumeration XlCubeFieldSubType Specifies the subtype of the CubeField.
Public enumeration XlCubeFieldType Specifies whether the OLAP field is a hierarchy, set, or measure field.
Public enumeration XlCutCopyMode Specifies whether status is Copy mode or Cut mode.
Public enumeration XlCVError Specifies the cell error number and value.
Public enumeration XlDataBarAxisPosition Specifies the axis position for a range of cells with conditional formatting as data bars.
Public enumeration XlDataBarBorderType Specifies the border of a data bar.
Public enumeration XlDataBarFillType Specifies how a data bar is filled with color.
Public enumeration XlDataBarNegativeColorType Specifies whether to use the same border and fill color as postive data bars.
Public enumeration XlDataLabelPosition Specifies where the data label is positioned.
Public enumeration XlDataLabelSeparator Specifies the separator used with data labels.
Public enumeration XlDataLabelsType Specifies the type of data label to apply.
Public enumeration XlDataSeriesDate Specifies the type of date to apply to a data series.
Public enumeration XlDataSeriesType Specifies the data series to create.
Public enumeration XlDeleteShiftDirection Specifies how to shift cells to replace deleted cells.
Public enumeration XlDirection Specifies the direction in which to move.
Public enumeration XlDisplayBlanksAs Specifies how blank cells are plotted on a chart.
Public enumeration XlDisplayDrawingObjects Specifies how shapes are displayed.
Public enumeration XlDisplayUnit Specifies the display unit label for an axis.
Public enumeration XlDupeUnique Specifies whether duplicate or unique values shoud be displayed.
Public enumeration XlDVAlertStyle Specifies the icon used in message boxes displayed during validation.
Public enumeration XlDVType Specifies the type of validation test to be performed in conjunction with values.
Public enumeration XlDynamicFilterCriteria Specifies the filter criterion.
Public enumeration XlEditionFormat Specifies the format of the published edition. This is Macintosh only and should not be used.
Public enumeration XlEditionOptionsOption This enumeration is for Macintosh only and should not be used.
Public enumeration XlEditionType Specifies the type of edition to be changed.
Public enumeration XlEnableCancelKey Specifies how Microsoft Excel handles CTRL+BREAK (or ESC or COMMAND+PERIOD) user interruptions to the running procedure.
Public enumeration XlEnableSelection Specifies what can be selected on the sheet.
Public enumeration XlEndStyleCap Specifies the end style for error bars.
Public enumeration XlErrorBarDirection Specifies which axis values are to receive error bars.
Public enumeration XlErrorBarInclude Specifies which error bar parts to include.
Public enumeration XlErrorBarType Specifies the range marked by error bars.
Public enumeration XlErrorChecks Specifies the type of error object to be retrieved from the Errors collection.
Public enumeration XlFileAccess Specifies the new access mode for the object.
Public enumeration XlFileFormat Specifies the file format when saving the spreadsheet.
Public enumeration XlFileValidationPivotMode Specifies how to validate the data caches for PivotTable reports.
Public enumeration XlFillWith Specifies how to copy the range.
Public enumeration XlFilterAction Specifies whether data is to be copied or left in place during a filter operation.
Public enumeration XlFilterAllDatesInPeriod Specifies how dates should be filtered in the specified period.
Public enumeration XlFindLookIn Specifies the type of data to search.
Public enumeration XlFixedFormatQuality Specifies the quality of speadsheets saved in different fixed formats.
Public enumeration XlFixedFormatType Specifies the type of file format.
Public enumeration XlFormatConditionOperator Specifies the operator to use to compare a formula against the value in a cell or, for xlBetween and xlNotBetween, to compare two formulas.
Public enumeration XlFormatConditionType Specifies whether the conditional format is based on a cell value or an expression.
Public enumeration XlFormatFilterTypes Specifies the types of format filters.
Public enumeration XlFormControl Specifies the type of the form control.
Public enumeration XlFormulaLabel Specifies the formula label type for the specified range.
Public enumeration XlGenerateTableRefs Specifies the type of table references.
Public enumeration XlGradientFillType Specifies the type of gradient fill.
Public enumeration XlHAlign Specifies the horizontal alignment for the object.
Public enumeration XlHebrewModes Specifies the mode for the Hebrew spelling checker.
Public enumeration XlHighlightChangesTime Specifies which set of changes is shown in a shared workbook.
Public enumeration XlHtmlType Specifies the type of HTML generated by Microsoft Excel when you save the specified item to a Web page and whether the item is static or interactive.
Public enumeration XlIcon Specifies the icon for a criterion in an icon set conditional formatting rule.
Public enumeration XlIconSet Specifies the type of icon set.
Public enumeration XlIMEMode Specifies the description of the Japanese input rules.
Public enumeration XlImportDataAs Specifies the format in which to return data from a database.
Public enumeration XlInsertFormatOrigin Specifies from where to copy the format for inserted rows.
Public enumeration XlInsertShiftDirection Specifies the direction in which to shift cells during an insertion.
Public enumeration XlLayoutFormType Specifies the way the specified PivotTable items appear—in table format or in outline format.
Public enumeration XlLayoutRowType Specifies the type of layout row.
Public enumeration XlLegendPosition Specifies the position of the legend on a chart.
Public enumeration XlLineStyle Specifies the line style for the border.
Public enumeration XlLink Specifies the type of link.
Public enumeration XlLinkInfo Specifies the type of information to be returned.
Public enumeration XlLinkInfoType Specifies the type of link.
Public enumeration XlLinkStatus Specifies the status of a link.
Public enumeration XlLinkType Specifies the type of link.
Public enumeration XlListConflict Specifies the conflict resolution options for updating a list on a Microsoft Windows SharePoint Services site with the changes made to a list in a Microsoft Excel worksheet.
Public enumeration XlListDataType Specifies the data type of a list column connected to a Microsoft Windows SharePoint Services site.
Public enumeration XlListObjectSourceType Specifies the current source of the list.
Public enumeration XlLocationInTable Specifies the part of the PivotTable report that contains the upper-left corner of a range.
Public enumeration XlLookAt Specifies whether a match is made against the whole of the search text or any part of the search text.
Public enumeration XlLookFor Specifies what to look for in searches.
Public enumeration XlMailSystem Specifies the mail system that is installed on the host machine.
Public enumeration XlMarkerStyle Specifies the marker style for a point or series in a line chart, scatter chart, or radar chart.
Public enumeration XlMeasurementUnits Specifies the measurement units.
Public enumeration XlMouseButton Specifies which mouse button was pressed.
Public enumeration XlMousePointer Specifies the appearance of the mouse pointer in Microsoft Excel.
Public enumeration XlMSApplication Specifies a Microsoft application.
Public enumeration XlOartHorizontalOverflow Specifies the horizontal overflow setting for a text frame.
Public enumeration XlOartVerticalOverflow Specifies the vertical overflow setting for a text frame.
Public enumeration XlObjectSize Specifies the way a chart is scaled to fit on a page.
Public enumeration XlOLEType Specifies the OLE object type.
Public enumeration XlOLEVerb Specifies the verb that the server of the OLE object should act on.
Public enumeration XlOrder Specifies the order in which cells are processed.
Public enumeration XlOrientation Specifies the text orientation.
Public enumeration XlPageBreak Specifies page break location in the worksheet.
Public enumeration XlPageBreakExtent Specifies whether a page break is full screen or applies only within the print area.
Public enumeration XlPageOrientation Specifies the page orientation when the worksheet is printed.
Public enumeration XlPaperSize Specifies the size of the paper.
Public enumeration XlParameterDataType Specifies the data type of a query parameter.
Public enumeration XlParameterType Specifies how to determine the value of the parameter for the specified query table.
Public enumeration XlPasteSpecialOperation Specifies how numeric data will be calculated with the destinations cells in the worksheet.
Public enumeration XlPasteType Specifies the part of the range to be pasted.
Public enumeration XlPattern Specifies the interior pattern of a chart or interior object.
Public enumeration XlPhoneticAlignment Specifies the alignment for phonetic text.
Public enumeration XlPhoneticCharacterType Specifies the type of phonetic text in a cell.
Public enumeration XlPictureAppearance Specifies how the picture should be copied.
Public enumeration XlPictureConvertorType Specifies how to convert a graphic.
Public enumeration XlPieSliceIndex Specifies which position on the slice to return the coordinate of.
Public enumeration XlPieSliceLocation Specifies the horizontal or vertical position of a point on a pie chart, in points, from the top or left edge of the object to the top or left edge of the chart area.
Public enumeration XlPivotCellType Specifies the PivotTable entity the cell corresponds to.
Public enumeration XlPivotConditionScope This enumeration specifies the conditional formatting applied for filtering values from the PivotTable object.
Public enumeration XlPivotFieldCalculation Specifies the type of calculation performed by a data PivotField when a custom calculation is used.
Public enumeration XlPivotFieldDataType Specifies the type of data in the PivotTable field.
Public enumeration XlPivotFieldOrientation Specifies the location of the field in a PivotTable report.
Public enumeration XlPivotFieldRepeatLabels Specifies whether to repeat all field item labels in a PivotTable report.
Public enumeration XlPivotFilterType The type of filter applied.
Public enumeration XlPivotFormatType Specifies the type of report formatting to be applied to the specified PivotTable report.
Public enumeration XlPivotLineType Specifies the type of the PivotLine.
Public enumeration XlPivotTableMissingItems Specifies the maximum number of unique items per PivotField allowed.
Public enumeration XlPivotTableSourceType Specifies the source of the report data.
Public enumeration XlPivotTableVersionList Specifies the version of a PivotTable or a PivotCache. Creating PivotTables with a specific version ensures that tables created in behave in the same manner as they did in the corresponding version of Excel.
Public enumeration XlPlacement Specifies the way an object is attached to its underlying cells.
Public enumeration XlPlatform Specifies the platform that a text file originated on.
Public enumeration XlPortugueseReform Specifies the mode for checking the spelling of Portuguese.
Public enumeration XlPrintErrors Specifies the type of print error displayed.
Public enumeration XlPrintLocation Specifies the way comments are printed with the sheet.
Public enumeration XlPriority Specifies the priority of a SendMailer message.
Public enumeration XlPropertyDisplayedIn Specifies where to display the property.
Public enumeration XlProtectedViewCloseReason Specifies how the Protected View window was closed.
Public enumeration XlProtectedViewWindowState Specifies the state of the Protected View window.
Public enumeration XlPTSelectionMode Specifies what may be selected in a PivotTable during a structured selection. These constants may be combined to select multiple types.
Public enumeration XlQueryType Specifies the type of query used by Microsoft Excel to populate the query table or PivotTable cache.
Public enumeration XlRangeAutoFormat Specifies the predefined format when a range is automatically formatted.
Public enumeration XlRangeValueDataType Specifies the range value data type.
Public enumeration XlReferenceStyle Specifies the reference style.
Public enumeration XlReferenceType Specifies cell reference style when a formula is being converted.
Public enumeration XlRemoveDocInfoType Specifies the type information to be removed from the document information.
Public enumeration XlRgbColor Specifies the RGB color.
Public enumeration XlRobustConnect Specifies how the PivotTable cache connects to its data source.
Public enumeration XlRoutingSlipDelivery Specifies the routing delivery method.
Public enumeration XlRoutingSlipStatus Specifies the status of the routing slip.
Public enumeration XlRowCol Specifies whether the values corresponding to a particular data series are in rows or columns.
Public enumeration XlRunAutoMacro Specifies the automatic macro to run.
Public enumeration XlSaveAction Specifies during file close if the file will be saved.
Public enumeration XlSaveAsAccessMode Specifies the access mode for the Save As function.
Public enumeration XlSaveConflictResolution Specifies the way conflicts are to be resolved whenever a shared workbook is updated.
Public enumeration XlScaleType Specifies the scale type of the value axis.
Public enumeration XlSearchDirection Specifies the search direction when searching a range.
Public enumeration XlSearchOrder Specifies the order in which to search the range.
Public enumeration XlSearchWithin Specifies the extent of the search for the range.
Public enumeration XlSheetType Specifies the worksheet type.
Public enumeration XlSheetVisibility Specifies whether the object is visible.
Public enumeration XlSizeRepresents Specifies what the bubble size represents on a bubble chart.
Public enumeration XlSlicerCrossFilterType Specifies the type of cross filtering used by the specified slicer cache and how it is visualized.
Public enumeration XlSlicerSort Specifies whether items displayed in the slicer are sorted, and if they are sorted, whether they are sorted in ascending or descending order by item captions.
Public enumeration XlSmartTagControlType Specifies the type of Smart Document control displayed in the Document Actions task pane.
Public enumeration XlSmartTagDisplayMode Specifies the display features for smart tags.
Public enumeration XlSortDataOption Specifies how to sort text.
Public enumeration XlSortMethod Specifies the type of sort.
Public enumeration XlSortMethodOld Specifies how to sort when using East Asian sorting methods.
Public enumeration XlSortOn Specifies the parameter on which the data should be sorted.
Public enumeration XlSortOrder Specifies the sort order for the specified field or range.
Public enumeration XlSortOrientation Specifies the sort orientation.
Public enumeration XlSortType Specifies which elements are to be sorted. Use this argument only when sorting PivotTable reports.
Public enumeration XlSourceType Identifies the source object.
Public enumeration XlSpanishModes Specifies the mode for checking the spelling of Spanish.
Public enumeration XlSparklineRowCol Specifies how to plot the sparkline when the data on which it is based is in a square-shaped range.
Public enumeration XlSparkScale Specifies how the minimum or maximum value of the vertical axis of the sparkline is scaled relative to other sparklines in the group.
Public enumeration XlSparkType Specifies the type of sparkline.
Public enumeration XlSpeakDirection Specifies the order in which the cells are spoken.
Public enumeration XlSpecialCellsValue Specifies cells with a particular type of value to include in the result.
Public enumeration XlStdColorScale Specifies the standard color scale.
Public enumeration XlSubscribeToFormat Specifies the format to use when subscribing to a published edition.
Public enumeration XlSubtototalLocationType Specifies where the subtotal will be displayed on the worksheet.
Public enumeration XlSummaryColumn Specifies the location of the summary columns in the outline.
Public enumeration XlSummaryReportType Specifies the type of summary to be created for scenarios.
Public enumeration XlSummaryRow Specifies the location of the summary rows in the outline.
Public enumeration XlTableStyleElementType Specifies the table style element used.
Public enumeration XlTabPosition Specifies the first or last tab position.
Public enumeration XlTextParsingType Specifies the column format for the data in the text file that you’re importing into a query table.
Public enumeration XlTextQualifier Specifies the delimiter to use to specify text.
Public enumeration XlTextVisualLayoutType Specifies whether the visual layout of the text being imported is left-to-right or right-to-left.
Public enumeration XlThemeColor Specifies the theme color to be used.
Public enumeration XlThemeFont Specifies the theme font to use.
Public enumeration XlThreadMode Specifies the control over the multi-threaded calculation mode.
Public enumeration XlTickLabelOrientation Specifies the text orientation for tick-mark labels.
Public enumeration XlTickLabelPosition Specifies the position of tick-mark labels on the specified axis.
Public enumeration XlTickMark Specifies the position of major and minor tick marks for an axis.
Public enumeration XlTimePeriods Specifies the time period.
Public enumeration XlTimeUnit Specifies unit of time for chart axis and data series.
Public enumeration XlToolbarProtection Specifies which properties of a toolbar are restricted. Options may be combined using Or.
Public enumeration XlTopBottom Specifies the top 10 values from the top or bottom of a series of values.
Public enumeration XlTotalsCalculation Specifies the type of calculation in the Totals row of a list column.
Public enumeration XlTrendlineType Specifies how the trendline that smoothes out fluctuations in the data is calculated.
Public enumeration XlUnderlineStyle Specifies the type of underline applied to a font.
Public enumeration XlUpdateLinks Specifies a workbook's setting for updating embedded OLE links.
Public enumeration XlVAlign Specifies the vertical alignment for the object.
Public enumeration XlWBATemplate Specifies the type of workbook to create.
Public enumeration XlWebFormatting Specifies how much formatting from a Web page, if any, is applied when a Web page is imported into a query table.
Public enumeration XlWebSelectionType Specifies whether an entire Web page, all tables on the Web page, or only a specific table is imported into a query table.
Public enumeration XlWindowState Specifies the state of the window.
Public enumeration XlWindowType Specifies how the chart is displayed.
Public enumeration XlWindowView Specifies the view showing in the window.
Public enumeration XlXLMMacroType Specifies, in a Microsoft Excel version 4 macro worksheet, what type of macro a name refers to or whether the name refers to a macro.
Public enumeration XlXmlExportResult Specifies the results of the save or export operation.
Public enumeration XlXmlImportResult Specifies the results of the refresh or import operation.
Public enumeration XlXmlLoadOption Specifies how Excel opens the XML data file.
Public enumeration XlYesNoGuess Specifies whether or not the first row contains headers.