英語版から項目を採取

Excelのオブジェクトの数は多くキャッシュではとれないため、まず項目を英語版のDOCSからとることにした。

Office VBA Reference

Excel

Concepts

Object model

Graph Visual Basic reference

Concepts 概念

About the PowerPivot Model object in Excel

About coauthoring

Language-specific properties, methods, and functions

OLE DB for OLAP properties used by Excel

Programming for the single document interface in Excel

Functions

Use the Solver VBA functions

SolverAdd function

SolverChange function

SolverDelete function

SolverFinish function

SolverFinishDialog function

SolverGet function

SolverLoad function

SolverOk function

SolverOkDialog function

SolverOptions function

SolverReset function

SolverSave function

SolverSolve function

Workbooks and worksheets

Add a table of contents to a workbook

Create address labels from a spreadsheet

Create a scheduling calendar workbook

Create a workbook

Create or replace a worksheet

Name a worksheet by using a cell value

Refer to more than one sheet

Refer to sheets by index number

Refer to sheets by name

Sort worksheets alphanumerically by name

Open a workbook

Save documents as web pages

Formatting and VBA codes for headers and footers

Return an object from a collection

Cells and ranges

Create an HTML file with a table of contents based on cell data

Delete duplicate entries in a range

Fill a value down into blank cells in a column

Hide and unhide columns

Highlight the active cell, row, or column

Make a cell blink

Prevent duplicate entries in a range

Reference cells and ranges

Refer to all the cells on the worksheet

Refer to cells and ranges by using A1 notation

Refer to cells by using a Range object

Refer to cells by using index numbers

Refer to cells by using shortcut notation

Refer to cells relative to other cells

Refer to multiple ranges

Refer to named ranges

Refer to rows and columns

Select a range

Loop through a range of cells

Select and activate cells

Work with 3-D ranges

Work with the active cell

Cell error values

Controls, dialog boxes, and forms

Add a unique list of values to a combo box

Add controls to a document

Add controls to a user form

Automatically dismiss a message box

Create a custom dialog box

Create a custom menu that calls a macro

Create a user form

ActiveX Controls

Use ActiveX Controls on sheets

Use ActiveX Controls on a document

Built-in dialog box argument lists

Use control values while code is running

Display a custom dialog box

Initialize control properties

Set control properties

Events, worksheet functions, and shapes

Chart object events

Control and dialog box events

QueryTable object events

Worksheet object events

Use events with Excel objects

Use Excel worksheet functions in Visual Basic

Working with shapes (drawing objects)

List of worksheet functions available to Visual Basic

List of worksheet functions that support long strings

Use events with embedded charts

Use events with the Application object

Use events with the QueryTable object

Invalid procedure name error

Working with other applications

Control one Office application from another

Export a chart to a Word document

Export a range to a table in a Word document

Export a table to a Word document

Import Outlook Contacts to a worksheet

Send email to a list of recipients using Excel and Outlook

Sparklines

Animate a sparkline

Change the color of the horizontal axis of a sparkline

Find all the sparklines on a sheet

Excel performance

Improve calculation performance

Performance and limit improvements

Tips for optimizing performance obstructions

Object Model 304

AboveAverage object

Action object

Actions object

AddIn object

AddIns object

AddIns2 object

Adjustments object

AllowEditRange object

AllowEditRanges object

Application object

Areas object

AutoCorrect object

AutoFilter object

AutoRecover object

Axes object

Axis object

AxisTitle object

Border object

Borders object

CalculatedFields object

CalculatedItems object

CalculatedMember object

CalculatedMembers object

CalloutFormat object

CategoryCollection object

CellFormat object

Characters object

Chart object

ChartArea object

ChartCategory object

ChartFormat object

ChartGroup object

ChartGroups object

ChartObject object

ChartObjects object

Charts object

ChartTitle object

ChartView object

ColorFormat object

ColorScale object

ColorScaleCriteria object

ColorScaleCriterion object

ColorStop object

ColorStops object

Comment object(Office Solo 365 Version 1936よりいきなり名前をメモに変えられる)

Comments object

CommentThreaded object(Office Solo 365 Version 1936)

Commentshreaded object(Office Solo 365 Version 1936)

ConditionValue object

Connections object

ConnectorFormat object

ControlFormat object

CubeField object

CubeFields object

CustomProperties object

CustomProperty object

CustomView object

CustomViews object

Databar object

DataBarBorder object

DataFeedConnection object

DataLabel object

DataLabels object

DataTable object

DefaultWebOptions object

Dialog object

Dialogs object

DialogSheetView object

DisplayFormat object

DisplayUnitLabel object

DownBars object

DropLines object

Error object

ErrorBars object

ErrorCheckingOptions object

Errors object

FileExportConverter object

FileExportConverters object

FillFormat object

Filter object

Filters object

Floor object

Font object

FormatColor object

FormatCondition object

FormatConditions object

FreeformBuilder object

FullSeriesCollection object

Graphic object

Gridlines object

GroupShapes object

HeaderFooter object

HiLoLines object

HPageBreak object

HPageBreaks object

Hyperlink object

Hyperlinks object

Icon object

IconCriteria object

IconCriterion object

IconSet object

IconSetCondition object

IconSets object

Interior object

IRtdServer object

IRTDUpdateEvent object

LeaderLines object

Legend object

LegendEntries object

LegendEntry object

LegendKey object

LinearGradient object

LineFormat object

LinkFormat object

ListColumn object

ListColumns object

ListDataFormat object

ListObject object

ListObjects object

ListRow object

ListRows object

Mailer object

ModelChanges object

ModelColumnChange object

ModelColumnChanges object

ModelColumnName object

ModelColumnNames object

ModelConnection object

ModelFormatBoolean object

ModelFormatCurrency object

ModelFormatDate object

ModelFormatDecimalNumber object

ModelFormatGeneral object

ModelFormatPercentageNumber object

ModelFormatScientificNumber object

ModelFormatWholeNumber object

ModelMeasure object

ModelMeasureName object

ModelMeasureNames object

ModelMeasures object

ModelRelationship object

ModelRelationships object

ModelTable object

ModelTableColumn object

ModelTableColumns object

ModelTableNameChange object

ModelTableNameChanges object

ModelTableNames object

ModelTables object

ModuleView object

MultiThreadedCalculation object

Name object

Names object

NegativeBarFormat object

ODBCConnection object

ODBCError object

ODBCErrors object

OLEDBConnection object

OLEDBError object

OLEDBErrors object

OLEFormat object

OLEObject object

OLEObjects object

Outline object

Page object

Pages object

PageSetup object

Pane object

Panes object

Parameter object

Parameters object

Phonetic object

Phonetics object

PictureFormat object

PivotAxis object

PivotCache object

PivotCaches object

PivotCell object

PivotField object

PivotFields object

PivotFilter object

PivotFilters object

PivotFormula object

PivotFormulas object

PivotItem object

PivotItemList object

PivotItems object

PivotLayout object

PivotLine object

PivotLineCells object

PivotLines object

PivotTable object

PivotTableChangeList object

PivotTables object

PivotValueCell object

PlotArea object

Point object

Points object

ProtectedViewWindow object

ProtectedViewWindows object

Protection object

PublishObject object

PublishObjects object

Queries object

QueryTable object

QueryTables object

QuickAnalysis object

Range object

Ranges object

RecentFile object

RecentFiles object

RectangularGradient object

Research object

RoutingSlip object

RTD object

Scenario object

Scenarios object

Series object

SeriesCollection object

SeriesLines object

ServerViewableItems object

ShadowFormat object

Shape object

ShapeNode object

ShapeNodes object

ShapeRange object

Shapes object

Sheets object

SheetViews object

Slicer object

SlicerCache object

SlicerCacheLevel object

SlicerCacheLevels object

SlicerCaches object

SlicerItem object

SlicerItems object

SlicerPivotTables object

Slicers object

Sort object

SortField object

SortFields object

SparkAxes object

SparkColor object

SparkHorizontalAxis object

Sparkline object

SparklineGroup object

SparklineGroups object

SparkPoints object

SparkVerticalAxis object

Speech object

SpellingOptions object

Style object

Styles object

Tab object

TableObject object

TableStyle object

TableStyleElement object

TableStyleElements object

TableStyles object

TextConnection object

TextEffectFormat object

TextFrame object

TextFrame2 object

ThreeDFormat object

TickLabels object

TimelineState object

TimelineViewState object

Top10 object

TreeviewControl object

Trendline object

Trendlines object

UniqueValues object

UpBars object

UsedObjects object

UserAccess object

UserAccessList object

Validation object

ValueChange object

VPageBreak object

VPageBreaks object

Walls object

Watch object

Watches object

WebOptions object

Window object

Windows object

Workbook object

WorkbookConnection object

WorkbookQuery object

Workbooks object

Worksheet object

WorksheetDataConnection object

WorksheetFunction object

Worksheets object

WorksheetView object

XmlDataBinding object

XmlMap object

XmlMaps object

XmlNamespace object

XmlNamespaces object

XmlSchema object

XmlSchemas object

XPath object

Enumerations(269)

Constants

XlAboveBelow

XlActionType

XlAllocation

XlAllocationMethod

XlAllocationValue

XlApplicationInternational

XlApplyNamesOrder

XlArabicModes

XlArrangeStyle

XlArrowHeadLength

XlArrowHeadStyle

XlArrowHeadWidth

XlAutoFillType

XlAutoFilterOperator

XlAxisCrosses

XlAxisGroup

XlAxisType

XlBackground

XlBarShape

XlBinsType

XlBordersIndex

XlBorderWeight

XlBuiltInDialog

XlCalcFor

XlCalcMemNumberFormatType

XlCalculatedMemberType

XlCalculation

XlCalculationInterruptKey

XlCalculationState

XlCategoryLabelLevel

XlCategoryType

XlCellChangedState

XlCellInsertionMode

XlCellType

XlChartElementPosition

XlChartGallery

XlChartItem

XlChartLocation

XlChartPicturePlacement

XlChartPictureType

XlChartSplitType

XlChartType

XlCheckInVersionType

XlClipboardFormat

XlCmdType

XlColorIndex

XlColumnDataType

XlCommandUnderlines

XlCommentDisplayMode

XlConditionValueTypes

XlConnectionType

XlConsolidationFunction

XlContainsOperator

XlCopyPictureFormat

XlCorruptLoad

XlCreator

XlCredentialsMethod

XlCubeFieldSubType

XlCubeFieldType

XlCutCopyMode

XlCVError

XlDataBarAxisPosition

XlDataBarBorderType

XlDataBarFillType

XlDataBarNegativeColorType

XlDataLabelPosition

XlDataLabelSeparator

XlDataLabelsType

XlDataSeriesDate

XlDataSeriesType

XlDeleteShiftDirection

XlDirection

XlDisplayBlanksAs

XlDisplayDrawingObjects

XlDisplayUnit

XlDupeUnique

XlDVAlertStyle

XlDVType

XlDynamicFilterCriteria

XlEditionFormat

XlEditionOptionsOption

XlEditionType

XlEnableCancelKey

XlEnableSelection

XlEndStyleCap

XlErrorBarDirection

XlErrorBarInclude

XlErrorBarType

XlErrorChecks

XlFileAccess

XlFileFormat

XlFileValidationPivotMode

XlFillWith

XlFilterAction

XlFilterAllDatesInPeriod

XlFilterStatus

XlFindLookIn

XlFixedFormatQuality

XlFixedFormatType

XlForecastAggregation

XlForecastChartType

XlForecastDataCompletion

XlFormatConditionOperator

XlFormatConditionType

XlFormatFilterTypes

XlFormControl

XlFormulaLabel

XlGenerateTableRefs

XlGradientFillType

XlHAlign

XlHebrewModes

XlHighlightChangesTime

XlHtmlType

XlIcon

XlIconSet

XlIMEMode

XlImportDataAs

XlInsertFormatOrigin

XlInsertShiftDirection

XlLayoutFormType

XlLayoutRowType

XlLegendPosition

XlLineStyle

XlLink

XlLinkInfo

XlLinkInfoType

XlLinkStatus

XlLinkType

XlLinkedDataTypeState

XlListConflict

XlListDataType

XlListObjectSourceType

XlLocationInTable

XlLookAt

XlLookFor

XlMailSystem

XlMarkerStyle

XlMeasurementUnits

XlModelChangeSource

XlMouseButton

XlMousePointer

XlMSApplication

XlOartHorizontalOverflow

XlOartVerticalOverflow

XlObjectSize

XlOLEType

XlOLEVerb

XlOrder

XlOrientation

XlPageBreak

XlPageBreakExtent

XlPageOrientation

XlPaperSize

XlParameterDataType

XlParameterType

XlParentDataLabelOptions

XlPasteSpecialOperation

XlPasteType

XlPattern

XlPhoneticAlignment

XlPhoneticCharacterType

XlPictureAppearance

XlPictureConvertorType

XlPieSliceIndex

XlPieSliceLocation

XlPivotCellType

XlPivotConditionScope

XlPivotFieldCalculation

XlPivotFieldDataType

XlPivotFieldOrientation

XlPivotFieldRepeatLabels

XlPivotFilterType

XlPivotFormatType

XlPivotLineType

XlPivotTableMissingItems

XlPivotTableSourceType

XlPivotTableVersionList

XlPlacement

XlPlatform

XlPortugueseReform

XlPrintErrors

XlPrintLocation

XlPriority

XlPropertyDisplayedIn

XlProtectedViewCloseReason

XlProtectedViewWindowState

XlPTSelectionMode

XlQueryType

XlQuickAnalysisMode

XlRangeAutoFormat

XlRangeValueDataType

XlReferenceStyle

XlReferenceType

XlRemoveDocInfoType

