Was this page helpful?
Your feedback about this content is important. Let us know what you think.
Additional feedback?
1500 characters remaining
MSDN Library

Microsoft.Office.Interop.Excel Namespace

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

 DelegateDescription
Public delegate AppEvents_AfterCalculateEventHandler  
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_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_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_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_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  
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_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_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_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  
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_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.

 EnumerationDescription
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 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 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 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 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 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 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 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 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 Microsoft Excel version number.
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 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 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 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 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.

Community Additions

Show:
© 2015 Microsoft