Microsoft Office Tutorials and References
In Depth Information
Table 15-3. Excel 10 objects with 5 or more children
DiagramNodes (1)
PivotFormulas (2)
Watches (2)
Dialog (1)
PivotItem (4)
WebOptions (1)
Dialogs (2)
PivotItemList (2)
Window (7)
DisplayUnitLabel (6)
PivotItems (2)
Windows (2)
DownBars (4)
PivotLayout (4)
Workbook (14)
DropLines (2)
PivotTable (8)
Workbooks (2)
Error (1)
PivotTables (2)
Worksheet (17)
ErrorBars (2)
PlotArea (4)
WorksheetFunction (1)
ErrorCheckingOptions (1)
Point (5)
Worksheets (3)
Errors (2)
Points (2)
Table 15-3 shows the Excel objects that have at least five children. As we can see by comparing
the sizes of Tables 15-2 and 15-3, most objects by far have fewer than five children.
Table 15- . Excel 10 objects with 5 or mo re children
Application (32)
DataLabel (6)
Point (5)
Axis (6)
DataLabels (6)
Range (22)
AxisTitle (6)
DisplayUnitLabel (6)
Series (6)
Chart (16)
Legend (5)
Shape (22)
ChartArea (5)
OLEObject (5)
ShapeRange (17)
ChartGroup (7)
OLEObjects (6)
Window (7)
ChartObject (6)
PivotCell (6)
Workbook (14)
ChartObjects (6)
PivotField (5)
Worksheet (17)
ChartTitle (6)
PivotTable (8)
This list shows the only Excel 10 objects whose child count is in the double digits:
Application (32)
Shape (22)
Range (22)
Worksheet (17)
ShapeRange (17)
Chart (16)
Workbook (14)
Indeed, much of the power of the Excel object hierarchy is concentrated in the seven objects and
much of the remainder of this topic is devoted to those objects.
15.2 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 t hrough 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)
Constants (167)
XlChartType (73)
 
 
 
Search JabSto ::




Custom Search