Compartir a través de


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.

See Also

Reference

PivotHierarchy Members

DocumentFormat.OpenXml.Office2010.Excel Namespace