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.