Share via


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.

See also

Reference

PivotTableReferences members

DocumentFormat.OpenXml.Office15.Excel namespace