Excel Enums

It is also interesting to glance over the list of Excel enums, whose names begin with Xl (with the sole exception of the Constants enum). Tables Table 15-4 through Table 15-6 show these enums for Excel 8, 9, and 10, along with a count of the number of constants per enum. Note that there are some rather large enums in the object model. The enums with at least 20 constants are:

• XlBuiltInDialog (241)

• XlApplicationlnternational (45)

• XlRangeAutoFormat (43)

• XlClipboardFormat (33)

• XlPivotFormatType (22)

• XlParameterDataType (21)

Table 15-4. The Excel Enums and their number of constants (Excel 8)

Constants (163)

XlEnableSelection (3)

XlPivotFieldOrientation (5)

XlApplicationlnternational (45)

XlEndStyleCap (2)

XlPivotTableSourceType (4)

XlApplyNamesOrder (2)

XlErrorBarDirection (2)

XlPlacement (3)

XlArrangeStyle (4)

XlErrorBarlnclude (4)

XlPlatform (3)

XlArrowHeadLength (3)

XlErrorBarType (5)

XlPrintLocation (3)

XlArrowHeadStyle (5)

XlFileAccess (2)

XlPriority (3)

XlArrowHeadWidth (3)

XlFileFormat (39)

XlPT SelectionMode (6)

XlAutoFillType (11)

XlFillWith (3)

XlRangeAutoFormat (21)

XlAutoFilterOperator (6)

XlFilterAction (2)

XlReferenceStyle (2)

XlAxisCrosses (4)

XlFindLookIn (3)

XlReferenceType (4)

XlAxisGroup (2)

XlFormatConditionOperator (8)

XlRoutingSlipDelivery (2)

XlAxisType (3)

XlFormatConditionType (2)

XlRoutingSlipStatus (3)

XlBackground (3)

XlFormControl (10)

XlRowCol (2)

XlBarShape (6)

XlFormulaLabel (4)

XlRunAutoMacro (4)

XlBorderslndex (8)

XlHAlign (8)

XlSaveAction (2)

XlBorderWeight (4)

XlHighlightChangesTime (3)

XlSaveAsAccessMode (3)

XlBuiltlnDialog (221)

XllMEMode (11)

XlSaveConflictResolution (3)

XlCalculation (3)

XllnsertShiftDirection (2)

XlScaleType (2)

XlCategoryType (3)

XlLegendPosition (5)

XlSearchDirection (2)

XlCelllnsertionMode (3)

XlLineStyle (8)

XlSearchOrder (2)

XlCellType (10)

XlLink (4)

XlSheetType (5)

XlChartGallery (3)

XlLinklnfo (2)

XlSheetVisibility (3)

XlChartltem (29)

XlLinklnfoType (3)

XlSizeRepresents (2)

XlChartLocation (3)

XlLinkType (2)

XlSortMethod (2)

XlChartPicturePlacement (7)

XlLocationlnTable (9)

XlSortMethodOld (2)

XlChartPictureType (3)

XlLookAt (2)

XlSortOrder (2)

XlChartSplitType (4)

XlMailSystem (3)

XlSortOrientation (2)

XlChartType (73)

XlMarkerStyle (12)

XlSortType (2)

XlClipboardFormat (33)

XlMouseButton (3)

XlSpecialCellsValue (4)

XlColorlndex (2)

XlMousePointer (4)

XlSubscribeToFormat (2)

XlCommandUnderlines (3)

XlMSApplication (7)

XlSummaryColumn (2)

XlCommentDisplayMode (3)

XlObjectSize (3)

XlSummaryReportType (2)

XlConsolidationFunction (11)

XlOLEType (3)

XlSummaryRow (2)

XlCopyPictureFormat (2)

XlOLEVerb (2)

XlTabPosition (2)

XlCreator (1)

XlOrder (2)

XlTextParsingType (2)

XlCutCopyMode (2)

XlOrientation (4)

XlTextQualifier (3)

XlCVError (7)

XlPageBreak (2)

XlTickLabelOrientation (5)

XlDataLabelPosition (11)

XlPageBreakExtent (2)

XlTickLabelPosition (4)

XlDataLabelsType (6)

XlPageOrientation (2)

XlTickMark (4)

XlDataSeriesDate (4)

XlPaperSize (42)

XlTimeUnit (3)

XlDataSeriesType (4)

XlParameterDataType (20)

XlToolbarProtection (5)

XlDeleteShiftDirection (2)

XlParameterType (3)

XlTrendlineType (6)

XlDirection (4)

XlPasteSpecialOperation (5)

XlUnderlineStyle (5)

XlDisplayBlanksAs (3)

XlPasteType (6)

XlVAlign (5)

XlDisplayShapes (3)

XlPattern (20)

XlWBATemplate (4)

XlDVAlertStyle (3)

XlPhoneticAlignment (4)

XlWindowState (3)

XlDVType (8)

XlPhoneticCharacterType (4)

XlWindowType (5)

XlEditionFormat (4)

XlPictureAppearance (2)

XlWindowView (2)

XlEditionOptionsOption (8)

XlPictureConvertorType (13)

XlXLMMacroType (3)

XlEditionType (2)

XlPivotFieldCalculation (9)

XlYesNoGuess (3)

XlEnableCancelKey (3)

XlPivotFieldDataType (3)

Table 15-5. Additional enums for Excel 9.0

XlCmdType (4)

XlHtmlType (4)

XlSourceType (7)

XlColumnDataType (10)

XlLayoutFormType (2)

XlSubtototalLocationType (2)

XlCubeFieldType (2)

XlPivotFormatType (22)

XlWebFormatting (3)

XlDisplayUnit (9)

XlQueryType (6)

XlWebSelectionType (3)

Table 15-6. Additional enums for Excel 10

XlArabicModes (4)

XlImportDataAs (2)

XlRobustConnect (3)

XlCalculatedMemberType (2)

XlInsertFormatOrigin (2)

XlSearchWithin (2)

XlCalculationInterruptKey (3)

XlLinkStatus (11)

XlSmartTagDisplayMode (3)

XlCalculationState (3)

XlPivotCellType (10)

XlSortDataOption (2)

XlCorruptLoad (3)

XlPivotTableMissingItems (3)

XlSpeakDirection (2)

XlDataLabelSeparator (1)

XlPivotTableVersionList (3)

XlUpdateLinks (3)

XlErrorChecks (7)

XlPrintErrors (4)

XlHebrewModes (4)

XlRangeValueDataType (3)

0 0

Responses

  • Hiewan
    How to use xlquerytype?
    7 years ago

Post a comment