Sign in

Home Products Office 365 Docs Samples Downloads Training How To Support Forums

Office and SharePoint development

Office client development

Office 2010

Excel 2010

Excel 2010 Primary Interop Assembly Reference

Class Library

Microsoft.Office.Interop.Excel Namespace

_Application Interface

_Chart Interface

_Global Interface

_IOLEObject Interface

_IQueryTable Interface

_OLEObject Interface

_QueryTable Interface

_Workbook Interface

_Worksheet Interface

AboveAverage Interface

Action Interface

Actions Interface

AddIn Interface

AddIns Interface

AddIns2 Interface

Adjustments Interface

AllowEditRange Interface

AllowEditRanges Interface

AppEvents Interface

AppEvents_AfterCalculateEventHandler Delegate

AppEvents_Event Interface

AppEvents_NewWorkbookEventHandler Delegate

AppEvents_ProtectedViewWindowActivateEventHandler Delegate

AppEvents_ProtectedViewWindowBeforeCloseEventHandler Delegate

AppEvents_ProtectedViewWindowBeforeEditEventHandler Delegate

AppEvents_ProtectedViewWindowDeactivateEventHandler Delegate

AppEvents_ProtectedViewWindowOpenEventHandler Delegate

AppEvents_ProtectedViewWindowResizeEventHandler Delegate

AppEvents_SheetActivateEventHandler Delegate

AppEvents_SheetBeforeDoubleClickEventHandler Delegate

AppEvents_SheetBeforeRightClickEventHandler Delegate

AppEvents_SheetCalculateEventHandler Delegate

AppEvents_SheetChangeEventHandler Delegate

AppEvents_SheetDeactivateEventHandler Delegate

AppEvents_SheetFollowHyperlinkEventHandler Delegate

AppEvents_SheetPivotTableAfterValueChangeEventHandler Delegate

AppEvents_SheetPivotTableBeforeAllocateChangesEventHandler Delegate

AppEvents_SheetPivotTableBeforeCommitChangesEventHandler Delegate

AppEvents_SheetPivotTableBeforeDiscardChangesEventHandler Delegate

AppEvents_SheetPivotTableUpdateEventHandler Delegate

AppEvents_SheetSelectionChangeEventHandler Delegate

AppEvents_SinkHelper Class

AppEvents_WindowActivateEventHandler Delegate

AppEvents_WindowDeactivateEventHandler Delegate

AppEvents_WindowResizeEventHandler Delegate

AppEvents_WorkbookActivateEventHandler Delegate

AppEvents_WorkbookAddinInstallEventHandler Delegate

AppEvents_WorkbookAddinUninstallEventHandler Delegate

AppEvents_WorkbookAfterSaveEventHandler Delegate

AppEvents_WorkbookAfterXmlExportEventHandler Delegate

AppEvents_WorkbookAfterXmlImportEventHandler Delegate

AppEvents_WorkbookBeforeCloseEventHandler Delegate

AppEvents_WorkbookBeforePrintEventHandler Delegate

AppEvents_WorkbookBeforeSaveEventHandler Delegate

AppEvents_WorkbookBeforeXmlExportEventHandler Delegate

AppEvents_WorkbookBeforeXmlImportEventHandler Delegate

AppEvents_WorkbookDeactivateEventHandler Delegate

AppEvents_WorkbookNewChartEventHandler Delegate

AppEvents_WorkbookNewSheetEventHandler Delegate

AppEvents_WorkbookOpenEventHandler Delegate

AppEvents_WorkbookPivotTableCloseConnectionEventHandler Delegate

AppEvents_WorkbookPivotTableOpenConnectionEventHandler Delegate

AppEvents_WorkbookRowsetCompleteEventHandler Delegate

AppEvents_WorkbookSyncEventHandler Delegate

Application Interface

ApplicationClass Class

Arc Interface

Areas Interface

AutoCorrect Interface

AutoFilter Interface

AutoRecover Interface

AxisTitle Interface

Border Interface

Borders Interface

Button Interface

Buttons Interface

CalculatedFields Interface

CalculatedItems Interface

CalculatedMember Interface

CalculatedMembers Interface

CalloutFormat Interface

CellFormat Interface

Characters Interface

Chart Interface

ChartArea Interface

ChartClass Class

ChartColorFormat Interface

ChartEvents Interface