XlRgbColor

XlRobustConnect

XlRoutingSlipDelivery

XlRoutingSlipStatus

XlRowCol

XlRunAutoMacro

XlSaveAction

XlSaveAsAccessMode

XlSaveConflictResolution

XlScaleType

XlSearchDirection

XlSearchOrder

XlSearchWithin

XlSeriesNameLevel

XlSheetType

XlSheetVisibility

XlSizeRepresents

XlSlicerCacheType

XlSlicerCrossFilterType

XlSlicerSort

XlSmartTagControlType

XlSmartTagDisplayMode

XlSortDataOption

XlSortMethod

XlSortMethodOld

XlSortOn

XlSortOrder

XlSortOrientation

XlSortType

XlSourceType

XlSpanishModes

XlSparklineRowCol

XlSparkScale

XlSparkType

XlSpeakDirection

XlSpecialCellsValue

XlStdColorScale

XlSubscribeToFormat

XlSubtototalLocationType

XlSummaryColumn

XlSummaryReportType

XlSummaryRow

XlTableStyleElementType

XlTabPosition

XlTextParsingType

XlTextQualifier

XlTextVisualLayoutType

XlThemeColor

XlThemeFont

XlThreadMode

XlTickLabelOrientation

XlTickLabelPosition

XlTickMark

XlTimelineLevel

XlTimePeriods

XlTimeUnit

XlToolbarProtection

XlTopBottom

XlTotalsCalculation

XlTrendlineType

XlUnderlineStyle

XlUpdateLinks

XlVAlign

XlWBATemplate

XlWebFormatting

XlWebSelectionType

XlWindowState

XlWindowType

XlWindowView

XlXLMMacroType

XlXmlExportResult

XlXmlImportResult

XlXmlLoadOption

XlYesNoGuess

Graph Visual Basic reference

Collections

Axes collection

ChartGroups collection

DataLabels collection

HiLoLines object

LegendEntries collection

Points collection

SeriesCollection collection

Trendlines collection

Objects

Application object

AutoCorrect object

Axis object

AxisTitle object

Border object

Chart object

ChartArea object

ChartColorFormat object

ChartFillFormat object

ChartGroup object

ChartTitle object

Corners object

DataLabel object

DataSheet object

DataTable object

DisplayUnitLabel object

DownBars object

DropLines object

ErrorBars object

Floor object

Font object

Gridlines object

Interior object

LeaderLines object

Legend object

LegendEntry object

LegendKey object

PlotArea object

Point object

Range object

Series object

SeriesLines object

TickLabels object

Trendline object

UpBars object

Walls object

Methods

Activate

Add

AddChartAutoFormat

AddReplacement

ApplyCustomType

ApplyDataLabels

AreaGroups

AutoFit

Axes

BarGroups

Chart

ChartGroups

Clear

ClearContents

ClearFormats

ColumnGroups

Copy

Cut

DataLabels

Delete

DeleteChartAutoFormat

DeleteReplacement

Deselect

DoughnutGroups

ErrorBar

Evaluate

Export

FileImport

Insert

Item

LegendEntries

LineGroups

OneColorGradient

Paste

Patterned

PieGroups

Points

PresetGradient

PresetTextured

Quit

RadarGroups

Refresh

SaveAs

SaveAsOldFileFormat

SeriesCollection

SetDefaultChart

SetEchoOn

Solid

Trendlines

TwoColorGradient

Update

UserPicture

UserTextured

XYGroups

Properties

Application

ApplyPictToEnd

ApplyPictToFront

ApplyPictToSides

Area3DGroup

AutoCorrect

AutoScaleFont

AutoScaling

AutoText

AxisBetweenCategories

AxisGroup

AxisTitle

BackColor

Background

Backward

Bar3DGroup

BarShape

BaseUnit

BaseUnitIsAuto

Bold

Border

BubbleScale

CapitalizeNamesOfDays

Caption

CategoryType

CellDragAndDrop

Cells

ChartArea

ChartTitle

ChartType

Color

ColorIndex

Colors

Column3DGroup

Columns

ColumnWidth

CommandBars

Corners

CorrectCapsLock

CorrectSentenceCap

Count

Creator

Crosses

CrossesAt

DataLabel

DataSheet

DataTable

DepthPercent

DisplayAlerts

DisplayAutoCorrectOptions

DisplayBlanksAs

DisplayEquation

DisplayRSquared

DisplayUnit

DisplayUnitCustom

DisplayUnitLabel

DoughnutHoleSize

DownBars

DropLines

Elevation

EndStyle

ErrorBars

Explosion

Fill

FirstSliceAngle

Floor

Font

FontStyle

ForeColor

Forward

