Export (0) Print
Expand All

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.

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)

[OfficeAvailabilityAttribute(FileFormatVersions.Office2010)]
public class PivotHierarchy : OpenXmlLeafElement

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).

Any public static (Shared in Visual Basic) members of this type are thread safe. Any instance members are not guaranteed to be thread safe.

Community Additions

Show:
© 2014 Microsoft