英語版から項目を採取
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