ChartEvents_ActivateEventHandler Delegate

ChartEvents_BeforeDoubleClickEventHandler Delegate

ChartEvents_BeforeRightClickEventHandler Delegate

ChartEvents_CalculateEventHandler Delegate

ChartEvents_DeactivateEventHandler Delegate

ChartEvents_DragOverEventHandler Delegate

ChartEvents_DragPlotEventHandler Delegate

ChartEvents_Event Interface

ChartEvents_MouseDownEventHandler Delegate

ChartEvents_MouseMoveEventHandler Delegate

ChartEvents_MouseUpEventHandler Delegate

ChartEvents_ResizeEventHandler Delegate

ChartEvents_SelectEventHandler Delegate

ChartEvents_SeriesChangeEventHandler Delegate

ChartEvents_SinkHelper Class

ChartFillFormat Interface

ChartFormat Interface

ChartGroup Interface

ChartGroups Interface

ChartObject Interface

ChartObjects Interface

Charts Interface

ChartTitle Interface

ChartView Interface

CheckBox Interface

CheckBoxes Interface

ColorFormat Interface

ColorScale Interface

ColorScaleCriteria Interface

ColorScaleCriterion Interface

ColorStop Interface

ColorStops Interface

Comment Interface

Comments Interface

ConditionValue Interface

Connections Interface

ConnectorFormat Interface

Constants Enumeration

ControlFormat Interface

Corners Interface

CubeField Interface

CubeFields Interface

CustomProperties Interface

CustomProperty Interface

CustomView Interface

CustomViews Interface

Databar Interface

DataBarBorder Interface

DataLabel Interface

DataLabels Interface

DataTable Interface

DefaultWebOptions Interface

Diagram Interface

DiagramNode Interface

DiagramNodeChildren Interface

DiagramNodes Interface

Dialog Interface

DialogFrame Interface

Dialogs Interface

DialogSheet Interface

DialogSheets Interface

DialogSheetView Interface

DisplayFormat Interface

DisplayUnitLabel Interface

DocEvents Interface

DocEvents_ActivateEventHandler Delegate

DocEvents_BeforeDoubleClickEventHandler Delegate

DocEvents_BeforeRightClickEventHandler Delegate

DocEvents_CalculateEventHandler Delegate

DocEvents_ChangeEventHandler Delegate

DocEvents_DeactivateEventHandler Delegate

DocEvents_Event Interface

DocEvents_FollowHyperlinkEventHandler Delegate

DocEvents_PivotTableAfterValueChangeEventHandler Delegate

DocEvents_PivotTableBeforeAllocateChangesEventHandler Delegate

DocEvents_PivotTableBeforeCommitChangesEventHandler Delegate

DocEvents_PivotTableBeforeDiscardChangesEventHandler Delegate

DocEvents_PivotTableChangeSyncEventHandler Delegate

DocEvents_PivotTableUpdateEventHandler Delegate

DocEvents_SelectionChangeEventHandler Delegate

DocEvents_SinkHelper Class

DownBars Interface

Drawing Interface

DrawingObjects Interface

Drawings Interface

DropDown Interface

DropDowns Interface

DropLines Interface

EditBox Interface

EditBoxes Interface

Error Interface

ErrorBars Interface

ErrorCheckingOptions Interface

Errors Interface

FileExportConverter Interface

FileExportConverters Interface

FillFormat Interface

Filter Interface

Filters Interface

Floor Interface

FormatColor Interface

FormatCondition Interface

FormatConditions Interface

FreeformBuilder Interface

Global Interface

GlobalClass Class

Graphic Interface

Gridlines Interface

GroupBox Interface

GroupBoxes Interface

GroupObject Interface

GroupObjects Interface

GroupShapes Interface

HeaderFooter Interface

HiLoLines Interface

HPageBreak Interface

HPageBreaks Interface

Hyperlink Interface

Hyperlinks Interface

IAboveAverage Interface

IAction Interface

IActions Interface

IAddIn Interface

IAddIns Interface

IAddIns2 Interface

IAllowEditRange Interface

IAllowEditRanges Interface

IAppEvents Interface

IArcs Interface

IAreas Interface

IAutoCorrect Interface

IAutoFilter Interface

IAutoRecover Interface

IAxes Interface

IAxis Interface

IAxisTitle Interface

IBorder Interface

