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:
Table 15-4. The Excel Enums and their number of constants (Excel 8)
Constants (163) |
XlEnableSelection (3) |
XlPivotFieldOrientation (5) |
XlApplicationInternational (45) |
XlEndStyleCap (2) |
XlPivotTableSourceType (4) |
XlApplyNamesOrder (2) |
XlErrorBarDirection (2) |
XlPlacement (3) |
XlArrangeStyle (4) |
XlErrorBarInclude (4) |
XlPlatform (3) |
XlArrowHeadLength (3) |
XlErrorBarType (5) |
XlPrintLocation (3) |
XlArrowHeadStyle (5) |
XlFileAccess (2) |
XlPriority (3) |
XlArrowHeadWidth (3) |
XlFileFormat (39) |
XlPTSelectionMode (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) |
XlBordersIndex (8) |
XlHAlign (8) |
XlSaveAction (2) |
XlBorderWeight (4) |
XlHighlightChangesTime (3) |
XlSaveAsAccessMode (3) |
XlBuiltInDialog (221) |
XlIMEMode (11) |
XlSaveConflictResolution (3) |
XlCalculation (3) |
XlInsertShiftDirection (2) |
XlScaleType (2) |
XlCategoryType (3) |
XlLegendPosition (5) |
XlSearchDirection (2) |
XlCellInsertionMode (3) |
XlLineStyle (8) |
XlSearchOrder (2) |
XlCellType (10) |
XlLink (4) |
XlSheetType (5) |
XlChartGallery (3) |
XlLinkInfo (2) |
XlSheetVisibility (3) |
XlChartItem (29) |
XlLinkInfoType (3) |
XlSizeRepresents (2) |
XlChartLocation (3) |
XlLinkType (2) |
XlSortMethod (2) |
XlChartPicturePlacement (7) |
XlLocationInTable (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) |
XlColorIndex (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) |