PivotCacheRecord class

Office 2013 and later

PivotCache Record. When the object is serialized out as xml, its qualified name is x:r.

Namespace:  DocumentFormat.OpenXml.Spreadsheet
Assembly:  DocumentFormat.OpenXml (in DocumentFormat.OpenXml.dll)

C#
VB
C++
Copy
No code example is currently available or this language may not be supported.

[ISO/IEC 29500-1 1st Edition]

r (PivotCache Record)

Represents a single record of data in the PivotCache.

[Example:

<r>
  <s v="3550"/>
  <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"/>
  <x v="0"/>
  <s v="Australian Dollar"/>
  <n v="1"/>
  <n v="3578.27"/>
  <n v="0"/>
  <n v="2171.2941999999998"/>
  <n v="3578.27"/>
  <n v="89.456800000000001"/>
</r>

end example]

Parent Elements

pivotCacheRecords (§18.10.1.68)

Child Elements

Subclause

b (Boolean)

§18.10.1.2

d (Date Time)

§18.10.1.21

e (Error Value)

§18.10.1.27

m (No Value)

§18.10.1.50

n (Numeric)

§18.10.1.60

s (Character Value)

§18.10.1.85

x (Shared Items Index)

§18.10.1.97

[Note: The W3C XML Schema definition of this element’s content model (CT_Record) is located in §A.2. end note]

© ISO/IEC29500: 2008.

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