Share via


PivotTableReference class

Defines the PivotTableReference Class.This class is only available in O15. When the object is serialized out as xml, its qualified name is x15:pivotTableReference.

Inheritance hierarchy

System.Object
  DocumentFormat.OpenXml.OpenXmlElement
    DocumentFormat.OpenXml.OpenXmlLeafElement
      DocumentFormat.OpenXml.Office15.Excel.PivotTableReference

Namespace:  DocumentFormat.OpenXml.Office15.Excel
Assembly:  DocumentFormat.OpenXml (in DocumentFormat.OpenXml.dll)

Syntax

'Declaration
<OfficeAvailabilityAttribute(FileFormatVersions.Office15)> _
Public Class PivotTableReference _
    Inherits OpenXmlLeafElement
'Usage
Dim instance As PivotTableReference
[OfficeAvailabilityAttribute(FileFormatVersions.Office15)]
public class PivotTableReference : OpenXmlLeafElement

Remarks

2.6.87 CT_PivotTableReference

Target namespace: https://schemas.microsoft.com/office/spreadsheetml/2010/11/main

Referenced by: CT_PivotTableReferences

A complex type that specifies a relationship identifier to a PivotTable ([ISO/IEC-29500-1] section 18.10) part in this workbook. The PivotTable specified by the element pivotTableDefinition ([ISO/IEC-29500-1] section 18.10.1.73) identified by this type MUST be a Non-Worksheet PivotTable and MUST satisfy the following criteria.

The ref attribute of the child element location ([ISO/IEC-29500-1] section 18.10.1.49) MUST begin with "A1".

The enableEdit attribute of the CT_PivotTableDefinition element, as specified in section 2.6.32*, MUST NOT exist or MUST be "false" if exists; CT_PivotEdits and CT_PivotChanges elements MUST NOT exist in this part.*

The PivotTable name specified by the name attribute of the element pivotTableDefinition ([ISO/IEC-29500-1] section 18.10.1.73), MUST be unique among all the PivotTables in the workbook.

There MUST be a child CT_PivotCache ([ISO/IEC-29500-4] section A.2) element within the pivotCaches element, specified by section 2.4.39*, with the attribute cacheID having the same value as the cacheId attribute of the element pivotTableDefinition (*[ISO/IEC-29500-1] section 18.10.1.73).

The PivotTable MUST NOT have CT_ConditionalFormats element as specified by section section 2.6.49*.*

Attributes:

r:id: An ST_RelationshipId ([ISO/IEC-29500-1] section 22.8.2.1) attribute that specifies a relationship identifier to a PivotTable part in this workbook.

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

<xsd:complexType name="CT_PivotTableReference">

<xsd:attribute ref="r:id" use="required"/>

</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

PivotTableReference members

DocumentFormat.OpenXml.Office15.Excel namespace