Home Library Learn Downloads Support Community
Sign in | United States - English | |
7 out of 15 rated this helpful - Rate this topic

Microsoft.Office.Interop.Excel Namespace

Office 2010

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.

  Class Description
Public class AppEvents_SinkHelper Infrastructure.
Public class ApplicationClass Infrastructure.
Public class ChartClass Infrastructure.
Public class ChartEvents_SinkHelper Infrastructure.
Public class DocEvents_SinkHelper Infrastructure.
Public class GlobalClass Infrastructure.
Public class OLEObjectClass Infrastructure.
Public class OLEObjectEvents_SinkHelper Infrastructure.
Public class QueryTableClass Infrastructure.
Public class RefreshEvents_SinkHelper Infrastructure.
Public class WorkbookClass Infrastructure.
Public class WorkbookEvents_SinkHelper Infrastructure.
Public class WorksheetClass Infrastructure.
  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 Infrastructure.
Public interface _IOLEObject Infrastructure.
Public interface _IQueryTable Infrastructure.
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 Infrastructure.
Public interface AppEvents_Event Events interface for Microsoft Excel Application object events.
Public interface Application Represents the entire Microsoft Excel application.
Public interface Arc Infrastructure.
Public interface Arcs Infrastructure.
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 Infrastructure.
Public interface Buttons Infrastructure.
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 Infrastructure.
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 Infrastructure.
Public interface CheckBoxes Infrastructure.
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 Infrastructure.
Public interface Dialogs A collection of all the Dialog objects in Microsoft Excel.
Public interface DialogSheet Infrastructure.
Public interface DialogSheets Infrastructure.
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 Infrastructure.
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 Infrastructure.
Public interface DrawingObjects Infrastructure.
Public interface Drawings Infrastructure.
Public interface DropDown Infrastructure.
Public interface DropDowns Infrastructure.
Public interface DropLines Represents the drop lines in a chart group.
Public interface EditBox Infrastructure.
Public interface EditBoxes Infrastructure.
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 Infrastructure.
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 Infrastructure.
Public interface GroupBoxes Infrastructure.
Public interface GroupObject Infrastructure.
Public interface GroupObjects Infrastructure.
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 Infrastructure.
Public interface IAction Infrastructure.
Public interface IActions Infrastructure.
Public interface IAddIn Infrastructure.
Public interface IAddIns Infrastructure.
Public interface IAddIns2 Infrastructure.
Public interface IAllowEditRange Infrastructure.
Public interface IAllowEditRanges Infrastructure.
Public interface IAppEvents Infrastructure.
Public interface IArc Infrastructure.
Public interface IArcs Infrastructure.
Public interface IAreas Infrastructure.
Public interface IAutoCorrect Infrastructure.
Public interface IAutoFilter Infrastructure.
Public interface IAutoRecover Infrastructure.
Public interface IAxes Infrastructure.
Public interface IAxis Infrastructure.
Public interface IAxisTitle Infrastructure.
Public interface IBorder Infrastructure.
Public interface IBorders Infrastructure.
Public interface IButton Infrastructure.
Public interface IButtons Infrastructure.
Public interface ICalculatedFields Infrastructure.
Public interface ICalculatedItems Infrastructure.
Public interface ICalculatedMember Infrastructure.
Public interface ICalculatedMembers Infrastructure.
Public interface ICanvasShapes Infrastructure.
Public interface ICellFormat Infrastructure.
Public interface ICharacters Infrastructure.
Public interface IChartArea Infrastructure.
Public interface IChartColorFormat Infrastructure.
Public interface IChartEvents Infrastructure.
Public interface IChartFillFormat Infrastructure.
Public interface IChartFormat Infrastructure.
Public interface IChartGroup Infrastructure.
Public interface IChartGroups Infrastructure.
Public interface IChartObject Infrastructure.
Public interface IChartObjects Infrastructure.
Public interface ICharts Infrastructure.
Public interface IChartTitle Infrastructure.
Public interface IChartView Infrastructure.
Public interface ICheckBox Infrastructure.
Public interface ICheckBoxes Infrastructure.
Public interface IColorScale Infrastructure.
Public interface IColorScaleCriteria Infrastructure.
Public interface IColorScaleCriterion Infrastructure.
Public interface IColorStop Infrastructure.
Public interface IColorStops Infrastructure.
Public interface IComment Infrastructure.
Public interface IComments Infrastructure.
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 Infrastructure.
Public interface IConnections Infrastructure.
Public interface IConnectorFormat Infrastructure.
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 Infrastructure.
Public interface ICorners Infrastructure.
Public interface ICustomProperties Infrastructure.
Public interface ICustomProperty Infrastructure.
Public interface ICustomView Infrastructure.
Public interface ICustomViews Infrastructure.
Public interface IDatabar Infrastructure.
Public interface IDataBarBorder
Public interface IDataLabel Infrastructure.
Public interface IDataLabels Infrastructure.
Public interface IDataTable Infrastructure.
Public interface IDiagram Infrastructure.
Public interface IDialog Infrastructure.
Public interface IDialogFrame Infrastructure.
Public interface IDialogs Infrastructure.
Public interface IDialogSheet Infrastructure.
Public interface IDialogSheets Infrastructure.
Public interface IDialogSheetView Infrastructure.
Public interface IDisplayFormat
Public interface IDisplayUnitLabel Infrastructure.
Public interface IDocEvents Infrastructure.
Public interface IDownBars Infrastructure.
Public interface IDrawing Infrastructure.
Public interface IDrawingObjects Infrastructure.
Public interface IDrawings Infrastructure.
Public interface IDropDown Infrastructure.
Public interface IDropDowns Infrastructure.
Public interface IDropLines Infrastructure.
Public interface IDummy Infrastructure.
Public interface IEditBox Infrastructure.
Public interface IEditBoxes Infrastructure.
Public interface IError Infrastructure.
Public interface IErrorBars Infrastructure.
Public interface IErrorCheckingOptions Infrastructure.
Public interface IErrors Infrastructure.
Public interface IFileExportConverter Infrastructure.
Public interface IFileExportConverters Infrastructure.
Public interface IFilter Infrastructure.
Public interface IFilters Infrastructure.
Public interface IFloor Infrastructure.
Public interface IFont Infrastructure.
Public interface IFormatColor Infrastructure.
Public interface IFormatCondition Infrastructure.
Public interface IFormatConditions Infrastructure.
Public interface IFreeformBuilder Infrastructure.
Public interface IGraphic Infrastructure.
Public interface IGridlines Infrastructure.
Public interface IGroupBox Infrastructure.
Public interface IGroupBoxes Infrastructure.
Public interface IGroupObject Infrastructure.
Public interface IGroupObjects Infrastructure.
Public interface IGroupShapes Infrastructure.
Public interface IHeaderFooter Infrastructure.
Public interface IHiLoLines Infrastructure.
Public interface IHPageBreak Infrastructure.
Public interface IHPageBreaks Infrastructure.
Public interface IHyperlink Infrastructure.
Public interface IHyperlinks Infrastructure.
Public interface IIcon Infrastructure.
Public interface IIconCriteria Infrastructure.
Public interface IIconCriterion Infrastructure.
Public interface IIconSet Infrastructure.
Public interface IIconSetCondition Infrastructure.
Public interface IIconSets Infrastructure.
Public interface IInterior Infrastructure.
Public interface ILabel Infrastructure.
Public interface ILabels Infrastructure.
Public interface ILeaderLines Infrastructure.
Public interface ILegend Infrastructure.
Public interface ILegendEntries Infrastructure.
Public interface ILegendEntry Infrastructure.
Public interface ILegendKey Infrastructure.
Public interface ILine Infrastructure.
Public interface ILinearGradient Infrastructure.
Public interface ILines Infrastructure.
Public interface ILinkFormat Infrastructure.
Public interface IListBox Infrastructure.
Public interface IListBoxes Infrastructure.
Public interface IListColumn Infrastructure.
Public interface IListColumns Infrastructure.
Public interface IListDataFormat Infrastructure.
Public interface IListObject Infrastructure.
Public interface IListObjects Infrastructure.
Public interface IListRow Infrastructure.
Public interface IListRows Infrastructure.
Public interface IMailer Infrastructure.
Public interface IMenu Infrastructure.
Public interface IMenuBar Infrastructure.
Public interface IMenuBars Infrastructure.
Public interface IMenuItem Infrastructure.
Public interface IMenuItems Infrastructure.
Public interface IMenus Infrastructure.
Public interface IModule Infrastructure.
Public interface IModules Infrastructure.
Public interface IModuleView Infrastructure.
Public interface IMultiThreadedCalculation Infrastructure.
Public interface IName Infrastructure.
Public interface INames Infrastructure.
Public interface INegativeBarFormat Infrastructure.
Public interface Interior Represents the interior of an object.
Public interface IODBCConnection Infrastructure.
Public interface IODBCError Infrastructure.
Public interface IODBCErrors Infrastructure.
Public interface IOLEDBConnection Infrastructure.
Public interface IOLEDBError Infrastructure.
Public interface IOLEDBErrors Infrastructure.
Public interface IOLEFormat Infrastructure.
Public interface IOLEObjectEvents Infrastructure.
Public interface IOLEObjects Infrastructure.
Public interface IOptionButton Infrastructure.
Public interface IOptionButtons Infrastructure.
Public interface IOutline Infrastructure.
Public interface IOval Infrastructure.
Public interface IOvals Infrastructure.
Public interface IPage Infrastructure.
Public interface IPages Infrastructure.
Public interface IPageSetup Infrastructure.
Public interface IPane Infrastructure.
Public interface IPanes Infrastructure.
Public interface IParameter Infrastructure.
Public interface IParameters Infrastructure.
Public interface IPhonetic Infrastructure.
Public interface IPhonetics Infrastructure.
Public interface IPicture Infrastructure.
Public interface IPictures Infrastructure.
Public interface IPivotAxis Infrastructure.
Public interface IPivotCache Infrastructure.
Public interface IPivotCaches Infrastructure.
Public interface IPivotCell Infrastructure.
Public interface IPivotField Infrastructure.
Public interface IPivotFields Infrastructure.
Public interface IPivotFilter Infrastructure.
Public interface IPivotFilters Infrastructure.
Public interface IPivotFormula Infrastructure.
Public interface IPivotFormulas Infrastructure.
Public interface IPivotItem Infrastructure.
Public interface IPivotItemList Infrastructure.
Public interface IPivotItems Infrastructure.
Public interface IPivotLayout Infrastructure.
Public interface IPivotLine Infrastructure.
Public interface IPivotLineCells Infrastructure.
Public interface IPivotLines Infrastructure.
Public interface IPivotTable Infrastructure.
Public interface IPivotTableChangeList
Public interface IPivotTables Infrastructure.
Public interface IPlotArea Infrastructure.
Public interface IPoint Infrastructure.
Public interface IPoints Infrastructure.
Public interface IProtectedViewWindow Infrastructure.
Public interface IProtectedViewWindows Infrastructure.
Public interface IProtection Infrastructure.
Public interface IPublishObjects Infrastructure.
Public interface IQueryTables Infrastructure.
Public interface IRange Infrastructure.
Public interface IRanges Infrastructure.
Public interface IRecentFile Infrastructure.
Public interface IRecentFiles Infrastructure.
Public interface IRectangle Infrastructure.
Public interface IRectangles Infrastructure.
Public interface IRectangularGradient Infrastructure.
Public interface IRefreshEvents Infrastructure.
Public interface IResearch Infrastructure.
Public interface IRoutingSlip Infrastructure.
Public interface IRTD Infrastructure.
Public interface IRtdServer Represents an interface for a real-time data server.
Public interface IRTDUpdateEvent Represents real-time data update events.
Public interface IScenario Infrastructure.
Public interface IScenarios Infrastructure.
Public interface IScrollBar Infrastructure.
Public interface IScrollBars Infrastructure.
Public interface ISeries Infrastructure.
Public interface ISeriesCollection Infrastructure.
Public interface ISeriesLines Infrastructure.
Public interface IServerViewableItems Infrastructure.
Public interface IShape Infrastructure.
Public interface IShapeRange Infrastructure.
Public interface IShapes Infrastructure.
Public interface ISheetViews Infrastructure.
Public interface ISlicer Infrastructure.
Public interface ISlicerCache Infrastructure.
Public interface ISlicerCacheLevel Infrastructure.
Public interface ISlicerCacheLevels Infrastructure.
Public interface ISlicerCaches Infrastructure.
Public interface ISlicerItem Infrastructure.
Public interface ISlicerItems Infrastructure.
Public interface ISlicerPivotTables Infrastructure.
Public interface ISlicers Infrastructure.
Public interface ISmartTag Infrastructure.
Public interface ISmartTagAction Infrastructure.
Public interface ISmartTagActions Infrastructure.
Public interface ISmartTagOptions Infrastructure.
Public interface ISmartTagRecognizer Infrastructure.
Public interface ISmartTagRecognizers Infrastructure.
Public interface ISmartTags Infrastructure.
Public interface ISort Infrastructure.
Public interface ISortField Infrastructure.
Public interface ISortFields Infrastructure.
Public interface ISoundNote Infrastructure.
Public interface ISparkAxes Infrastructure.
Public interface ISparkColor Infrastructure.
Public interface ISparkHorizontalAxis Infrastructure.
Public interface ISparkline Infrastructure.
Public interface ISparklineGroup Infrastructure.
Public interface ISparklineGroups Infrastructure.
Public interface ISparkPoints Infrastructure.
Public interface ISparkVerticalAxis Infrastructure.
Public interface ISpeech Infrastructure.
Public interface ISpellingOptions Infrastructure.
Public interface ISpinner Infrastructure.
Public interface ISpinners Infrastructure.
Public interface IStyle Infrastructure.
Public interface IStyles Infrastructure.
Public interface ITab Infrastructure.
Public interface ITableStyle Infrastructure.
Public interface ITableStyleElement Infrastructure.
Public interface ITableStyleElements Infrastructure.
Public interface ITableStyles Infrastructure.
Public interface ITextBox Infrastructure.
Public interface ITextBoxes Infrastructure.
Public interface ITextFrame Infrastructure.
Public interface ITickLabels Infrastructure.
Public interface IToolbar Infrastructure.
Public interface IToolbarButton Infrastructure.
Public interface IToolbarButtons Infrastructure.
Public interface IToolbars Infrastructure.
Public interface ITop10 Infrastructure.
Public interface ITrendline Infrastructure.
Public interface ITrendlines Infrastructure.
Public interface IUniqueValues Infrastructure.
Public interface IUpBars Infrastructure.
Public interface IUsedObjects Infrastructure.
Public interface IUserAccess Infrastructure.
Public interface IUserAccessList Infrastructure.
Public interface IValidation Infrastructure.
Public interface IValueChange Infrastructure.
Public interface IVPageBreak Infrastructure.
Public interface IVPageBreaks Infrastructure.
Public interface IWalls Infrastructure.
Public interface IWatch Infrastructure.
Public interface IWatches Infrastructure.
Public interface IWindow Infrastructure.
Public interface IWindows Infrastructure.
Public interface IWorkbookConnection Infrastructure.
Public interface IWorkbookEvents Infrastructure.
Public interface IWorksheetFunction Infrastructure.
Public interface IWorksheets Infrastructure.
Public interface IWorksheetView Infrastructure.
Public interface IXmlDataBinding Infrastructure.
Public interface IXmlMap Infrastructure.
Public interface IXmlMaps Infrastructure.
Public interface IXmlNamespace Infrastructure.
Public interface IXmlNamespaces Infrastructure.
Public interface IXmlSchema Infrastructure.
Public interface IXmlSchemas Infrastructure.
Public interface IXPath Infrastructure.
Public interface Label Infrastructure.
Public interface Labels Infrastructure.
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 Infrastructure.
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 Infrastructure.
Public interface LinkFormat Contains linked OLE object properties.
Public interface ListBox Infrastructure.
Public interface ListBoxes Infrastructure.
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 Infrastructure.
Public interface MenuBar Infrastructure.
Public interface MenuBars Infrastructure.
Public interface MenuItem Infrastructure.
Public interface MenuItems Infrastructure.
Public interface Menus Infrastructure.
Public interface Module Infrastructure.
Public interface Modules Infrastructure.
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 Infrastructure.
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 Infrastructure.
Public interface OptionButtons Infrastructure.
Public interface Outline Represents an outline on a worksheet.
Public interface Oval Infrastructure.
Public interface Ovals Infrastructure.
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 Infrastructure.
Public interface PictureFormat Contains properties and methods that apply to pictures and OLE objects.
Public interface Pictures Infrastructure.
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 Infrastructure.
Public interface Rectangles Infrastructure.
Public interface RectangularGradient The RectangularGradient object transitions through a series of colors in a linear manner along a specific angle.
Public interface RefreshEvents Infrastructure.
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 Infrastructure.
Public interface ScrollBars Infrastructure.
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 Infrastructure.
Public interface Spinners Infrastructure.
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 Infrastructure.
Public interface TextBoxes Infrastructure.
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 Infrastructure.
Public interface ToolbarButton Infrastructure.
Public interface ToolbarButtons Infrastructure.
Public interface Toolbars Infrastructure.
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 Infrastructure.
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.
  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.
  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.
Did you find this helpful?
(1500 characters remaining)
Community Content Add
Annotations FAQ