PivotHierarchy Class
Defines the PivotHierarchy Class.This class is only available in Office2010.When the object is serialized out as xml, its qualified name is x14:pivotHierarchy.
Inheritance Hierarchy
System.Object
DocumentFormat.OpenXml.OpenXmlElement
DocumentFormat.OpenXml.OpenXmlLeafElement
DocumentFormat.OpenXml.Office2010.Excel.PivotHierarchy
Namespace: DocumentFormat.OpenXml.Office2010.Excel
Assembly: DocumentFormat.OpenXml (in DocumentFormat.OpenXml.dll)
Syntax
'Declaration
<OfficeAvailabilityAttribute(FileFormatVersions.Office2010)> _
Public Class PivotHierarchy _
Inherits OpenXmlLeafElement
'Usage
Dim instance As PivotHierarchy
[OfficeAvailabilityAttribute(FileFormatVersions.Office2010)]
public class PivotHierarchy : OpenXmlLeafElement
Remarks
2.4.24 pivotHierarchy
Target namespace: https://schemas.microsoft.com/office/spreadsheetml/2010/main
A CT_PivotHierarchy element that specifies multiple data items based on the same OLAP measure exist in a PivotTable ([ISO/IEC-29500-1] section 18.10) view. See Pivot Table under Extensions by Part for how this element integrates with [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.3 for the full W3C XML Schema ([XMLSCHEMA1] section 2.1).
2.6.47 CT_PivotHierarchy
Target namespace: https://schemas.microsoft.com/office/spreadsheetml/2010/main
Referenced by: pivotHierarchy
A complex type that specifies the ancestor CT_PivotHierarchy ([ISO/IEC-29500-4] section A.2) element SHOULD<38> be ignored.
The ancestor CT_PivotHierarchy ([ISO/IEC-29500-4] section A.2) 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 ([ISO/IEC-29500-4] section A.2) 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 ([ISO/IEC-29500-4] section A.2) element with a fld attribute equal to the zero-based index of a CT_CacheField ([ISO/IEC-29500-4] section A.2) element in the list of CT_CacheField ([ISO/IEC-29500-4] section A.2) elements specified by CT_CacheFields ([ISO/IEC-29500-4] section A.2) with a hierarchy attribute that specifies a CT_CacheHierarchy ([ISO/IEC-29500-4] section A.2) with a zero-based index in the list of CT_CacheHierarchy ([ISO/IEC-29500-4] section A.2) elements specified by the CT_CacheHierarchies ([ISO/IEC-29500-4] section A.2) element equal to the zero based index of the ancestor CT_PivotHierarchy ([ISO/IEC-29500-4] section A.2) element in the list of CT_PivotHierarchy ([ISO/IEC-29500-4] section A.2) elements specified by CT_PivotHierarchies ([ISO/IEC-29500-4] section A.2). Additionally, that CT_DataField ([ISO/IEC-29500-4] section A.2) element MUST have a descendant CT_DataField element with a sourceField attribute specified.
For more details, see CT_DataField
Attributes:
ignore : A boolean ([XMLSCHEMA2] section 3.2.2) attribute 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.3 for the full W3C XML Schema ([XMLSCHEMA1] section 2.1).
Thread Safety
Any public static (Shared in Visual Basic) members of this type are thread safe. Any instance members are not guaranteed to be thread safe.