GapDepth

GapWidth

GradientColorType

GradientDegree

GradientStyle

GradientVariant

Has3DEffect

Has3DShading

HasAxis

HasBorderHorizontal

HasBorderOutline

HasBorderVertical

HasDataLabel

HasDataLabels

HasDataTable

HasDisplayUnitLabel

HasDropLines

HasErrorBars

HasHiLoLines

HasLeaderLines

HasLegend

HasLinks

HasMajorGridlines

HasMinorGridlines

HasRadarAxisLabels

HasSeriesLines

HasTitle

HasUpDownBars

Height

HeightPercent

HiLoLines

HorizontalAlignment

Include

Index

InsideHeight

InsideLeft

InsideTop

InsideWidth

Intercept

InterceptIsAuto

Interior

InvertIfNegative

Italic

Item

LeaderLines

Left

Legend

LegendKey

Line3DGroup

LineStyle

MajorGridlines

MajorTickMark

MajorUnit

MajorUnitIsAuto

MajorUnitScale

MarkerBackgroundColor

MarkerBackgroundColorIndex

MarkerForegroundColor

MarkerForegroundColorIndex

MarkerSize

MarkerStyle

MaximumScale

MaximumScaleIsAuto

MinimumScale

MinimumScaleIsAuto

MinorGridlines

MinorTickMark

MinorUnit

MinorUnitIsAuto

MinorUnitScale

MoveAfterReturn

Name

NameIsAuto

NumberFormat

NumberFormatLocal

Offset

Order

Orientation

OutlineFont

Overlap

Parent

Pattern

PatternColor

PatternColorIndex

Period

Perspective

PictureType

PictureUnit

Pie3DGroup

PlotArea

PlotBy

PlotOnX

Position

PresetGradientType

PresetTexture

RadarAxisLabels

Range

ReadingOrder

ReplacementList

ReplaceText

ReversePlotOrder

RGB

RightAngleAxes

Rotation

Rows

ScaleType

SchemeColor

SecondaryPlot

SecondPlotSize

Separator

SeriesLines

Shadow

ShowBubbleSize

ShowCategoryName

ShowChartTipNames

ShowChartTipValues

ShowLegendKey

ShowNegativeBubbles

ShowPercentage

ShowSeriesName

ShowValue

Size

SizeRepresents

Smooth

SplitType

SplitValue

Strikethrough

Subscript

Superscript

SurfaceGroup

Text

TextureName

TextureType

TickLabelPosition

TickLabels

TickLabelSpacing

TickMarkSpacing

Top

TwoInitialCapitals

Type

Underline

UpBars

Value

VaryByCategories

Version

VerticalAlignment

Visible

Walls

WallsAndGridlines2D

Weight

Width

WindowState

Enumerations

This topic provides a list of all enumerations in the Graph object model.

XlArabicModes

Name Value
xlArabicBothStrict 3
xlArabicNone 0
xlArabicStrictAlefHamza 1
xlArabicStrictFinalYaa 2

XlArrowHeadLength

Name Value
xlArrowHeadLengthLong 3
xlArrowHeadLengthMedium -4138
xlArrowHeadLengthShort 1

XlArrowHeadStyle

Name Value
xlArrowHeadStyleClosed 3
xlArrowHeadStyleDoubleClosed 5
xlArrowHeadStyleDoubleOpen 4
xlArrowHeadStyleNone -4142
xlArrowHeadStyleOpen 2

XlArrowHeadWidth

Name Value
xlArrowHeadWidthMedium -4138
xlArrowHeadWidthNarrow 1
xlArrowHeadWidthWide 3

XlAxisCrosses

Name Value
xlAxisCrossesAutomatic -4105
xlAxisCrossesCustom -4114
xlAxisCrossesMaximum 2
xlAxisCrossesMinimum 4

XlAxisGroup

Name Value
xlPrimary 1
xlSecondary 2

XlAxisType

Name Value
xlCategory 1
xlSeriesAxis 3
xlValue 2

XlBackground

Name Value
xlBackgroundAutomatic -4105
xlBackgroundOpaque 3
xlBackgroundTransparent 2

XlBarShape

Name Value
xlBox 0
xlConeToMax 5
xlConeToPoint 4
xlCylinder 3
xlPyramidToMax 2
xlPyramidToPoint 1

XlBorderWeight

Name Value
xlHairline 1
xlMedium -4138
xlThick 4
xlThin 2

XlCalculatedMemberType

Name Value
xlCalculatedMember 0
xlCalculatedSet 1

XlCategoryType

Name Value
xlAutomaticScale -4105
xlCategoryScale 2
xlTimeScale 3

XlChartGallery