IBorders Interface

IButton Interface

IButtons Interface

ICalculatedFields Interface

ICalculatedItems Interface

ICalculatedMember Interface

ICalculatedMembers Interface

ICanvasShapes Interface

ICellFormat Interface

ICharacters Interface

IChartArea Interface

IChartColorFormat Interface

IChartEvents Interface

IChartFillFormat Interface

IChartFormat Interface

IChartGroup Interface

IChartGroups Interface

IChartObject Interface

IChartObjects Interface

ICharts Interface

IChartTitle Interface

IChartView Interface

ICheckBox Interface

ICheckBoxes Interface

IColorScale Interface

IColorScaleCriteria Interface

IColorScaleCriterion Interface

IColorStop Interface

IColorStops Interface

IComment Interface

IComments Interface

IconCriteria Interface

IconCriterion Interface

IConditionValue Interface

IConnections Interface

IConnectorFormat Interface

IconSet Interface

IconSetCondition Interface

IconSets Interface

IControlFormat Interface

ICorners Interface

ICustomProperties Interface

ICustomProperty Interface

ICustomView Interface

ICustomViews Interface

IDatabar Interface

IDataBarBorder Interface

IDataLabel Interface

IDataLabels Interface

IDataTable Interface

IDiagram Interface

IDialog Interface

IDialogFrame Interface

IDialogs Interface

IDialogSheet Interface

IDialogSheets Interface

IDialogSheetView Interface

IDisplayFormat Interface

IDisplayUnitLabel Interface

IDocEvents Interface

IDownBars Interface

IDrawing Interface

IDrawingObjects Interface

IDrawings Interface

IDropDown Interface

IDropDowns Interface

IDropLines Interface

IDummy Interface

IEditBox Interface

IEditBoxes Interface

IError Interface

IErrorBars Interface

IErrorCheckingOptions Interface

IErrors Interface

IFileExportConverter Interface

IFileExportConverters Interface

IFilter Interface

IFilters Interface

IFloor Interface

IFont Interface

IFormatColor Interface

IFormatCondition Interface

IFormatConditions Interface

IFreeformBuilder Interface

IGraphic Interface

IGridlines Interface

IGroupBox Interface

IGroupBoxes Interface

IGroupObject Interface

IGroupObjects Interface

IGroupShapes Interface

IHeaderFooter Interface

IHiLoLines Interface

IHPageBreak Interface

IHPageBreaks Interface

IHyperlink Interface

IHyperlinks Interface

IIcon Interface

IIconCriteria Interface

IIconCriterion Interface

IIconSet Interface

IIconSetCondition Interface

IIconSets Interface

IInterior Interface

ILabel Interface

ILabels Interface

ILeaderLines Interface

ILegend Interface

ILegendEntries Interface

ILegendEntry Interface

ILegendKey Interface

ILine Interface

ILinearGradient Interface

ILines Interface

ILinkFormat Interface

IListBox Interface

IListBoxes Interface

IListColumn Interface

IListColumns Interface

IListDataFormat Interface

IListObject Interface

IListObjects Interface

IListRow Interface

IListRows Interface

IMailer Interface

IMenu Interface

IMenuBar Interface

IMenuBars Interface

IMenuItem Interface

IMenuItems Interface

IMenus Interface

IModule Interface

IModules Interface

IModuleView Interface

IMultiThreadedCalculation Interface

IName Interface

INames Interface

INegativeBarFormat Interface

Interior Interface

IODBCConnection Interface

IODBCError Interface

IODBCErrors Interface

IOLEDBConnection Interface

IOLEDBError Interface

IOLEDBErrors Interface

IOLEFormat Interface

IOLEObjectEvents Interface

IOLEObjects Interface

IOptionButton Interface

IOptionButtons Interface

IOutline Interface

IOval Interface

IOvals Interface

IPage Interface

IPages Interface

IPageSetup Interface

IPane Interface

IPanes Interface

IParameter Interface

IParameters Interface

IPhonetic Interface

IPhonetics Interface

IPicture Interface

IPictures Interface

IPivotAxis Interface

IPivotCache Interface

IPivotCaches Interface

IPivotCell Interface

IPivotField Interface

IPivotFields Interface

IPivotFilter Interface

IPivotFilters Interface

IPivotFormula Interface

IPivotFormulas Interface

