Export (0) Print
Expand All

TimelineCachePivotTable class

Office 2013

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


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

public class TimelineCachePivotTable : OpenXmlLeafElement

2.6.114 CT_TimelineCachePivotTable

Target namespace: http://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.<90>


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 equal to the decimal equivalent of 0xFFFFFFFF if the PivotTable specified by the name attribute is a Non-Worksheet PivotTable.

name: An ST_Xstring ([ISO/IEC-29500-1] section 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"/>


See section 5.3 for the full W3C XML Schema ([XMLSCHEMA1] section 2.1).

Any public static (Shared in Visual Basic) members of this type are thread safe. Any instance members are not guaranteed to be thread safe.
© 2015 Microsoft