PivotTableReferences class
Defines the PivotTableReferences Class.This class is only available in O15. When the object is serialized out as xml, its qualified name is x15:pivotTableReferences.
Inheritance hierarchy
System.Object
DocumentFormat.OpenXml.OpenXmlElement
DocumentFormat.OpenXml.OpenXmlCompositeElement
DocumentFormat.OpenXml.Office15.Excel.PivotTableReferences
Namespace: DocumentFormat.OpenXml.Office15.Excel
Assembly: DocumentFormat.OpenXml (in DocumentFormat.OpenXml.dll)
Syntax
'Declaration
<OfficeAvailabilityAttribute(FileFormatVersions.Office15)> _
<ChildElementInfoAttribute(GetType(PivotTableReference), FileFormatVersions.Office15)> _
Public Class PivotTableReferences _
Inherits OpenXmlCompositeElement
'Usage
Dim instance As PivotTableReferences
[OfficeAvailabilityAttribute(FileFormatVersions.Office15)]
[ChildElementInfoAttribute(typeof(PivotTableReference), FileFormatVersions.Office15)]
public class PivotTableReferences : OpenXmlCompositeElement
Remarks
2.4.40 pivotTableReferences
Target namespace: https://schemas.microsoft.com/office/spreadsheetml/2010/11/main
A pivotTableReferences element is a CT_PivotTableReferences element, as specified in section 2.6.86, that specifies a list of PivotTable ([ISO/IEC-29500-1] section 18.10) part identifiers for the workbook. See section 2.2.4.9 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="pivotTableReferences" type="CT_PivotTableReferences"/>
See section 5.3 for the full W3C XML Schema ([XMLSCHEMA1] section 2.1).
2.6.86 CT_PivotTableReferences
Target namespace: https://schemas.microsoft.com/office/spreadsheetml/2010/11/main
Referenced by: pivotTableReferences
A complex type that specifies a list of PivotTable ([ISO/IEC-29500-1] section 18.10) part identifiers for Non-Worksheet PivotTables. MUST contain fewer than 231 elements.
Child Elements:
pivotTableReference: A CT_PivotTableReference element that specifies a PivotTable part identifier of a Non-Worksheet PivotTable.
The following W3C XML Schema ([XMLSCHEMA1] section 2.1) fragment specifies the contents of this complex type.
<xsd:complexType name="CT_PivotTableReferences">
<xsd:sequence>
<xsd:element name="pivotTableReference" type="CT_PivotTableReference" minOccurs="1" maxOccurs="unbounded"/>
</xsd:sequence>
</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.