PivotHierarchy class
Defines the PivotHierarchy Class.This class is available in Office2010 or above. When the object is serialized out as xml, its qualified name is x14:pivotHierarchy.
DocumentFormat.OpenXml.OpenXmlElement
DocumentFormat.OpenXml.OpenXmlLeafElement
DocumentFormat.OpenXml.Office2010.Excel.PivotHierarchy
Namespace: DocumentFormat.OpenXml.Office2010.Excel
Assembly: DocumentFormat.OpenXml (in DocumentFormat.OpenXml.dll)
2.4.26 pivotHierarchy
Target namespace: http://schemas.microsoft.com/office/spreadsheetml/2009/9/main
A pivotHierarchy element is a CT_PivotHierarchy type element, as specified in section 2.6.47, that specifies multiple data items based on the same OLAP measure that exists in a PivotTable, as specified in [ISO/IEC-29500-1] section 18.10, view. See section 2.2.4.4 for how this element integrates with the Office Open XML file formats specified in [ISO/IEC-29500-1].
The following W3C XML Schema ([XMLSCHEMA1] section 2.1) fragment specifies the contents of this element.
<xsd:element name="pivotHierarchy" type="CT_PivotHierarchy"/>
See section 5.4 for the full W3C XML Schema ([XMLSCHEMA1] section 2.1).
2.6.47 CT_PivotHierarchy
Target namespace: http://schemas.microsoft.com/office/spreadsheetml/2009/9/main
Referenced by: pivotHierarchy
A complex type that specifies whether the ancestor CT_PivotHierarchy element, as specified in [ISO/IEC-29500-4] section A.2, SHOULD<52> be ignored.
The ancestor CT_PivotHierarchy element has the following restrictions on attributes.
Name | Value |
caption | MUST NOT be specified. |
dragOff | MUST equal "false". |
dragToCol | MUST equal "false". |
dragToData | MUST equal "true". |
dragToPage | MUST equal "false". |
dragToRow | MUST equal "false". |
includeNewItemsInFilter | MUST equal "true". |
multipleItemSelectionAllowed | MUST NOT be specified. |
outline | MUST NOT be specified. |
showInFieldList | MUST NOT be specified. |
subtotalTop | MUST NOT be specified. |
The ancestor CT_PivotHierarchy element has the following restrictions on child elements.
Child element | Restriction |
CT_PivotHierarchy (this element) | Exactly 1 MUST exist. |
CT_Members ([ISO/IEC-29500-4] section A.2) | MUST NOT exist. |
CT_MemberProperties ([ISO/IEC-29500-4] section A.2) | MUST NOT exist. |
If this element exists, there MUST exist a CT_DataField element, as specified in [ISO/IEC-29500-4] section A.2, with an fld attribute equal to the zero-based index of a CT_CacheField element, as specified in [ISO/IEC-29500-4] section A.2, in the list of CT_CacheField elements specified by CT_CacheFields, as specified in [ISO/IEC-29500-4] section A.2, with a hierarchy attribute that specifies a CT_CacheHierarchy, as specified in [ISO/IEC-29500-4] section A.2, with a zero-based index in the list of CT_CacheHierarchy elements specified by the CT_CacheHierarchies element, as specified in([ISO/IEC-29500-4] section A.2, equal to the zero-based index of the ancestor CT_PivotHierarchy element in the list of CT_PivotHierarchy elements specified by CT_PivotHierarchies, as specified in [ISO/IEC-29500-4] section A.2. Additionally, that CT_DataField element MUST have a descendant CT_DataField element, as specified in section 2.6.25, with a sourceField attribute specified.
For more details, see section 2.6.25.
Attributes:
ignore: A Boolean attribute, as specified in [XMLSCHEMA2] section 3.2.2, that MUST be "true" and MUST be ignored.
The following W3C XML Schema ([XMLSCHEMA1] section 2.1) fragment specifies the contents of this complex type.
<xsd:complexType name="CT_PivotHierarchy">
<xsd:attribute name="ignore" type="xsd:boolean" default="false" use="optional"/>
</xsd:complexType>
See section 5.4 for the full W3C XML Schema ([XMLSCHEMA1] section 2.1).