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
'宣言
<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
'使用
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 初版]
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. 上記の引用はマイクロソフト (またはその代理) によって英語から日本語に翻訳されたものであり、ISO はこうした翻訳に対する責任を一切負いません。
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.