IPivotItem Interface

IPivotItemList Interface

IPivotItems Interface

IPivotLayout Interface

IPivotLine Interface

IPivotLineCells Interface

IPivotLines Interface

IPivotTable Interface

IPivotTableChangeList Interface

IPivotTables Interface

IPlotArea Interface

IPoint Interface

IPoints Interface

IProtectedViewWindow Interface

IProtectedViewWindows Interface

IProtection Interface

IPublishObjects Interface

IQueryTables Interface

IRange Interface

IRanges Interface

IRecentFile Interface

IRecentFiles Interface

IRectangle Interface

IRectangles Interface

IRectangularGradient Interface

IRefreshEvents Interface

IResearch Interface

IRoutingSlip Interface

IRtdServer Interface

IRTDUpdateEvent Interface

IScenario Interface

IScenarios Interface

IScrollBar Interface

IScrollBars Interface

ISeries Interface

ISeriesCollection Interface

ISeriesLines Interface

IServerViewableItems Interface

IShape Interface

IShapeRange Interface

IShapes Interface

ISheetViews Interface

ISlicer Interface

ISlicerCache Interface

ISlicerCacheLevel Interface

ISlicerCacheLevels Interface

ISlicerCaches Interface

ISlicerItem Interface

ISlicerItems Interface

ISlicerPivotTables Interface

ISlicers Interface

ISmartTag Interface

ISmartTagAction Interface

ISmartTagActions Interface

ISmartTagOptions Interface

ISmartTagRecognizer Interface

ISmartTagRecognizers Interface

ISmartTags Interface

ISort Interface

ISortField Interface

ISortFields Interface

ISoundNote Interface

ISparkAxes Interface

ISparkColor Interface

ISparkHorizontalAxis Interface

ISparkline Interface

ISparklineGroup Interface

ISparklineGroups Interface

ISparkPoints Interface

ISparkVerticalAxis Interface

ISpeech Interface

ISpellingOptions Interface

ISpinner Interface

ISpinners Interface

IStyle Interface

IStyles Interface

ITableStyle Interface

ITableStyleElement Interface

ITableStyleElements Interface

ITableStyles Interface

ITextBox Interface

ITextBoxes Interface

ITextFrame Interface

ITickLabels Interface

IToolbar Interface

IToolbarButton Interface

IToolbarButtons Interface

IToolbars Interface

ITop10 Interface

ITrendline Interface

ITrendlines Interface

IUniqueValues Interface

IUpBars Interface

IUsedObjects Interface

IUserAccess Interface

IUserAccessList Interface

IValidation Interface

IValueChange Interface

IVPageBreak Interface

IVPageBreaks Interface

IWalls Interface

IWatch Interface

IWatches Interface

IWindow Interface

IWindows Interface

IWorkbookConnection Interface

IWorkbookEvents Interface

IWorksheetFunction Interface

IWorksheets Interface

IWorksheetView Interface

IXmlDataBinding Interface

IXmlMap Interface

IXmlMaps Interface

IXmlNamespace Interface

IXmlNamespaces Interface

IXmlSchema Interface

IXmlSchemas Interface

IXPath Interface

Label Interface

Labels Interface

LeaderLines Interface

Legend Interface

LegendEntries Interface

LegendEntry Interface

LegendKey Interface

LinearGradient Interface

LineFormat Interface

Lines Interface

LinkFormat Interface

ListBox Interface

ListBoxes Interface

ListColumn Interface

ListColumns Interface

ListDataFormat Interface

ListObject Interface

ListObjects Interface

ListRow Interface

ListRows Interface

Mailer Interface

MenuBar Interface

MenuBars Interface

MenuItem Interface

MenuItems Interface

Menus Interface

Module Interface

Modules Interface

ModuleView Interface

MultiThreadedCalculation Interface

Names Interface

NegativeBarFormat Interface

ODBCConnection Interface

ODBCError Interface

ODBCErrors Interface

OLEDBConnection Interface

OLEDBError Interface

OLEDBErrors Interface

OLEFormat Interface

OLEObject Interface

OLEObjectClass Class

OLEObjectEvents Interface

OLEObjectEvents_Event Interface

OLEObjectEvents_GotFocusEventHandler Delegate

OLEObjectEvents_LostFocusEventHandler Delegate

OLEObjectEvents_SinkHelper Class

