[ms-xlsx]: Excel (. xlsx) Extensions to the Office Open xml spreadsheetml file Format

count: An unsignedInt ([XMLSCHEMA2] section 3.3.22) attribute that specifies the number of child setLevel elements of this element.

The following W3C XML Schema ([XMLSCHEMA1] section 2.1) fragment specifies the contents of this complex type.

See section 5.4 for the full W3C XML Schema ([XMLSCHEMA1] section 2.1).

2.6.23 CT_SetLevel

Target namespace: http://schemas.microsoft.com/office/spreadsheetml/2009/9/main

Referenced by: CT_SetLevels

A complex type that specifies an OLAP level of the PivotTable ([ISO/IEC29500-1:2011] section 18.10) cache hierarchy of a PivotTable named set.

Attributes:

hierarchy: An int ([XMLSCHEMA2] section 3.3.17) attribute that specifies a reference to the PivotTable cache hierarchy. MUST be a value from the following table.

Value	Meaning
"-2"	The PivotTable measure cache hierarchy is used.
"-1"	No PivotTable cache hierarchy is used.
Greater than or equal to zero	A zero-based PivotTable cache hierarchy index. The referenced CT_CacheHierarchy ([ISO/IEC29500-4:2011] section A.2) element specifies the PivotTable cache hierarchy that is used. MUST be less than the number of CT_CacheHierarchy elements within the CT_CacheHierarchies ([ISO/IEC29500-1:2011] section 18.10) element.

The following W3C XML Schema ([XMLSCHEMA1] section 2.1) fragment specifies the contents of this complex type.

See section 5.4 for the full W3C XML Schema ([XMLSCHEMA1] section 2.1).

2.6.24 CT_CacheHierarchy

Target namespace: http://schemas.microsoft.com/office/spreadsheetml/2009/9/main

Referenced by: cacheHierarchy

This complex type specifies the extended properties of a PivotTable ([ISO/IEC29500-1:2011] section 18.10) named set. When an element of this type is present, the set attribute of the ancestor cacheHierarchy element of type CT_CacheHierarchy ([ISO/IEC29500-4:2011] section A.2) MUST be "true".

Child Elements:

setLevels: A CT_SetLevels element that specifies the OLAP levels of the hierarchy that is used by this PivotTable ([ISO/IEC29500-1:2011] section 18.10) named set.

Attributes: