PivotCacheRecords Class
PivotCache Records. It is the root element of PivotTableCacheRecordsPart.When the object is serialized out as xml, its qualified name is x:pivotCacheRecords.
Inheritance Hierarchy
System.Object
DocumentFormat.OpenXml.OpenXmlElement
DocumentFormat.OpenXml.OpenXmlCompositeElement
DocumentFormat.OpenXml.OpenXmlPartRootElement
DocumentFormat.OpenXml.Spreadsheet.PivotCacheRecords
Namespace: DocumentFormat.OpenXml.Spreadsheet
Assembly: DocumentFormat.OpenXml (in DocumentFormat.OpenXml.dll)
Syntax
'Declaration
<ChildElementInfoAttribute(GetType(PivotCacheRecord))> _
<ChildElementInfoAttribute(GetType(ExtensionList))> _
Public Class PivotCacheRecords _
Inherits OpenXmlPartRootElement
'Usage
Dim instance As PivotCacheRecords
[ChildElementInfoAttribute(typeof(PivotCacheRecord))]
[ChildElementInfoAttribute(typeof(ExtensionList))]
public class PivotCacheRecords : OpenXmlPartRootElement
Remarks
The following table lists the possible child types:
PivotCacheRecord <x:r>
ExtensionList <x:extLst>
[ISO/IEC 29500-1 1st Edition]
18.10.1.68 pivotCacheRecords (PivotCache Records)
Represents the collection of records in the PivotCache. This part stores the underlying source data that the PivotTable aggregates.
[Example:
<pivotCacheRecords xmlns="…" xmlns:r="…" count="2">
<r>
<x v="0"/>
<s v="Pacific"/>
<x v="0"/>
<s v="Australia"/>
<x v="0"/>
<x v="0"/>
<s v="3550"/>
<x v="0"/>
<x v="0"/>
<s v="Road-150 Red, 62"/>
<s v="This bike is ridden by race winners. Developed with the Adventure
Works Cycles professional race team, it has a extremely light
heat-treated aluminum frame, and steering that allows precision
control."/>
<s v="No Discount"/>
…
<n v="89.456800000000001"/>
</r>
…
end example]
Parent Elements |
|---|
Root element of SpreadsheetML Pivot Table Cache Records part |
Child Elements |
Subclause |
|---|---|
extLst (Future Feature Data Storage Area) |
§18.2.10 |
r (PivotCache Record) |
§18.10.1.77 |
Attributes |
Description |
|---|---|
count (PivotCache Records Count) |
Specifies the number of records in the cache. The possible values for this attribute are defined by the W3C XML Schema unsignedInt datatype. |
[Note: The W3C XML Schema definition of this element’s content model (CT_PivotCacheRecords) is located in §A.2. end note]
© ISO/IEC29500: 2008.
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.