Microsoft.Office.Interop.Excel Namespace
Classes
Interfaces
| Interface | Description |
|---|---|
| _Application | Represents the entire Microsoft Excel application. |
| _Chart | Represents a chart in a workbook. The chart can be either an embedded chart (contained in a ChartObject) or a separate chart sheet. |
| _Global | |
| _IOLEObject | |
| _IQueryTable | |
| _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. |
| _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. |
| _Workbook | Represents a Microsoft Excel workbook. |
| _Worksheet | Represents a worksheet. |
| AddIn | Represents a single add-in, either installed or not installed. |
| AddIns | A collection of AddIn objects that represents all the add-ins available to Microsoft Excel, regardless of whether they’re installed. This list corresponds to the list of add-ins displayed in the Add-Ins dialog box (Tools menu). |
| Adjustments | Contains a collection of adjustment values for the specified AutoShape, WordArt object, or connector. |
| AllowEditRange | Represents the cells that can be edited on a protected worksheet. |
| AllowEditRanges | A collection of all the AllowEditRange objects that represent the cells that can be edited on a protected worksheet. |
| AppEvents | |
| AppEvents_Event | Events interface for Microsoft Excel Application object events. |
| Application | Represents the entire Microsoft Excel application. |
| Arc | |
| Arcs | |
| Areas | A collection of the areas, or contiguous blocks of cells, within a selection. |
| AutoCorrect | Contains Microsoft Excel AutoCorrect attributes (capitalization of names of days, correction of two initial capital letters, automatic correction list, and so on). |
| AutoFilter | Represents autofiltering for the specified worksheet. |
| AutoRecover | Represents the automatic recovery features of a workbook. |
| Axes | A collection of all the Axis objects in the specified chart. |
| Axis | Represents a single axis in a chart. |
| AxisTitle | Represents a chart axis title. |
| Border | Represents the border of an object. |
| Borders | A collection of four Border objects that represent the four borders of a Range or Style object. |
| Button | |
| Buttons | |
| CalculatedFields | A collection of PivotField objects that represents all the calculated fields in the specified PivotTable report. |
| CalculatedItems | A collection of PivotItem objects that represent all the calculated items in the specified PivotTable report. |
| CalculatedMember | Represents the calculated fields and calculated items for PivotTables with Online Analytical Processing (OLAP) data sources. |
| CalculatedMembers | A collection of all the CalculatedMember objects on the specified PivotTable. Each CalculatedMember object represents a calculated member or calculated measure. |
| CalloutFormat | Contains properties and methods that apply to line callouts. |
| CellFormat | Represents the search criteria for the cell format. |
| Characters | Represents characters in an object that contains text. The Characters object lets you modify any sequence of characters contained in the full text string. |
| Chart | Represents a chart in a workbook. The chart can be either an embedded chart (contained in a ChartObject) or a separate chart sheet. |
| ChartArea | Represents the chart area of a chart. The chart area on a 2-D chart contains the axes, the chart title, the axis titles, and the legend. The chart area on a 3-D chart contains the chart title and the legend; it doesn’t include the plot area (the area within the chart area where the data is plotted). For information about formatting the plot area, see the PlotArea object. |
| ChartColorFormat | Used only with charts. Represents the color of a one-color object or the foreground or background color of an object with a gradient or patterned fill. |
| ChartEvents | |
| ChartEvents_Event | Events interface for Microsoft Excel Chart object events. |
| ChartFillFormat | Used only with charts. Represents fill formatting for chart elements. |
| ChartGroup | Represents one or more series plotted in a chart with the same format. The ChartGroup object is a member of the ChartGroups collection. |
| ChartGroups | A collection of all the ChartGroup objects in the specified chart. |
| ChartObject | Represents an embedded chart on a worksheet. |
| ChartObjects | A collection of all the ChartObject objects on the specified chart sheet, dialog sheet, or worksheet. |
| Charts | A collection of all the chart sheets in the specified or active workbook. Each chart sheet is represented by a Chart object. This doesn’t include charts embedded on worksheets or dialog sheets. For information about embedded charts, see the ChartObject object. |
| ChartTitle | Represents the chart title. |
| CheckBox | |
| CheckBoxes | |
| 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. |
| Comment | Represents a cell comment. |
| Comments | A collection of cell comments. Each comment is represented by a Comment object. |
| ConnectorFormat | Contains properties and methods that apply to connectors. |
| ControlFormat | Contains Microsoft Excel control properties. |
| Corners | Represents the corners of a 3-D chart. |
| CubeField | Represents a hierarchy or measure field from an OLAP cube. |
| CubeFields | A collection of all CubeField objects in a PivotTable report that is based on an OLAP cube. |
| CustomProperties | A collection of CustomProperty objects that represent additional information. The information can be used as metadata for XML. |
| CustomProperty | Represents identifier information. Identifier information can be used as metadata for XML. |
| CustomView | Represents a custom workbook view. |
| CustomViews | A collection of custom workbook views. Each view is represented by a CustomView object. |
| DataLabel | Represents the data label on a chart point or trendline. |
| DataLabels | A collection of all the DataLabel objects for the specified series. Each DataLabel object represents a data label for a point or trendline. For a series without definable points (such as an area series), the DataLabels collection contains a single data label. |
| DataTable | Represents a chart data table. |
| DefaultWebOptions | Contains global application-level attributes used by Microsoft Excel when you save a document as a Web page or open a Web page. |
| Diagram | Represents a diagram. |
| DiagramNode | Represents a node in a diagram. |
| DiagramNodeChildren | A collection of DiagramNode objects that represents child nodes in a diagram. |
| DiagramNodes | A collection of DiagramNode objects that represents all the nodes in a diagram. |
| Dialog | Represents a built-in Microsoft Excel dialog box. |
| DialogFrame | |
| Dialogs | A collection of all the Dialog objects in Microsoft Excel. |
| DialogSheet | |
| DialogSheets | |
| DisplayUnitLabel | Represents a unit label on an axis in the specified chart. |
| DocEvents | |
| DocEvents_Event | Events interface for Microsoft Excel Worksheet object events. |
| DownBars | Represents the down bars in a chart group. |
| Drawing | |
| DrawingObjects | |
| Drawings | |
| DropDown | |
| DropDowns | |
| DropLines | Represents the drop lines in a chart group. |
| EditBox | |
| EditBoxes | |
| Error | Represents a spreadsheet error for a range. |
| ErrorBars | Represents the error bars on a chart series. |
| ErrorCheckingOptions | Represents the error-checking options for an application. |
| Errors | Represents the various spreadsheet errors for a range. |
| FillFormat | Represents fill formatting for a shape. |
| Filter | Represents a filter for a single column. The Filter object is a member of the Filters collection. The Filters collection contains all the filters in an autofiltered range. |
| Filters | A collection of Filter objects that represents all the filters in an autofiltered range. |
| Floor | Represents the floor of a 3-D chart. |
| Font | Contains the font attributes (font name, font size, color, and so on) for an object. |
| FormatCondition | Represents a conditional format. |
| FormatConditions | Represents the collection of conditional formats for a single range. |
| FreeformBuilder | Represents the geometry of a freeform while it’s being built. |
| Global | |
| Graphic | Contains properties that apply to header and footer picture objects. |
| Gridlines | Represents major or minor gridlines on a chart axis. |
| GroupBox | |
| GroupBoxes | |
| GroupObject | |
| GroupObjects | |
| GroupShapes | Represents the individual shapes within a grouped shape. |
| HiLoLines | Represents the high-low lines in a chart group. |
| HPageBreak | Represents a horizontal page break. |
| HPageBreaks | The collection of horizontal page breaks within the print area. Each horizontal page break is represented by an HPageBreak object. |
| Hyperlink | Represents a hyperlink. |
| Hyperlinks | Represents the collection of hyperlinks for a worksheet or range. Each hyperlink is represented by a Hyperlink object. |
| IAddIn | |
| IAddIns | |
| IAllowEditRange | |
| IAllowEditRanges | |
| IAppEvents | |
| IArc | |
| IArcs | |
| IAreas | |
| IAutoCorrect | |
| IAutoFilter | |
| IAutoRecover | |
| IAxes | |
| IAxis | |
| IAxisTitle | |
| IBorder | |
| IBorders | |
| IButton | |
| IButtons | |
| ICalculatedFields | |
| ICalculatedItems | |
| ICalculatedMember | |
| ICalculatedMembers | |
| ICanvasShapes | |
| ICellFormat | |
| ICharacters | |
| IChartArea | |
| IChartColorFormat | |
| IChartEvents | |
| IChartFillFormat | |
| IChartGroup | |
| IChartGroups | |
| IChartObject | |
| IChartObjects | |
| ICharts | |
| IChartTitle | |
| ICheckBox | |
| ICheckBoxes | |
| IComment | |
| IComments | |
| IConnectorFormat | |
| IControlFormat | |
| ICorners | |
| ICustomProperties | |
| ICustomProperty | |
| ICustomView | |
| ICustomViews | |
| IDataLabel | |
| IDataLabels | |
| IDataTable | |
| IDiagram | |
| IDialog | |
| IDialogFrame | |
| IDialogs | |
| IDialogSheet | |
| IDialogSheets | |
| IDisplayUnitLabel | |
| IDocEvents | |
| IDownBars | |
| IDrawing | |
| IDrawingObjects | |
| IDrawings | |
| IDropDown | |
| IDropDowns | |
| IDropLines | |
| IDummy | |
| IEditBox | |
| IEditBoxes | |
| IError | |
| IErrorBars | |
| IErrorCheckingOptions | |
| IErrors | |
| IFilter | |
| IFilters | |
| IFloor | |
| IFont | |
| IFormatCondition | |
| IFormatConditions | |
| IFreeformBuilder | |
| IGraphic | |
| IGridlines | |
| IGroupBox | |
| IGroupBoxes | |
| IGroupObject | |
| IGroupObjects | |
| IGroupShapes | |
| IHiLoLines | |
| IHPageBreak | |
| IHPageBreaks | |
| IHyperlink | |
| IHyperlinks | |
| IInterior | |
| ILabel | |
| ILabels | |
| ILeaderLines | |
| ILegend | |
| ILegendEntries | |
| ILegendEntry | |
| ILegendKey | |
| ILine | |
| ILines | |
| ILinkFormat | |
| IListBox | |
| IListBoxes | |
| IListColumn | |
| IListColumns | |
| IListDataFormat | |
| IListObject | |
| IListObjects | |
| IListRow | |
| IListRows | |
| IMailer | |
| IMenu | |
| IMenuBar | |
| IMenuBars | |
| IMenuItem | |
| IMenuItems | |
| IMenus | |
| IModule | |
| IModules | |
| IName | |
| INames | |
| Interior | Represents the interior of an object. |
| IODBCError | |
| IODBCErrors | |
| IOLEDBError | |
| IOLEDBErrors | |
| IOLEFormat | |
| IOLEObjectEvents | |
| IOLEObjects | |
| IOptionButton | |
| IOptionButtons | |
| IOutline | |
| IOval | |
| IOvals | |
| IPageSetup | |
| IPane | |
| IPanes | |
| IParameter | |
| IParameters | |
| IPhonetic | |
| IPhonetics | |
| IPicture | |
| IPictures | |
| IPivotCache | |
| IPivotCaches | |
| IPivotCell | |
| IPivotField | |
| IPivotFields | |
| IPivotFormula | |
| IPivotFormulas | |
| IPivotItem | |
| IPivotItemList | |
| IPivotItems | |
| IPivotLayout | |
| IPivotTable | |
| IPivotTables | |
| IPlotArea | |
| IPoint | |
| IPoints | |
| IProtection | |
| IPublishObjects | |
| IQueryTables | |
| IRange | |
| IRecentFile | |
| IRecentFiles | |
| IRectangle | |
| IRectangles | |
| IRefreshEvents | |
| IRoutingSlip | |
| IRTD | |
| IRtdServer | Represents an interface for a real-time data server. |
| IRTDUpdateEvent | Represents real-time data update events. |
| IScenario | |
| IScenarios | |
| IScrollBar | |
| IScrollBars | |
| ISeries | |
| ISeriesCollection | |
| ISeriesLines | |
| IShape | |
| IShapeRange | |
| IShapes | |
| ISmartTag | |
| ISmartTagAction | |
| ISmartTagActions | |
| ISmartTagOptions | |
| ISmartTagRecognizer | |
| ISmartTagRecognizers | |
| ISmartTags | |
| ISoundNote | |
| ISpeech | |
| ISpellingOptions | |
| ISpinner | |
| ISpinners | |
| IStyle | |
| IStyles | |
| ITab | |
| ITextBox | |
| ITextBoxes | |
| ITextFrame | |
| ITickLabels | |
| IToolbar | |
| IToolbarButton | |
| IToolbarButtons | |
| IToolbars | |
| ITrendline | |
| ITrendlines | |
| IUpBars | |
| IUsedObjects | |
| IUserAccess | |
| IUserAccessList | |
| IValidation | |
| IVPageBreak | |
| IVPageBreaks | |
| IWalls | |
| IWatch | |
| IWatches | |
| IWindow | |
| IWindows | |
| IWorkbookEvents | |
| IWorksheetFunction | |
| IWorksheets | |
| IXmlDataBinding | |
| IXmlMap | |
| IXmlMaps | |
| IXmlNamespace | |
| IXmlNamespaces | |
| IXmlSchema | |
| IXmlSchemas | |
| IXPath | |
| Label | |
| Labels | |
| LeaderLines | Represents leader lines on a chart. |
| Legend | Represents the legend in a chart. |
| LegendEntries | A collection of all the LegendEntry objects in the specified chart legend. |
| LegendEntry | Represents a legend entry in a chart legend. |
| LegendKey | Represents a legend key in a chart legend. |
| Line | |
| LineFormat | Represents line and arrowhead formatting. |
| Lines | |
| LinkFormat | Contains linked OLE object properties. |
| ListBox | |
| ListBoxes | |
| ListColumn | Represents a column in a list. The ListColumn object is a member of the ListColumns collection. The ListColumns collection contains all the columns in a list (ListObject object). |
| ListColumns | A collection of all the ListColumn objects in the specified ListObject object. Each ListColumn object represents a column in the list. |
| ListDataFormat | The ListDataFormat object holds all the data type properties of the ListColumn object. These properties are read-only. |
| ListObject | Represents a list object on a worksheet. |
| ListObjects | A collection of all the ListObject objects on a worksheet. Each ListObject object represents a list in the worksheet. |
| ListRow | Represents a row in a List object. The ListRow object is a member of the ListRows collection. The ListRows collection contains all the rows in a list object. |
| ListRows | A collection of all the ListRow objects in the specified ListObject object. Each ListRow object represents a row in the list. |
| Mailer | You have requested Help for a Visual Basic keyword used only on the Macintosh. For information about this keyword, consult the language reference Help included with Microsoft Office Macintosh Edition. |
| Menu | |
| MenuBar | |
| MenuBars | |
| MenuItem | |
| MenuItems | |
| Menus | |
| Module | |
| Modules | |
| Name | Represents a defined name for a range of cells. |
| Names | A collection of all the Name objects in the application or workbook. Each Name object represents a defined name for a range of cells. Names can be either built-in names — such as Database, Print_Area, and Auto_Open — or custom names. |
| ODBCError | Represents an ODBC error generated by the most recent ODBC query. |
| ODBCErrors | A collection of ODBCError objects. |
| OLEDBError | Represents an OLE DB error returned by the most recent OLE DB query. |
| OLEDBErrors | A collection of OLEDBError objects. |
| OLEFormat | Contains OLE object properties. |
| OLEObject | Represents an ActiveX control or a linked or embedded OLE object on a worksheet. The OLEObject object is a member of the OLEObjects collection. The OLEObjects collection contains all the OLE objects on a single worksheet. |
| OLEObjectEvents | |
| OLEObjectEvents_Event | Events interface for Microsoft Excel OLEObject object events. |
| OLEObjects | A collection of all the OLEObject objects on the specified worksheet. Each OLEObject object represents an ActiveX control or a linked or embedded OLE object. |
| OptionButton | |
| OptionButtons | |
| Outline | Represents an outline on a worksheet. |
| Oval | |
| Ovals | |
| PageSetup | Represents the page setup description. The PageSetup object contains all page setup attributes (left margin, bottom margin, paper size, and so on) as properties. |
| Pane | Represents a pane of a window. |
| Panes | A collection of all the Pane objects shown in the specified window. |
| Parameter | Represents a single parameter used in a parameter query. The Parameter object is a member of the Parameters collection. |
| Parameters | A collection of Parameter objects for the specified query table. Each Parameter object represents a single query parameter. Every query table contains a Parameters collection, but the collection is empty unless the query table is using a parameter query. |
| Phonetic | Contains information about a specific phonetic text string in a cell. |
| Phonetics | A collection of all the Phonetic objects in the specified range. Each Phonetic object contains information about a specific phonetic text string. |
| Picture | |
| PictureFormat | Contains properties and methods that apply to pictures and OLE objects. |
| Pictures | |
| PivotCache | Represents the memory cache for a PivotTable report. |
| PivotCaches | Represents the collection of memory caches from the PivotTable reports in a workbook. |
| PivotCell | Represents a cell in a PivotTable report. |
| PivotField | Represents a field in a PivotTable report. The PivotField object is a member of the PivotFields collection. The PivotFields collection contains all the fields in a PivotTable report, including hidden fields. |
| PivotFields | A collection of all the PivotField objects in a PivotTable report. |
| PivotFormula | Represents a formula used to calculate results in a PivotTable report. |
| PivotFormulas | Represents the collection of formulas for a PivotTable report. Each formula is represented by a PivotFormula object. |
| PivotItem | Represents an item in a PivotTable field. The items are the individual data entries in a field category. The PivotItem object is a member of the PivotItems collection. The PivotItems collection contains all the items in a PivotField object. |
| PivotItemList | A collection of all the PivotItem objects in the specified PivotTable. Each PivotItem represents an item in a PivotTable field. |
| PivotItems | A collection of all the PivotItem objects in a PivotTable field. The items are the individual data entries in a field category. |
| PivotLayout | Represents the placement of fields in a PivotChart report. |
| 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. |
| PivotTables | A collection of all the PivotTable objects on the specified worksheet. |
| PlotArea | Represents the plot area of a chart. This is the area where your chart data is plotted. |
| Point | Represents a single point in a series in a chart. |
| Points | A collection of all the Point objects in the specified series in a chart. |
| Protection | Represents the various types of protection options available for a worksheet. |
| PublishObject | Represents an item in a workbook that has been saved to a Web page and can be refreshed according to values specified by the properties and methods of the PublishObject object. |
| PublishObjects | A collection of all PublishObject objects in the workbook. Each PublishObject object represents an item in a workbook that has been saved to a Web page and can be refreshed according to values specified by the properties and methods of the object. |
| QueryTable | Represents a worksheet table built from data returned from an external data source, such as a SQL server or a Microsoft Access database. The QueryTable object is a member of the QueryTables collection. |
| QueryTables | A collection of QueryTable objects. Each QueryTable object represents a worksheet table built from data returned from an external data source. |
| 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. |
| RecentFile | Represents a file in the list of recently used files. |
| RecentFiles | Represents the list of recently used files. Each file is represented by a RecentFile object. |
| Rectangle | |
| Rectangles | |
| RefreshEvents | |
| RefreshEvents_Event | Events interface for Microsoft Excel QueryTable object events. |
| RoutingSlip | Represents the routing slip for a workbook. The routing slip is used to send a workbook through the electronic mail system. |
| RTD | Represents a real-time data object. |
| Scenario | Represents a scenario on a worksheet. A scenario is a group of input values (called changing cells) that’s named and saved. |
| 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. |
| ScrollBar | |
| ScrollBars | |
| Series | Represents a series in a chart. The Series object is a member of the SeriesCollection collection. |
| SeriesCollection | A collection of all the Series objects in the specified chart or chart group. |
| SeriesLines | Represents series lines in a chart group. Series lines connect the data values from each series. |
| ShadowFormat | Represents shadow formatting for a shape. |
| Shape | Represents an object in the drawing layer, such as an AutoShape, freeform, OLE object, or picture. The Shape object is a member of the Shapes collection. The Shapes collection contains all the shapes on a slide. |
| ShapeNode | Represents the geometry and the geometry-editing properties of the nodes in a user-defined freeform. |
| ShapeNodes | A collection of all the ShapeNode objects in the specified freeform. |
| ShapeRange | Represents a shape range, which is a set of shapes on a document. |
| Shapes | A collection of all the Shape objects on the specified sheet. Each Shape object represents an object in the drawing layer, such as an AutoShape, freeform, OLE object, or picture. |
| Sheets | A collection of all the sheets in the specified or active workbook. |
| SmartTag | Represents an identifier that is assigned to a cell. |
| SmartTagAction | Represents the actions that can be performed with smart tags. |
| SmartTagActions | A collection of SmartTagAction objects that represent the actions that can be performed with smart tags. |
| SmartTagOptions | Represents the options that can be performed with smart tags. |
| SmartTagRecognizer | Represents recognition engines which label data with types of information as you work in Microsoft Excel. |
| SmartTagRecognizers | A collection of SmartTagRecognizer objects that represent recognition engines that label data with types of information as you work in Microsoft Excel. |
| SmartTags | A collection of SmartTag objects that represent the identifiers assigned to each cell. |
| SoundNote | This object should not be used. Sound notes have been removed from Microsoft Excel. |
| Speech | Contains methods and properties that pertain to speech. |
| SpellingOptions | Represents the various spell-checking options for a worksheet. |
| Spinner | |
| Spinners | |
| Style | Represents a style description for a range. |
| Styles | A collection of all the Style objects in the specified or active workbook. |
| Tab | Represents a tab in a chart or a worksheet. |
| TextBox | |
| TextBoxes | |
| TextEffectFormat | Contains properties and methods that apply to WordArt objects. |
| TextFrame | Represents the text frame in a Shape object. Contains the text in the text frame as well as the properties and methods that control the alignment and anchoring of the text frame. |
| ThreeDFormat | Represents a shape's three-dimensional formatting. |
| TickLabels | Represents the tick mark labels associated with tick marks on a chart axis. |
| Toolbar | |
| ToolbarButton | |
| ToolbarButtons | |
| Toolbars | |
| TreeviewControl | Represents the hierarchical member-selection control of a cube field. You use this object primarily for macro recording; it is not intended for any other use. |
| Trendline | Represents a trendline in a chart. A trendline shows the trend, or direction, of data in a series. |
| Trendlines | A collection of all the Trendline objects for the specified series. Each Trendline object represents a trendline in a chart. A trendline shows the trend, or direction, of data in a series. |
| UpBars | Represents the up bars in a chart group. Up bars connect points on series one with higher values on the last series in the chart group (the lines go up from series one). |
| UsedObjects | Represents objects that have been allocated in a workbook. |
| UserAccess | Represents the user access for a protected range. |
| UserAccessList | A collection of UserAccess objects that represent the user access for protected ranges. |
| Validation | Represents data validation for a worksheet range. |
| VPageBreak | Represents a vertical page break. |
| VPageBreaks | A collection of vertical page breaks within the print area. Each vertical page break is represented by a VPageBreak object. |
| Walls | Represents the walls of a 3-D chart. |
| Watch | Represents a range which is tracked when the worksheet is recalculated. |
| Watches | A collection of all the Watch objects in a specified application. |
| WebOptions | Contains workbook-level attributes used by Microsoft Excel when you save a document as a Web page or open a Web page. |
| Window | Represents a window. Many worksheet characteristics, such as scroll bars and gridlines, are actually properties of the window. |
| Windows | A collection of all the Window objects in Microsoft Excel. |
| Workbook | Represents a Microsoft Excel workbook. |
| WorkbookEvents | |
| WorkbookEvents_Event | Events interface for Microsoft Excel Workbook object events. |
| Workbooks | A collection of all the Workbook objects that are currently open in the Microsoft Excel application. |
| Worksheet | Represents a worksheet. |
| WorksheetFunction | Used as a container for Microsoft Excel worksheet functions |
| Worksheets | A collection of all the Worksheet objects in the specified or active workbook. Each Worksheet object represents a worksheet. |
| XmlDataBinding | Represents the connection to the source data for an XmlMap object. |
| XmlMap | Represents an XML map that has been added to a workbook. |
| XmlMaps | Represents the collection of XmlMap objects that have been added to a workbook. |
| XmlNamespace | Represents a namespace that has been added to a workbook. |
| XmlNamespaces | Represents the collection of XmlNamespace objects in a workbook. |
| XmlSchema | Represents an XML schema contained by an XmlMap object. |
| XmlSchemas | Represents the collection of XmlSchema objects contained by an XmlMap object. |
| XPath | Represents an XPath that has been mapped to a Range or ListColumn object. |
Delegates
| Delegate | Description |
|---|---|
| AppEvents_NewWorkbookEventHandler | A Delegate type used to add an event handler for the NewWorkbook event. The NewWorkbook event occurs when a new workbook is created. |
| AppEvents_SheetActivateEventHandler | A Delegate type used to add an event handler for the SheetActivate event. The SheetActivate event occurs when any sheet is activated. |
| AppEvents_SheetBeforeDoubleClickEventHandler | A Delegate type used to add an event handler for the SheetBeforeDoubleClick event. The SheetBeforeDoubleClick event occurs when any worksheet is double-clicked, before the default double-click action. |
| AppEvents_SheetBeforeRightClickEventHandler | A Delegate type used to add an event handler for the SheetBeforeRightClick event. The SheetBeforeRightClick event occurs when any worksheet is right-clicked, before the default right-click action. |
| AppEvents_SheetCalculateEventHandler | A Delegate type used to add an event handler for the SheetCalculate event. The SheetCalculate event occurs after any worksheet is recalculated or after any changed data is plotted on a chart. |
| AppEvents_SheetChangeEventHandler | A Delegate type used to add an event handler for the SheetChange event. The SheetChange event occurs when cells in any worksheet are changed by the user or by an external link. |
| AppEvents_SheetDeactivateEventHandler | A Delegate type used to add an event handler for the SheetDeactivate event. The SheetDeactivate event occurs when any sheet is deactivated. |
| AppEvents_SheetFollowHyperlinkEventHandler | A Delegate type used to add an event handler for the SheetFollowHyperlink event. The SheetFollowHyperlink event occurs when you click any hyperlink in Microsoft Excel. |
| AppEvents_SheetPivotTableUpdateEventHandler | A Delegate type used to add an event handler for the SheetPivotTableUpdate event. The SheetPivotTableUpdate event occurs after the sheet of the PivotTable report has been updated. |
| AppEvents_SheetSelectionChangeEventHandler | A Delegate type used to add an event handler for the SheetSelectionChange event. The SheetSelectionChange event occurs when the selection changes on any worksheet. |
| AppEvents_WindowActivateEventHandler | A Delegate type used to add an event handler for the WindowActivate event. The WindowActivate event occurs when any workbook window is activated. |
| AppEvents_WindowDeactivateEventHandler | A Delegate type used to add an event handler for the WindowDeactivate event. The WindowDeactivate event occurs when any workbook window is deactivated. |
| AppEvents_WindowResizeEventHandler | A Delegate type used to add an event handler for the WindowResize event. The WindowResize event occurs when any workbook window is resized. |
| AppEvents_WorkbookActivateEventHandler | A Delegate type used to add an event handler for the WorkbookActivate event. The WorkbookActivate event occurs when any workbook is activated. |
| AppEvents_WorkbookAddinInstallEventHandler | A Delegate type used to add an event handler for the WorkbookAddinInstall event. The WorkbookAddinInstall event occurs when a workbook is installed as an add-in. |
| AppEvents_WorkbookAddinUninstallEventHandler | A Delegate type used to add an event handler for the WorkbookAddinUninstall event. The WorkbookAddinUninstall event occurs when any add-in workbook is uninstalled. |
| AppEvents_WorkbookAfterXmlExportEventHandler | A Delegate type used to add an event handler for the WorkbookAfterXmlExport event. The WorkbookAfterXmlExport event occurs after Microsoft Excel saves or exports data from any open workbook to an XML data file. |
| AppEvents_WorkbookAfterXmlImportEventHandler | A Delegate type used to add an event handler for the WorkbookAfterXmlImport event. The WorkbookAfterXmlImport event occurs after an existing XML data connection is refreshed, or new XML data is imported into any open Microsoft Excel workbook. |
| AppEvents_WorkbookBeforeCloseEventHandler | A Delegate type used to add an event handler for the WorkbookBeforeClose event. The WorkbookBeforeClose event occurs immediately before any open workbook closes. |
| AppEvents_WorkbookBeforePrintEventHandler | A Delegate type used to add an event handler for the WorkbookBeforePrint event. The WorkbookBeforePrint event occurs before any open workbook is printed. |
| AppEvents_WorkbookBeforeSaveEventHandler | A Delegate type used to add an event handler for the WorkbookBeforeSave event. The WorkbookBeforeSave event occurs before any open workbook is saved. |
| AppEvents_WorkbookBeforeXmlExportEventHandler | A Delegate type used to add an event handler for the WorkbookBeforeXmlExport event. The WorkbookBeforeXmlExport event occurs before Microsoft Excel saves or exports data from any open workbook to an XML data file. |
| AppEvents_WorkbookBeforeXmlImportEventHandler | A Delegate type used to add an event handler for the WorkbookBeforeXmlImport event. The WorkbookBeforeXmlImport event occurs before an existing XML data connection is refreshed, or new XML data is imported into any open Microsoft Excel workbook. |
| AppEvents_WorkbookDeactivateEventHandler | A Delegate type used to add an event handler for the WorkbookDeactivate event. The WorkbookDeactivate event occurs when any open workbook is deactivated. |
| AppEvents_WorkbookNewSheetEventHandler | A Delegate type used to add an event handler for the WorkbookNewSheet event. The WorkbookNewSheet event occurs when a new sheet is created in any open workbook. |
| AppEvents_WorkbookOpenEventHandler | A Delegate type used to add an event handler for the WorkbookOpen event. The WorkbookOpen event occurs when a workbook is opened. |
| AppEvents_WorkbookPivotTableCloseConnectionEventHandler | A Delegate type used to add an event handler for the WorkbookPivotTableCloseConnection event. The WorkbookPivotTableCloseConnection event occurs after a PivotTable report connection has been closed. |
| AppEvents_WorkbookPivotTableOpenConnectionEventHandler | A Delegate type used to add an event handler for the WorkbookPivotTableOpenConnection event. The WorkbookPivotTableOpenConnection event occurs after a PivotTable report connection has been opened. |
| AppEvents_WorkbookSyncEventHandler | A Delegate type used to add an event handler for the WorkbookSync event. The WorkbookSync event occurs when the local copy of a workbook that is part of a Document Workspace is synchronized with the copy on the server. |
| ChartEvents_ActivateEventHandler | A Delegate type used to add an event handler for the Activate event. The Activate event occurs when a chart sheet or embedded chart is activated. |
| ChartEvents_BeforeDoubleClickEventHandler | A Delegate type used to add an event handler for the BeforeDoubleClick event. The BeforeDoubleClick event occurs when an embedded chart is double-clicked, before the default double-click action. |
| ChartEvents_BeforeRightClickEventHandler | A Delegate type used to add an event handler for the BeforeRightClick event. The BeforeRightClick event occurs when an embedded chart is right-clicked, before the default right-click action. |
| ChartEvents_CalculateEventHandler | A Delegate type used to add an event handler for the Calculate event. The Calculate event occurs after the chart plots new or changed data. |
| ChartEvents_DeactivateEventHandler | A Delegate type used to add an event handler for the Deactivate event. The Deactivate event occurs when the chart is deactivated. |
| ChartEvents_DragOverEventHandler | A Delegate type used to add an event handler for the DragOver event. The DragOver event occurs when a range of cells is dragged over a chart. |
| ChartEvents_DragPlotEventHandler | A Delegate type used to add an event handler for the DragPlot event. The DragPlot event occurs when a range of cells is dragged and dropped on a chart. |
| ChartEvents_MouseDownEventHandler | A Delegate type used to add an event handler for the MouseDown event. The MouseDown event occurs when a mouse button is pressed while the pointer is over a chart. |
| ChartEvents_MouseMoveEventHandler | A Delegate type used to add an event handler for the MouseMove event. The MouseMove event occurs when the position of the mouse pointer changes over a chart. |
| ChartEvents_MouseUpEventHandler | A Delegate type used to add an event handler for the MouseUp event. The MouseUp event occurs when a mouse button is released while the pointer is over a chart. |
| ChartEvents_ResizeEventHandler | A Delegate type used to add an event handler for the Resize event. The Resize event occurs when the chart is resized. |
| ChartEvents_SelectEventHandler | A Delegate type used to add an event handler for the Select event. The Select event occurs when a chart element is selected. |
| ChartEvents_SeriesChangeEventHandler | A Delegate type used to add an event handler for the SeriesChange event. The SeriesChange event occurs when the user changes the value of a chart data point. |
| DocEvents_ActivateEventHandler | A Delegate type used to add an event handler for the Activate event. The Activate event occurs when a worksheet is activated. |
| DocEvents_BeforeDoubleClickEventHandler | A Delegate type used to add an event handler for the BeforeDoubleClick event. The BeforeDoubleClick event occurs when a worksheet is double-clicked, before the default double-click action. |
| DocEvents_BeforeRightClickEventHandler | A Delegate type used to add an event handler for the BeforeRightClick event. The BeforeRightClick event occurs when a worksheet is right-clicked, before the default right-click action. |
| DocEvents_CalculateEventHandler | A Delegate type used to add an event handler for the Calculate event. The Calculate event occurs after the worksheet is recalculated. |
| DocEvents_ChangeEventHandler | A Delegate type used to add an event handler for the Change event. The Change event occurs when cells on the worksheet are changed by the user or by an external link. |
| DocEvents_DeactivateEventHandler | A Delegate type used to add an event handler for the Deactivate event. The Deactivate event occurs when the worksheet is deactivated. |
| DocEvents_FollowHyperlinkEventHandler | A Delegate type used to add an event handler for the FollowHyperlink event. The FollowHyperlink event occurs when you click any hyperlink on a worksheet. |
| DocEvents_PivotTableUpdateEventHandler | A Delegate type used to add an event handler for the PivotTableUpdate event. The PivotTableUpdate event occurs after a PivotTable report is updated on a worksheet. |
| DocEvents_SelectionChangeEventHandler | A Delegate type used to add an event handler for the SelectionChange event. The SelectionChange event occurs when the selection changes on a worksheet. |
| OLEObjectEvents_GotFocusEventHandler | A Delegate type used to add an event handler for the GotFocus event. The GotFocus event occurs when an ActiveX control gets input focus. |
| OLEObjectEvents_LostFocusEventHandler | A Delegate type used to add an event handler for the LostFocus event. The LostFocus event occurs when an ActiveX control loses input focus. |
| RefreshEvents_AfterRefreshEventHandler | A Delegate type used to add an event handler for the AfterRefresh event. The AfterRefresh event occurs after a query is completed or canceled. |
| RefreshEvents_BeforeRefreshEventHandler | A Delegate type used to add an event handler for the BeforeRefresh event. The BeforeRefresh event occurs before any refreshes of the query table. |
| WorkbookEvents_ActivateEventHandler | A Delegate type used to add an event handler for the Activate event. The Activate event occurs when a workbook is activated. |
| WorkbookEvents_AddinInstallEventHandler | A Delegate type used to add an event handler for the AddinInstall event. The AddinInstall event occurs when the workbook is installed as an add-in. |
| WorkbookEvents_AddinUninstallEventHandler | A Delegate type used to add an event handler for the AddinUninstall event. The AddinUninstall event occurs when the workbook is uninstalled as an add-in. |
| WorkbookEvents_AfterXmlExportEventHandler | A Delegate type used to add an event handler for the AfterXmlExport event. The AfterXmlExport event occurs after Microsoft Excel saves or exports data from the specified workbook to an XML data file. |
| WorkbookEvents_AfterXmlImportEventHandler | A Delegate type used to add an event handler for the AfterXmlImport event. The AfterXmlImport event occurs after an existing XML data connection is refreshed or after new XML data is imported into the specified Microsoft Excel workbook. |
| WorkbookEvents_BeforeCloseEventHandler | A Delegate type used to add an event handler for the BeforeClose event. The BeforeClose event occurs before the workbook closes. If the workbook has been changed, this event occurs before the user is asked to save changes. |
| WorkbookEvents_BeforePrintEventHandler | A Delegate type used to add an event handler for the BeforePrint event. The BeforePrint event occurs before the workbook (or anything in it) is printed. |
| WorkbookEvents_BeforeSaveEventHandler | A Delegate type used to add an event handler for the BeforeSave event. The BeforeSave event occurs before the workbook is saved. |
| WorkbookEvents_BeforeXmlExportEventHandler | A Delegate type used to add an event handler for the BeforeXmlExport event. The BeforeXmlExport event occurs before Microsoft Excel saves or exports data from the specified workbook to an XML data file. |
| WorkbookEvents_BeforeXmlImportEventHandler | A Delegate type used to add an event handler for the BeforeXmlImport event. The BeforeXmlImport event occurs before an existing XML data connection is refreshed or before new XML data is imported into a Microsoft Excel workbook. |
| WorkbookEvents_DeactivateEventHandler | A Delegate type used to add an event handler for the Deactivate event. The Deactivate event occurs when the workbook is deactivated. |
| WorkbookEvents_NewSheetEventHandler | A Delegate type used to add an event handler for the NewSheet event. The NewSheet event occurs when a new sheet is created in the workbook. |
| WorkbookEvents_OpenEventHandler | A Delegate type used to add an event handler for the Open event. The Open event occurs when the workbook is opened. |
| WorkbookEvents_PivotTableCloseConnectionEventHandler | A Delegate type used to add an event handler for the PivotTableCloseConnection event. The PivotTableCloseConnection event occurs after a PivotTable report closes the connection to its data source. |
| WorkbookEvents_PivotTableOpenConnectionEventHandler | A Delegate type used to add an event handler for the PivotTableOpenConnection event. The PivotTableOpenConnection event occurs after a PivotTable report opens the connection to its data source. |
| WorkbookEvents_SheetActivateEventHandler | A Delegate type used to add an event handler for the SheetActivate event. The SheetActivate event occurs when any sheet is activated. |
| WorkbookEvents_SheetBeforeDoubleClickEventHandler | A Delegate type used to add an event handler for the SheetBeforeDoubleClick event. The SheetBeforeDoubleClick event occurs when any worksheet is double-clicked, before the default double-click action. |
| WorkbookEvents_SheetBeforeRightClickEventHandler | A Delegate type used to add an event handler for the SheetBeforeRightClick event. The SheetBeforeRightClick event occurs when any worksheet is right-clicked, before the default right-click action. |
| WorkbookEvents_SheetCalculateEventHandler | A Delegate type used to add an event handler for the SheetCalculate event. The SheetCalculate event occurs after any worksheet is recalculated or after any changed data is plotted on a chart. |
| WorkbookEvents_SheetChangeEventHandler | A Delegate type used to add an event handler for the SheetChange event. The SheetChange event occurs when cells in any worksheet are changed by the user or by an external link. |
| WorkbookEvents_SheetDeactivateEventHandler | A Delegate type used to add an event handler for the SheetDeactivate event. The SheetDeactivate event occurs when any sheet is deactivated. |
| WorkbookEvents_SheetFollowHyperlinkEventHandler | A Delegate type used to add an event handler for the SheetFollowHyperlink event. The SheetFollowHyperlink event occurs when you click any hyperlink in Microsoft Excel. |
| WorkbookEvents_SheetPivotTableUpdateEventHandler | A Delegate type used to add an event handler for the SheetPivotTableUpdate event. The SheetPivotTableUpdate event occurs after the sheet of the PivotTable report has been updated. |
| WorkbookEvents_SheetSelectionChangeEventHandler | A Delegate type used to add an event handler for the SheetSelectionChange event. The SheetSelectionChange event occurs when the selection changes on any worksheet (doesn't occur if the selection is on a chart sheet). |
| WorkbookEvents_SyncEventHandler | A Delegate type used to add an event handler for the Sync event. The Sync event occurs when the local copy of a worksheet that is part of a Document Workspace is synchronized with the copy on the server. |
| WorkbookEvents_WindowActivateEventHandler | A Delegate type used to add an event handler for the WindowActivate event. The WindowActivate event occurs when any workbook window is activated. |
| WorkbookEvents_WindowDeactivateEventHandler | A Delegate type used to add an event handler for the WindowDeactivate event. The WindowDeactivate event occurs when any workbook window is deactivated. |
| WorkbookEvents_WindowResizeEventHandler | A Delegate type used to add an event handler for the WindowResize event. The WindowResize event occurs when any workbook window is resized. |
Enumerations
| Enumeration | Description |
|---|---|
| Constants | Specifies global constants used in Microsoft Excel. |
| XlApplicationInternational | Specifies country/region and international settings. |
| XlApplyNamesOrder | Specifies which range name is listed first when a cell reference is replaced by a row-oriented and column-oriented range name. |
| XlArabicModes | Specifies spelling rules for the Arabic spelling checker. |
| XlArrangeStyle | Specifies how windows are arranged on the screen. |
| XlArrowHeadLength | Specifies the length of the arrowhead at the end of a line. |
| XlArrowHeadStyle | Specifies the type of arrowhead to apply to the line end. |
| XlArrowHeadWidth | Specifies the width of the arrowhead at the line end. |
| XlAutoFillType | Specifies how the target range is to be filled, based on the contents of the source range. |
| XlAutoFilterOperator | Specifies the operator to use to associate two criteria applied by a filter. |
| XlAxisCrosses | Specifies the point on the specified axis where the other axis crosses. |
| XlAxisGroup | Specifies the type of axis group. |
| XlAxisType | Specifies the axis type. |
| XlBackground | Specifies the background type for text in charts. |
| XlBarShape | Specifies the shape used with the 3-D bar or column chart. |
| XlBordersIndex | Specifies the border to be retrieved. |
| XlBorderWeight | Specifies the weight of the border around a range. |
| XlBuiltInDialog | Specifies which dialog box to display. |
| XlCalculatedMemberType | Specifies the type of a calculated member in a pivot table. |
| XlCalculation | Specifies the calculation mode. |
| XlCalculationInterruptKey | Specifies which key interrupts recalculation. |
| XlCalculationState | Specifies the calculation state of the application. |
| XlCategoryType | Specifies the type of the category axis. |
| XlCellInsertionMode | Specifies the way rows on the specified worksheet are added or deleted to accommodate the number of rows in a recordset returned by a query. |
| XlCellType | Specifies the type of cells. |
| XlChartGallery | Specifies a chart gallery. |
| XlChartItem | Specifies the type of the chart item. |
| XlChartLocation | Specifies where to relocate a chart. |
| XlChartPicturePlacement | Specifies the placement of a user-selected picture on a bar in a 3-D bar or column. |
| XlChartPictureType | Specifies how pictures are displayed on a column, bar picture chart, or legend key. |
| XlChartSplitType | Specifies the values displayed in the second chart in a pie chart or a bar of pie chart. |
| XlChartType | Specifies the chart type. |
| XlClipboardFormat | Specifies the format of an item on the Windows clipboard. |
| XlCmdType | Specifies the value of the CommandText property. |
| XlColorIndex | Specifies the color of a selected feature such as border, font, or fill. |
| XlColumnDataType | Specifies how a column is to be parsed. |
| XlCommandUnderlines | Specifies the state of the command underlines in Microsoft Excel for the Macintosh. |
| XlCommentDisplayMode | Specifies the way cells display comments and comment indicators. |
| XlConsolidationFunction | Specifies the subtotal function. |
| XlCopyPictureFormat | Specifies the format of the picture being copied. |
| XlCorruptLoad | Specifies the processing for a file when it is opened. |
| XlCreator | Specifies the 32-bit creator code for Excel for Macintosh (decimal 1480803660, Hex 5843454C, string XCEL). |
| XlCubeFieldType | Specifies whether the OLAP field is a hierarchy, set, or measure field. |
| XlCutCopyMode | Specifies whether status is Copy mode or Cut mode. |
| XlCVError | Specifies the cell error number and value. |
| XlDataLabelPosition | Specifies where the data label is positioned. |
| XlDataLabelSeparator | Specifies the separator used with data labels. |
| XlDataLabelsType | Specifies the type of data label to apply. |
| XlDataSeriesDate | Specifies the type of date to apply to a data series. |
| XlDataSeriesType | Specifies the data series to create. |
| XlDeleteShiftDirection | Specifies how to shift cells to replace deleted cells. |
| XlDirection | Specifies the direction in which to move. |
| XlDisplayBlanksAs | Specifies how blank cells are plotted on a chart. |
| XlDisplayDrawingObjects | Specifies how shapes are displayed. |
| XlDisplayUnit | Specifies the display unit label for an axis. |
| XlDVAlertStyle | Specifies the icon used in message boxes displayed during validation. |
| XlDVType | Specifies the type of validation test to be performed in conjunction with values. |
| XlEditionFormat | Specifies the format of the published edition. This is Macintosh only and should not be used. |
| XlEditionOptionsOption | This enumeration is for Macintosh only and should not be used. |
| XlEditionType | Specifies the type of edition to be changed. |
| XlEnableCancelKey | Specifies how Microsoft Excel handles CTRL+BREAK (or ESC or COMMAND+PERIOD) user interruptions to the running procedure. |
| XlEnableSelection | Specifies what can be selected on the sheet. |
| XlEndStyleCap | Specifies the end style for error bars. |
| XlErrorBarDirection | Specifies which axis values are to receive error bars. |
| XlErrorBarInclude | Specifies which error bar parts to include. |
| XlErrorBarType | Specifies the range marked by error bars. |
| XlErrorChecks | Specifies the type of error object to be retrieved from the Errors collection. |
| XlFileAccess | Specifies the new access mode for the object. |
| XlFileFormat | Specifies the file format when saving the spreadsheet. |
| XlFillWith | Specifies how to copy the range. |
| XlFilterAction | Specifies whether data is to be copied or left in place during a filter operation. |
| XlFindLookIn | Specifies the type of data to search. |
| XlFormatConditionOperator | Specifies the operator to use to compare a formula against the value in a cell or, for xlBetween and xlNotBetween, to compare two formulas. |
| XlFormatConditionType | Specifies whether the conditional format is based on a cell value or an expression. |
| XlFormControl | Specifies the type of the form control. |
| XlFormulaLabel | Specifies the formula label type for the specified range. |
| XlHAlign | Specifies the horizontal alignment for the object. |
| XlHebrewModes | Specifies the mode for the Hebrew spelling checker. |
| XlHighlightChangesTime | Specifies which set of changes is shown in a shared workbook. |
| XlHtmlType | Specifies the type of HTML generated by Microsoft Excel when you save the specified item to a Web page and whether the item is static or interactive. |
| XlIMEMode | Specifies the description of the Japanese input rules. |
| XlImportDataAs | Specifies the format in which to return data from a database. |
| XlInsertFormatOrigin | Specifies from where to copy the format for inserted rows. |
| XlInsertShiftDirection | Specifies the direction in which to shift cells during an insertion. |
| XlLayoutFormType | Specifies the way the specified PivotTable items appear—in table format or in outline format. |
| XlLegendPosition | Specifies the position of the legend on a chart. |
| XlLineStyle | Specifies the line style for the border. |
| XlLink | Specifies the type of link. |
| XlLinkInfo | Specifies the type of information to be returned. |
| XlLinkInfoType | Specifies the type of link. |
| XlLinkStatus | Specifies the status of a link. |
| XlLinkType | Specifies the type of link. |
| XlListConflict | Specifies the conflict resolution options for updating a list on a Microsoft Windows SharePoint Services site with the changes made to a list in a Microsoft Excel worksheet. |
| XlListDataType | Specifies the data type of a list column connected to a Microsoft Windows SharePoint Services site. |
| XlListObjectSourceType | Specifies the current source of the list. |
| XlLocationInTable | Specifies the part of the PivotTable report that contains the upper-left corner of a range. |
| XlLookAt | Specifies whether a match is made against the whole of the search text or any part of the search text. |
| XlMailSystem | Specifies the mail system that is installed on the host machine. |
| XlMarkerStyle | Specifies the marker style for a point or series in a line chart, scatter chart, or radar chart. |
| XlMouseButton | Specifies which mouse button was pressed. |
| XlMousePointer | Specifies the appearance of the mouse pointer in Microsoft Excel. |
| XlMSApplication | Specifies a Microsoft application. |
| XlObjectSize | Specifies the way a chart is scaled to fit on a page. |
| XlOLEType | Specifies the OLE object type. |
| XlOLEVerb | Specifies the verb that the server of the OLE object should act on. |
| XlOrder | Specifies the order in which cells are processed. |
| XlOrientation | Specifies the text orientation. |
| XlPageBreak | Specifies page break location in the worksheet. |
| XlPageBreakExtent | Specifies whether a page break is full screen or applies only within the print area. |
| XlPageOrientation | Specifies the page orientation when the worksheet is printed. |
| XlPaperSize | Specifies the size of the paper. |
| XlParameterDataType | Specifies the data type of a query parameter. |
| XlParameterType | Specifies how to determine the value of the parameter for the specified query table. |
| XlPasteSpecialOperation | Specifies how numeric data will be calculated with the destinations cells in the worksheet. |
| XlPasteType | Specifies the part of the range to be pasted. |
| XlPattern | Specifies the interior pattern of a chart or interior object. |
| XlPhoneticAlignment | Specifies the alignment for phonetic text. |
| XlPhoneticCharacterType | Specifies the type of phonetic text in a cell. |
| XlPictureAppearance | Specifies how the picture should be copied. |
| XlPictureConvertorType | Specifies how to convert a graphic. |
| XlPivotCellType | Specifies the PivotTable entity the cell corresponds to. |
| XlPivotFieldCalculation | Specifies the type of calculation performed by a data PivotField when a custom calculation is used. |
| XlPivotFieldDataType | Specifies the type of data in the PivotTable field. |
| XlPivotFieldOrientation | Specifies the location of the field in a PivotTable report. |
| XlPivotFormatType | Specifies the type of report formatting to be applied to the specified PivotTable report. |
| XlPivotTableMissingItems | Specifies the maximum number of unique items per PivotField allowed. |
| XlPivotTableSourceType | Specifies the source of the report data. |
| XlPivotTableVersionList | Specifies the Microsoft Excel version number. |
| XlPlacement | Specifies the way an object is attached to its underlying cells. |
| XlPlatform | Specifies the platform that a text file originated on. |
| XlPrintErrors | Specifies the type of print error displayed. |
| XlPrintLocation | Specifies the way comments are printed with the sheet. |
| XlPriority | Specifies the priority of a SendMailer message. |
| XlPTSelectionMode | Specifies what may be selected in a PivotTable during a structured selection. These constants may be combined to select multiple types. |
| XlQueryType | Specifies the type of query used by Microsoft Excel to populate the query table or PivotTable cache. |
| XlRangeAutoFormat | Specifies the predefined format when a range is automatically formatted. |
| XlRangeValueDataType | Specifies the range value data type. |
| XlReferenceStyle | Specifies the reference style. |
| XlReferenceType | Specifies cell reference style when a formula is being converted. |
| XlRobustConnect | Specifies how the PivotTable cache connects to its data source. |
| XlRoutingSlipDelivery | Specifies the routing delivery method. |
| XlRoutingSlipStatus | Specifies the status of the routing slip. |
| XlRowCol | Specifies whether the values corresponding to a particular data series are in rows or columns. |
| XlRunAutoMacro | Specifies the automatic macro to run. |
| XlSaveAction | Specifies during file close if the file will be saved. |
| XlSaveAsAccessMode | Specifies the access mode for the Save As function. |
| XlSaveConflictResolution | Specifies the way conflicts are to be resolved whenever a shared workbook is updated. |
| XlScaleType | Specifies the scale type of the value axis. |
| XlSearchDirection | Specifies the search direction when searching a range. |
| XlSearchOrder | Specifies the order in which to search the range. |
| XlSearchWithin | Specifies the extent of the search for the range. |
| XlSheetType | Specifies the worksheet type. |
| XlSheetVisibility | Specifies whether the object is visible. |
| XlSizeRepresents | Specifies what the bubble size represents on a bubble chart. |
| XlSmartTagControlType | Specifies the type of Smart Document control displayed in the Document Actions task pane. |
| XlSmartTagDisplayMode | Specifies the display features for smart tags. |
| XlSortDataOption | Specifies how to sort text. |
| XlSortMethod | Specifies the type of sort. |
| XlSortMethodOld | Specifies how to sort when using East Asian sorting methods. |
| XlSortOrder | Specifies the sort order for the specified field or range. |
| XlSortOrientation | Specifies the sort orientation. |
| XlSortType | Specifies which elements are to be sorted. Use this argument only when sorting PivotTable reports. |
| XlSourceType | Identifies the source object. |
| XlSpeakDirection | Specifies the order in which the cells are spoken. |
| XlSpecialCellsValue | Specifies cells with a particular type of value to include in the result. |
| XlSubscribeToFormat | Specifies the format to use when subscribing to a published edition. |
| XlSubtototalLocationType | Specifies where the subtotal will be displayed on the worksheet. |
| XlSummaryColumn | Specifies the location of the summary columns in the outline. |
| XlSummaryReportType | Specifies the type of summary to be created for scenarios. |
| XlSummaryRow | Specifies the location of the summary rows in the outline. |
| XlTabPosition | Specifies the first or last tab position. |
| XlTextParsingType | Specifies the column format for the data in the text file that you’re importing into a query table. |
| XlTextQualifier | Specifies the delimiter to use to specify text. |
| XlTextVisualLayoutType | Specifies whether the visual layout of the text being imported is left-to-right or right-to-left. |
| XlTickLabelOrientation | Specifies the text orientation for tick-mark labels. |
| XlTickLabelPosition | Specifies the position of tick-mark labels on the specified axis. |
| XlTickMark | Specifies the position of major and minor tick marks for an axis. |
| XlTimeUnit | Specifies unit of time for chart axis and data series. |
| XlToolbarProtection | Specifies which properties of a toolbar are restricted. Options may be combined using Or. |
| XlTotalsCalculation | Specifies the type of calculation in the Totals row of a list column. |
| XlTrendlineType | Specifies how the trendline that smoothes out fluctuations in the data is calculated. |
| XlUnderlineStyle | Specifies the type of underline applied to a font. |
| XlUpdateLinks | Specifies a workbook's setting for updating embedded OLE links. |
| XlVAlign | Specifies the vertical alignment for the object. |
| XlWBATemplate | Specifies the type of workbook to create. |
| XlWebFormatting | Specifies how much formatting from a Web page, if any, is applied when a Web page is imported into a query table. |
| XlWebSelectionType | Specifies whether an entire Web page, all tables on the Web page, or only a specific table is imported into a query table. |
| XlWindowState | Specifies the state of the window. |
| XlWindowType | Specifies how the chart is displayed. |
| XlWindowView | Specifies the view showing in the window. |
| XlXLMMacroType | Specifies, in a Microsoft Excel version 4 macro worksheet, what type of macro a name refers to or whether the name refers to a macro. |
| XlXmlExportResult | Specifies the results of the save or export operation. |
| XlXmlImportResult | Specifies the results of the refresh or import operation. |
| XlXmlLoadOption | Specifies how Excel opens the XML data file. |
| XlYesNoGuess | Specifies whether or not the first row contains headers. |