OLEObjects Interface

OptionButton Interface

OptionButtons Interface

Outline Interface

Ovals Interface

Pages Interface

PageSetup Interface

Panes Interface

Parameter Interface

Parameters Interface

Phonetic Interface

Phonetics Interface

Picture Interface

PictureFormat Interface

Pictures Interface

PivotAxis Interface

PivotCache Interface

PivotCaches Interface

PivotCell Interface

PivotField Interface

PivotFields Interface

PivotFilter Interface

PivotFilters Interface

PivotFormula Interface

PivotFormulas Interface

PivotItem Interface

PivotItemList Interface

PivotItems Interface

PivotLayout Interface

PivotLine Interface

PivotLineCells Interface

PivotLines Interface

PivotTable Interface

PivotTableChangeList Interface

PivotTables Interface

PlotArea Interface

Point Interface

Points Interface

ProtectedViewWindow Interface

ProtectedViewWindows Interface

Protection Interface

PublishObject Interface

PublishObjects Interface

QueryTable Interface

QueryTableClass Class

QueryTables Interface

Range Interface

Ranges Interface

RecentFile Interface

RecentFiles Interface

Rectangle Interface

Rectangles Interface

RectangularGradient Interface

RefreshEvents Interface

RefreshEvents_AfterRefreshEventHandler Delegate

RefreshEvents_BeforeRefreshEventHandler Delegate

RefreshEvents_Event Interface

RefreshEvents_SinkHelper Class

Research Interface

RoutingSlip Interface

RTD Interface

Scenario Interface

Scenarios Interface

ScrollBar Interface

ScrollBars Interface

Series Interface

SeriesCollection Interface

SeriesLines Interface

ServerViewableItems Interface

ShadowFormat Interface

Shape Interface

ShapeNode Interface

ShapeNodes Interface

ShapeRange Interface

Shapes Interface

Sheets Interface

SheetViews Interface

Slicer Interface

SlicerCache Interface

SlicerCacheLevel Interface

SlicerCacheLevels Interface

SlicerCaches Interface

SlicerItem Interface

SlicerItems Interface

SlicerPivotTables Interface

Slicers Interface

SmartTag Interface

SmartTagAction Interface

SmartTagActions Interface

SmartTagOptions Interface

SmartTagRecognizer Interface

SmartTagRecognizers Interface

SmartTags Interface

SortField Interface

SortFields Interface

SoundNote Interface

SparkAxes Interface

SparkColor Interface

SparkHorizontalAxis Interface

Sparkline Interface

SparklineGroup Interface

SparklineGroups Interface

SparkPoints Interface

SparkVerticalAxis Interface

Speech Interface

SpellingOptions Interface

Spinner Interface

Spinners Interface

Style Interface

Styles Interface

Tab Interface

TableStyle Interface

TableStyleElement Interface

TableStyleElements Interface

TableStyles Interface

TextBox Interface

TextBoxes Interface

TextEffectFormat Interface

TextFrame Interface

TextFrame2 Interface

ThreeDFormat Interface

TickLabels Interface

Toolbar Interface

ToolbarButton Interface

ToolbarButtons Interface

Toolbars Interface

Top10 Interface

TreeviewControl Interface

Trendline Interface

Trendlines Interface

UniqueValues Interface

UpBars Interface

UsedObjects Interface

UserAccess Interface

UserAccessList Interface

Validation Interface

ValueChange Interface

VPageBreak Interface

VPageBreaks Interface

Walls Interface

Watch Interface

Watches Interface

WebOptions Interface

Window Interface

Windows Interface

Workbook Interface

WorkbookClass Class

WorkbookConnection Interface

WorkbookEvents Interface

WorkbookEvents_ActivateEventHandler Delegate

WorkbookEvents_AddinInstallEventHandler Delegate

WorkbookEvents_AddinUninstallEventHandler Delegate

WorkbookEvents_AfterSaveEventHandler Delegate

WorkbookEvents_AfterXmlExportEventHandler Delegate

WorkbookEvents_AfterXmlImportEventHandler Delegate

WorkbookEvents_BeforeCloseEventHandler Delegate

WorkbookEvents_BeforePrintEventHandler Delegate

WorkbookEvents_BeforeSaveEventHandler Delegate

WorkbookEvents_BeforeXmlExportEventHandler Delegate

