TimelineCachePivotTable class

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

Inheritance hierarchy

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

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

Syntax

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

Remarks

2.6.128 CT_TimelineCachePivotTable

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

Referenced by: CT_TimelineCachePivotTables

A complex type that specifies a PivotTable ([ISO/IEC-29500-1] section 18.10) view filtered by a Timeline cache.

Attributes:

tabId: An unsignedInt ([XMLSCHEMA2] section 3.3.22) attribute that specifies the unique identifier (UID) of the worksheet that contains the PivotTable ([ISO/IEC-29500-1] section 18.10) view specified by the name attribute. MUST match the sheetId of an existing sheet (1) ([ISO/IEC-29500-4] section A.2) element within the workbook. MUST be ignored if the PivotTable specified by the name attribute is a Non-Worksheet PivotTable.

name: An ST_Xstring ([ISO/IEC-29500-1] section 22.9.2.19) attribute that specifies the name of the PivotTable ([ISO/IEC-29500-1] section 18.10) view on the worksheet specified by tabId. MUST match the name attribute of an existing pivotTableDefinition element in the worksheet. The createdVersion attribute of the CT_PivotTableDefinition ([ISO/IEC-29500-4] section A.2) element that defines the specified PivotTable ([ISO/IEC-29500-1] section 18.10) MUST be greater than or equal to 3.

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

<xsd:complexType name="CT_TimelineCachePivotTable">

<xsd:attribute name="tabId" type="xsd:unsignedInt" use="required"/>

<xsd:attribute name="name" type="x:ST_Xstring" 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

TimelineCachePivotTable members

DocumentFormat.OpenXml.Office15.Excel namespace