Name Value
xlAnyGallery 23
xlBuiltIn 21
xlUserDefined 22

XlChartItem

Name Value
xlAxis 21
xlAxisTitle 17
xlChartArea 2
xlChartTitle 4
xlCorners 6
xlDataLabel 0
xlDataTable 7
xlDisplayUnitLabel 30
xlDownBars 20
xlDropLines 26
xlErrorBars 9
xlFloor 23
xlHiLoLines 25
xlLeaderLines 29
xlLegend 24
xlLegendEntry 12
xlLegendKey 13
xlMajorGridlines 15
xlMinorGridlines 16
xlNothing 28
xlPivotChartDropZone 32
xlPivotChartFieldButton 31
xlPlotArea 19
xlRadarAxisLabels 27
xlSeries 3
xlSeriesLines 22
xlShape 14
xlTrendline 8
xlUpBars 18
xlWalls 5
xlXErrorBars 10
xlYErrorBars 11

XlChartPicturePlacement

Name Value
xlAllFaces 7
xlEnd 2
xlEndSides 3
xlFront 4
xlFrontEnd 6
xlFrontSides 5
xlSides 1

XlChartPictureType

Name Value
xlStack 2
xlStackScale 3
xlStretch 1

XlChartSplitType

Name Value
xlSplitByCustomSplit 4
xlSplitByPercentValue 3
xlSplitByPosition 1
xlSplitByValue 2

XlChartType

Name Value
xl3DArea -4098
xl3DAreaStacked 78
xl3DAreaStacked100 79
xl3DBarClustered 60
xl3DBarStacked 61
xl3DBarStacked100 62
xl3DColumn -4100
xl3DColumnClustered 54
xl3DColumnStacked 55
xl3DColumnStacked100 56
xl3DLine -4101
xl3DPie -4102
xl3DPieExploded 70
xlArea 1
xlAreaStacked 76
xlAreaStacked100 77
xlBarClustered 57
xlBarOfPie 71
xlBarStacked 58
xlBarStacked100 59
xlBubble 15
xlBubble3DEffect 87
xlColumnClustered 51
xlColumnStacked 52
xlColumnStacked100 53
xlConeBarClustered 102
xlConeBarStacked 103
xlConeBarStacked100 104
xlConeCol 105
xlConeColClustered 99
xlConeColStacked 100
xlConeColStacked100 101
xlCylinderBarClustered 95
xlCylinderBarStacked 96
xlCylinderBarStacked100 97
xlCylinderCol 98
xlCylinderColClustered 92
xlCylinderColStacked 93
xlCylinderColStacked100 94
xlDoughnut -4120
xlDoughnutExploded 80
xlLine 4
xlLineMarkers 65
xlLineMarkersStacked 66
xlLineMarkersStacked100 67
xlLineStacked 63
xlLineStacked100 64
xlPie 5
xlPieExploded 69
xlPieOfPie 68
xlPyramidBarClustered 109
xlPyramidBarStacked 110
xlPyramidBarStacked100 111
xlPyramidCol 112
xlPyramidColClustered 106
xlPyramidColStacked 107
xlPyramidColStacked100 108
xlRadar -4151
xlRadarFilled 82
xlRadarMarkers 81
xlStockHLC 88
xlStockOHLC 89
xlStockVHLC 90
xlStockVOHLC 91
xlSurface 83
xlSurfaceTopView 85
xlSurfaceTopViewWireframe 86
xlSurfaceWireframe 84
xlXYScatter -4169
xlXYScatterLines 74
xlXYScatterLinesNoMarkers 75
xlXYScatterSmooth 72
xlXYScatterSmoothNoMarkers 73

XlCmdType

Name Value
xlCmdCube 1
xlCmdDefault 4
xlCmdList 5
xlCmdSql 2
xlCmdTable 3

XlColorIndex

Name Value
xlColorIndexAutomatic -4105
xlColorIndexNone -4142

XlColumnDataType

Name Value
xlDMYFormat 4
xlDYMFormat 7
xlEMDFormat 10
xlGeneralFormat 1
xlMDYFormat 3
xlMYDFormat 6
xlSkipColumn 9
xlTextFormat 2
xlYDMFormat 8
xlYMDFormat 5

XlConsolidationFunction

Name Value
xlAverage -4106
xlCount -4112
xlCountNums -4113
xlMax -4136
xlMin -4139
xlProduct -4149
xlStDev -4155
xlStDevP -4156
xlSum -4157
xlUnknown 1000
xlVar -4164
xlVarP -4165

XlCopyPictureFormat

Name Value
xlBitmap 2
xlPicture -4147

XlCreator

Name Value
xlCreatorCode 1480803660

XlCubeFieldType