WorkbookEvents_BeforeXmlImportEventHandler Delegate

WorkbookEvents_DeactivateEventHandler Delegate

WorkbookEvents_Event Interface

WorkbookEvents_NewChartEventHandler Delegate

WorkbookEvents_NewSheetEventHandler Delegate

WorkbookEvents_OpenEventHandler Delegate

WorkbookEvents_PivotTableCloseConnectionEventHandler Delegate

WorkbookEvents_PivotTableOpenConnectionEventHandler Delegate

WorkbookEvents_RowsetCompleteEventHandler Delegate

WorkbookEvents_SheetActivateEventHandler Delegate

WorkbookEvents_SheetBeforeDoubleClickEventHandler Delegate

WorkbookEvents_SheetBeforeRightClickEventHandler Delegate

WorkbookEvents_SheetCalculateEventHandler Delegate

WorkbookEvents_SheetChangeEventHandler Delegate

WorkbookEvents_SheetDeactivateEventHandler Delegate

WorkbookEvents_SheetFollowHyperlinkEventHandler Delegate

WorkbookEvents_SheetPivotTableAfterValueChangeEventHandler Delegate

WorkbookEvents_SheetPivotTableBeforeAllocateChangesEventHandler Delegate

WorkbookEvents_SheetPivotTableBeforeCommitChangesEventHandler Delegate

WorkbookEvents_SheetPivotTableBeforeDiscardChangesEventHandler Delegate

WorkbookEvents_SheetPivotTableChangeSyncEventHandler Delegate

WorkbookEvents_SheetPivotTableUpdateEventHandler Delegate

WorkbookEvents_SheetSelectionChangeEventHandler Delegate

WorkbookEvents_SinkHelper Class

WorkbookEvents_SyncEventHandler Delegate

WorkbookEvents_WindowActivateEventHandler Delegate

WorkbookEvents_WindowDeactivateEventHandler Delegate

WorkbookEvents_WindowResizeEventHandler Delegate

Workbooks Interface

Worksheet Interface

WorksheetClass Class

WorksheetFunction Interface

Worksheets Interface

WorksheetView Interface

XlAboveBelow Enumeration

XlActionType Enumeration

XlAllocation Enumeration

XlAllocationMethod Enumeration

XlAllocationValue Enumeration

XlApplicationInternational Enumeration

XlApplyNamesOrder Enumeration

XlArabicModes Enumeration

XlArrangeStyle Enumeration

XlArrowHeadLength Enumeration

XlArrowHeadStyle Enumeration

XlArrowHeadWidth Enumeration

XlAutoFillType Enumeration

XlAutoFilterOperator Enumeration

XlAxisCrosses Enumeration

XlAxisGroup Enumeration

XlAxisType Enumeration

XlBackground Enumeration

XlBarShape Enumeration

XlBordersIndex Enumeration

XlBorderWeight Enumeration

XlBuiltInDialog Enumeration

XlCalcFor Enumeration

XlCalculatedMemberType Enumeration

XlCalculation Enumeration

XlCalculationInterruptKey Enumeration

XlCalculationState Enumeration

XlCategoryType Enumeration

XlCellChangedState Enumeration

XlCellInsertionMode Enumeration

XlCellType Enumeration

XlChartElementPosition Enumeration

XlChartGallery Enumeration

XlChartItem Enumeration

XlChartLocation Enumeration

XlChartPicturePlacement Enumeration

XlChartPictureType Enumeration

XlChartSplitType Enumeration

XlChartType Enumeration

XlCheckInVersionType Enumeration

XlClipboardFormat Enumeration

XlCmdType Enumeration

XlColorIndex Enumeration

XlColumnDataType Enumeration

XlCommandUnderlines Enumeration

XlCommentDisplayMode Enumeration

XlConditionValueTypes Enumeration

XlConnectionType Enumeration

XlConsolidationFunction Enumeration

XlContainsOperator Enumeration

XlCopyPictureFormat Enumeration

XlCorruptLoad Enumeration

XlCreator Enumeration

XlCredentialsMethod Enumeration

XlCubeFieldSubType Enumeration

XlCubeFieldType Enumeration

XlCutCopyMode Enumeration

XlCVError Enumeration

XlDataBarAxisPosition Enumeration

XlDataBarBorderType Enumeration

XlDataBarFillType Enumeration

