PivotCacheRecord Class
PivotCache Record.When the object is serialized out as xml, its qualified name is x:r.
Inheritance Hierarchy
System.Object
DocumentFormat.OpenXml.OpenXmlElement
DocumentFormat.OpenXml.OpenXmlCompositeElement
DocumentFormat.OpenXml.Spreadsheet.PivotCacheRecord
Namespace: DocumentFormat.OpenXml.Spreadsheet
Assembly: DocumentFormat.OpenXml (in DocumentFormat.OpenXml.dll)
Syntax
'Declaration
<ChildElementInfoAttribute(GetType(StringItem))> _
<ChildElementInfoAttribute(GetType(NumberItem))> _
<ChildElementInfoAttribute(GetType(BooleanItem))> _
<ChildElementInfoAttribute(GetType(MissingItem))> _
<ChildElementInfoAttribute(GetType(ErrorItem))> _
<ChildElementInfoAttribute(GetType(DateTimeItem))> _
<ChildElementInfoAttribute(GetType(FieldItem))> _
Public Class PivotCacheRecord _
Inherits OpenXmlCompositeElement
'Usage
Dim instance As PivotCacheRecord
[ChildElementInfoAttribute(typeof(StringItem))]
[ChildElementInfoAttribute(typeof(NumberItem))]
[ChildElementInfoAttribute(typeof(BooleanItem))]
[ChildElementInfoAttribute(typeof(MissingItem))]
[ChildElementInfoAttribute(typeof(ErrorItem))]
[ChildElementInfoAttribute(typeof(DateTimeItem))]
[ChildElementInfoAttribute(typeof(FieldItem))]
public class PivotCacheRecord : OpenXmlCompositeElement
Remarks
The following table lists the possible child types:
MissingItem <x:m>
NumberItem <x:n>
BooleanItem <x:b>
ErrorItem <x:e>
StringItem <x:s>
DateTimeItem <x:d>
FieldItem <x:x>
[ISO/IEC 29500-1 1st Edition]
18.10.1.77 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.
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.