Name Value
xlHierarchy 1
xlMeasure 2
xlSet 3

XlDataLabelPosition

Name Value
xlLabelPositionAbove 0
xlLabelPositionBelow 1
xlLabelPositionBestFit 5
xlLabelPositionCenter -4108
xlLabelPositionCustom 7
xlLabelPositionInsideBase 4
xlLabelPositionInsideEnd 3
xlLabelPositionLeft -4131
xlLabelPositionMixed 6
xlLabelPositionOutsideEnd 2
xlLabelPositionRight -4152

XlDataLabelSeparator

Name Value
xlDataLabelSeparatorDefault 1

XlDataLabelsType

Name Value
xlDataLabelsShowBubbleSizes 6
xlDataLabelsShowLabel 4
xlDataLabelsShowLabelAndPercent 5
xlDataLabelsShowNone -4142
xlDataLabelsShowPercent 3
xlDataLabelsShowValue 2

XlDataSeriesDate

Name Value
xlDay 1
xlMonth 3
xlWeekday 2
xlYear 4

XlDataSeriesType

Name Value
xlAutoFill 4
xlChronological 3
xlDataSeriesLinear -4132
xlGrowth 2

XlDeleteShiftDirection

Name Value
xlShiftToLeft -4159
xlShiftUp -4162

XlDirection

Name Value
xlDown -4121
xlToLeft -4159
xlToRight -4161
xlUp -4162

XlDisplayBlanksAs

Name Value
xlInterpolated 3
xlNotPlotted 1
xlZero 2

XlDisplayDrawingObjects

Name Value
xlDisplayShapes -4104
xlHide 3
xlPlaceholders 2

XlDisplayUnit

Name Value
xlHundredMillions -8
xlHundreds -2
xlHundredThousands -5
xlMillionMillions -10
xlMillions -6
xlTenMillions -7
xlTenThousands -4
xlThousandMillions -9
xlThousands -3

XlEndStyleCap

Name Value
xlCap 1
xlNoCap 2

XlErrorBarDirection

Name Value
xlX -4168
xlY 1

XlErrorBarInclude

Name Value
xlErrorBarIncludeBoth 1
xlErrorBarIncludeMinusValues 3
xlErrorBarIncludeNone -4142
xlErrorBarIncludePlusValues 2

XlErrorBarType

Name Value
xlErrorBarTypeCustom -4114
xlErrorBarTypeFixedValue 1
xlErrorBarTypePercent 2
xlErrorBarTypeStDev -4155
xlErrorBarTypeStError 4

XlFindLookIn

Name Value
xlComments -4144
xlFormulas -4123
xlValues -4163

XlHAlign

Name Value
xlHAlignCenter -4108
xlHAlignCenterAcrossSelection 7
xlHAlignDistributed -4117
xlHAlignFill 5
xlHAlignGeneral 1
xlHAlignJustify -4130
xlHAlignLeft -4131
xlHAlignRight -4152

XlHebrewModes

Name Value
xlHebrewFullScript 0
xlHebrewMixedAuthorizedScript 3
xlHebrewMixedScript 2
xlHebrewPartialScript 1

XlImportDataAs

Name Value
xlPivotTableReport 1
xlQueryTable 0

XlInsertFormatOrigin

Name Value
xlFormatFromLeftOrAbove 0
xlFormatFromRightOrBelow 1

XlInsertShiftDirection

Name Value
xlShiftDown -4121
xlShiftToRight -4161

XlLegendPosition

Name Value
xlLegendPositionBottom -4107
xlLegendPositionCorner 2
xlLegendPositionLeft -4131
xlLegendPositionRight -4152
xlLegendPositionTop -4160

XlLineStyle

Name Value
xlContinuous 1
xlDash -4115
xlDashDot 4
xlDashDotDot 5
xlDot -4118
xlDouble -4119
xlLineStyleNone -4142
xlSlantDashDot 13

XlLocationInTable

Name Value
xlColumnHeader -4110
xlColumnItem 5
xlDataHeader 3
xlDataItem 7
xlPageHeader 2
xlPageItem 6
xlRowHeader -4153
xlRowItem 4
xlTableBody 8

XlMarkerStyle

Name Value
xlMarkerStyleAutomatic -4105
xlMarkerStyleCircle 8
xlMarkerStyleDash -4115
xlMarkerStyleDiamond 2
xlMarkerStyleDot -4118
xlMarkerStyleNone -4142
xlMarkerStylePicture -4147
xlMarkerStylePlus 9
xlMarkerStyleSquare 1
xlMarkerStyleStar 5
xlMarkerStyleTriangle 3
xlMarkerStyleX -4168

XlOrientation