XlDataBarNegativeColorType Enumeration

XlDataLabelPosition Enumeration

XlDataLabelSeparator Enumeration

XlDataLabelsType Enumeration

XlDataSeriesDate Enumeration

XlDataSeriesType Enumeration

XlDeleteShiftDirection Enumeration

XlDirection Enumeration

XlDisplayBlanksAs Enumeration

XlDisplayDrawingObjects Enumeration

XlDisplayUnit Enumeration

XlDupeUnique Enumeration

XlDVAlertStyle Enumeration

XlDVType Enumeration

XlDynamicFilterCriteria Enumeration

XlEditionFormat Enumeration

XlEditionOptionsOption Enumeration

XlEditionType Enumeration

XlEnableCancelKey Enumeration

XlEnableSelection Enumeration

XlEndStyleCap Enumeration

XlErrorBarDirection Enumeration

XlErrorBarInclude Enumeration

XlErrorBarType Enumeration

XlErrorChecks Enumeration

XlFileAccess Enumeration

XlFileFormat Enumeration

XlFileValidationPivotMode Enumeration

XlFillWith Enumeration

XlFilterAction Enumeration

XlFilterAllDatesInPeriod Enumeration

XlFindLookIn Enumeration

XlFixedFormatQuality Enumeration

XlFixedFormatType Enumeration

XlFormatConditionOperator Enumeration

XlFormatConditionType Enumeration

XlFormatFilterTypes Enumeration

XlFormControl Enumeration

XlFormulaLabel Enumeration

XlGenerateTableRefs Enumeration

XlGradientFillType Enumeration

XlHAlign Enumeration

XlHebrewModes Enumeration

XlHighlightChangesTime Enumeration

XlHtmlType Enumeration

XlIcon Enumeration

XlIconSet Enumeration

XlIMEMode Enumeration

XlImportDataAs Enumeration

XlInsertFormatOrigin Enumeration

XlInsertShiftDirection Enumeration

XlLayoutFormType Enumeration

XlLayoutRowType Enumeration

XlLegendPosition Enumeration

XlLineStyle Enumeration

XlLink Enumeration

XlLinkInfo Enumeration

XlLinkInfoType Enumeration

XlLinkStatus Enumeration

XlLinkType Enumeration

XlListConflict Enumeration

XlListDataType Enumeration

XlListObjectSourceType Enumeration

XlLocationInTable Enumeration

XlLookAt Enumeration

XlLookFor Enumeration

XlMailSystem Enumeration

XlMarkerStyle Enumeration

XlMeasurementUnits Enumeration

XlMouseButton Enumeration

XlMousePointer Enumeration

XlMSApplication Enumeration

XlOartHorizontalOverflow Enumeration

XlOartVerticalOverflow Enumeration

XlObjectSize Enumeration

XlOLEType Enumeration

XlOLEVerb Enumeration

XlOrder Enumeration

XlOrientation Enumeration

XlPageBreak Enumeration

XlPageBreakExtent Enumeration

XlPageOrientation Enumeration

XlPaperSize Enumeration

XlParameterDataType Enumeration

XlParameterType Enumeration

XlPasteSpecialOperation Enumeration

XlPasteType Enumeration

XlPattern Enumeration

XlPhoneticAlignment Enumeration

XlPhoneticCharacterType Enumeration

XlPictureAppearance Enumeration

XlPictureConvertorType Enumeration

XlPieSliceIndex Enumeration

XlPieSliceLocation Enumeration

XlPivotCellType Enumeration

XlPivotConditionScope Enumeration

XlPivotFieldCalculation Enumeration

XlPivotFieldDataType Enumeration

XlPivotFieldOrientation Enumeration

XlPivotFieldRepeatLabels Enumeration

XlPivotFilterType Enumeration

XlPivotFormatType Enumeration

XlPivotLineType Enumeration

XlPivotTableMissingItems Enumeration

XlPivotTableSourceType Enumeration

XlPivotTableVersionList Enumeration

XlPlacement Enumeration

XlPlatform Enumeration

XlPortugueseReform Enumeration

XlPrintErrors Enumeration

XlPrintLocation Enumeration

XlPriority Enumeration

XlPropertyDisplayedIn Enumeration

XlProtectedViewCloseReason Enumeration

XlProtectedViewWindowState Enumeration

XlPTSelectionMode Enumeration

XlQueryType Enumeration

XlRangeAutoFormat Enumeration

XlRangeValueDataType Enumeration

XlReferenceStyle Enumeration

XlReferenceType Enumeration

XlRemoveDocInfoType Enumeration

XlRgbColor Enumeration

XlRobustConnect Enumeration

XlRoutingSlipDelivery Enumeration

XlRoutingSlipStatus Enumeration

XlRowCol Enumeration

XlRunAutoMacro Enumeration

XlSaveAction Enumeration

XlSaveAsAccessMode Enumeration

XlSaveConflictResolution Enumeration

XlScaleType Enumeration

XlSearchDirection Enumeration

XlSearchOrder Enumeration

XlSearchWithin Enumeration

XlSheetType Enumeration

XlSheetVisibility Enumeration

XlSizeRepresents Enumeration

XlSlicerCrossFilterType Enumeration

XlSlicerSort Enumeration

XlSmartTagControlType Enumeration

XlSmartTagDisplayMode Enumeration

XlSortDataOption Enumeration

XlSortMethod Enumeration

XlSortMethodOld Enumeration

XlSortOn Enumeration

XlSortOrder Enumeration

XlSortOrientation Enumeration

XlSortType Enumeration

XlSourceType Enumeration

XlSpanishModes Enumeration

XlSparklineRowCol Enumeration

XlSparkScale Enumeration

XlSparkType Enumeration

XlSpeakDirection Enumeration

XlSpecialCellsValue Enumeration

XlStdColorScale Enumeration

XlSubscribeToFormat Enumeration

XlSubtototalLocationType Enumeration

XlSummaryColumn Enumeration

XlSummaryReportType Enumeration

XlSummaryRow Enumeration

XlTableStyleElementType Enumeration

XlTabPosition Enumeration

XlTextParsingType Enumeration

XlTextQualifier Enumeration

XlTextVisualLayoutType Enumeration

XlThemeColor Enumeration

XlThemeFont Enumeration

XlThreadMode Enumeration

XlTickLabelOrientation Enumeration

XlTickLabelPosition Enumeration

XlTickMark Enumeration

XlTimePeriods Enumeration

XlTimeUnit Enumeration

XlToolbarProtection Enumeration

XlTopBottom Enumeration

XlTotalsCalculation Enumeration

XlTrendlineType Enumeration

XlUnderlineStyle Enumeration

XlUpdateLinks Enumeration

XlVAlign Enumeration

XlWBATemplate Enumeration

XlWebFormatting Enumeration

XlWebSelectionType Enumeration

XlWindowState Enumeration

XlWindowType Enumeration

XlWindowView Enumeration

XlXLMMacroType Enumeration

XlXmlExportResult Enumeration

XlXmlImportResult Enumeration

XlXmlLoadOption Enumeration

XlYesNoGuess Enumeration

XmlDataBinding Interface

XmlMap Interface

XmlMaps Interface

XmlNamespace Interface

XmlNamespaces Interface

XmlSchema Interface

XmlSchemas Interface

XPath Interface

Minimize

This topic has not yet been rated - Rate this topic

XlDataBarAxisPosition Enumeration

Office 2010

Specifies the axis position for a range of cells with conditional formatting as data bars.

Namespace: Microsoft.Office.Interop.Excel
Assembly: Microsoft.Office.Interop.Excel (in Microsoft.Office.Interop.Excel.dll)

public enum XlDataBarAxisPosition

	Member name	Description
	xlDataBarAxisAutomatic	Display the axis at a variable position based on the ratio of the minimum negative value to the maximum positive value in the range. Positive values are displayed in a left-to-right direction. Negative values are displayed in a right-to-left direction. When all values are positive or all values are negative, no axis is displayed.
	xlDataBarAxisMidpoint	Display the axis at the midpoint of the cell regardless of the set of values in the range. Positive values are displayed in a left-to-right direction. Negative values are displayed in a right-to-left direction.
	xlDataBarAxisNone	No axis is displayed, and both positive and negative values are displayed in the left-to-right direction.

Reference

Microsoft.Office.Interop.Excel Namespace

Did you find this helpful? Yes No

Not accurate

Not enough depth

Need more code examples

(1500 characters remaining)

Community Additions

© 2013 Microsoft. All rights reserved.