Name Value
xlDownward -4170
xlHorizontal -4128
xlUpward -4171
xlVertical -4166

XlPattern

Name Value
xlPatternAutomatic -4105
xlPatternChecker 9
xlPatternCrissCross 16
xlPatternDown -4121
xlPatternGray16 17
xlPatternGray25 -4124
xlPatternGray50 -4125
xlPatternGray75 -4126
xlPatternGray8 18
xlPatternGrid 15
xlPatternHorizontal -4128
xlPatternLightDown 13
xlPatternLightHorizontal 11
xlPatternLightUp 14
xlPatternLightVertical 12
xlPatternNone -4142
xlPatternSemiGray75 10
xlPatternSolid 1
xlPatternUp -4162
xlPatternVertical -4166

XlPictureConvertorType

Name Value
xlBMP 1
xlCGM 7
xlDRW 4
xlDXF 5
xlEPS 8
xlHGL 6
xlPCT 13
xlPCX 10
xlPIC 11
xlPLT 12
xlTIF 9
xlWMF 2
xlWPG 3

XlPivotFieldDataType

Name Value
xlDate 2
xlNumber -4145
xlText -4158

XlPivotFormatType

Name Value
xlPTClassic 20
xlPTNone 21
xlReport1 0
xlReport10 9
xlReport2 1
xlReport3 2
xlReport4 3
xlReport5 4
xlReport6 5
xlReport7 6
xlReport8 7
xlReport9 8
xlTable1 10
xlTable10 19
xlTable2 11
xlTable3 12
xlTable4 13
xlTable5 14
xlTable6 15
xlTable7 16
xlTable8 17
xlTable9 18

XlPivotTableSourceType

Name Value
xlConsolidation 3
xlDatabase 1
xlExternal 2
xlPivotTable -4148
xlScenario 4

XlQueryType

Name Value
xlADORecordset 7
xlDAORecordset 2
xlODBCQuery 1
xlOLEDBQuery 5
xlTextImport 6
xlWebQuery 4

XlRangeValueDataType

Name Value
xlRangeValueDefault 10
xlRangeValueMSPersistXML 12
xlRangeValueXMLSpreadsheet 11

XlReferenceStyle

Name Value
xlA1 1
xlR1C1 -4150

XlRowCol

Name Value
xlColumns 2
xlRows 1

XlScaleType

Name Value
xlScaleLinear -4132
xlScaleLogarithmic -4133

XlSheetType

Name Value
xlChart -4109
xlDialogSheet -4116
xlExcel4IntlMacroSheet 4
xlExcel4MacroSheet 3
xlWorksheet -4167

XlSizeRepresents

Name Value
xlSizeIsArea 1
xlSizeIsWidth 2

XlSubtototalLocationType

Name Value
xlAtBottom 2
xlAtTop 1

XlTickLabelOrientation

Name Value
xlTickLabelOrientationAutomatic -4105
xlTickLabelOrientationDownward -4170
xlTickLabelOrientationHorizontal -4128
xlTickLabelOrientationUpward -4171
xlTickLabelOrientationVertical -4166

XlTickLabelPosition

Name Value
xlTickLabelPositionHigh -4127
xlTickLabelPositionLow -4134
xlTickLabelPositionNextToAxis 4
xlTickLabelPositionNone -4142

XlTickMark

Name Value
xlTickMarkCross 4
xlTickMarkInside 2
xlTickMarkNone -4142
xlTickMarkOutside 3

XlTimeUnit

Name Value
xlDays 0
xlMonths 1
xlYears 2

XlTrendlineType

Name Value
xlExponential 5
xlLinear -4132
xlLogarithmic -4133
xlMovingAvg 6
xlPolynomial 3
xlPower 4

XlUnderlineStyle

Name Value
xlUnderlineStyleDouble -4119
xlUnderlineStyleDoubleAccounting 5
xlUnderlineStyleNone -4142
xlUnderlineStyleSingle 2
xlUnderlineStyleSingleAccounting 4

XlVAlign

Name Value
xlVAlignBottom -4107
xlVAlignCenter -4108
xlVAlignDistributed -4117
xlVAlignJustify -4130
xlVAlignTop -4160

XlWebFormatting

Name Value
xlWebFormattingAll 1
xlWebFormattingNone 3
xlWebFormattingRTF 2

XlWebSelectionType

Name Value
xlAllTables 2
xlEntirePage 1
xlSpecifiedTables 3

XlWindowState

Name Value
xlMaximized -4137
xlMinimized -4140
xlNormal -4143

XlWindowType

Name Value
xlChartAsWindow 5
xlChartInPlace 4
xlClipboard 3
xlInfo -4129
xlWorkbook 1