GroupItems Class
OLAP Group Items.When the object is serialized out as xml, its qualified name is x:groupItems.
Inheritance Hierarchy
System.Object
DocumentFormat.OpenXml.OpenXmlElement
DocumentFormat.OpenXml.OpenXmlCompositeElement
DocumentFormat.OpenXml.Spreadsheet.GroupItems
Namespace: DocumentFormat.OpenXml.Spreadsheet
Assembly: DocumentFormat.OpenXml (in DocumentFormat.OpenXml.dll)
Syntax
'宣言
<ChildElementInfoAttribute(GetType(BooleanItem))> _
<ChildElementInfoAttribute(GetType(DateTimeItem))> _
<ChildElementInfoAttribute(GetType(NumberItem))> _
<ChildElementInfoAttribute(GetType(MissingItem))> _
<ChildElementInfoAttribute(GetType(ErrorItem))> _
<ChildElementInfoAttribute(GetType(StringItem))> _
Public Class GroupItems _
Inherits OpenXmlCompositeElement
'使用
Dim instance As GroupItems
[ChildElementInfoAttribute(typeof(BooleanItem))]
[ChildElementInfoAttribute(typeof(DateTimeItem))]
[ChildElementInfoAttribute(typeof(NumberItem))]
[ChildElementInfoAttribute(typeof(MissingItem))]
[ChildElementInfoAttribute(typeof(ErrorItem))]
[ChildElementInfoAttribute(typeof(StringItem))]
public class GroupItems : 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>
[ISO/IEC 29500-1 初版]
18.10.1.38 groupItems (OLAP Group Items)
Represents the collection of items in a field group.
[Example:
…
<fieldGroup par="6" base="0">
<rangePr groupBy="months" startDate="2002-01-01T00:00:00"
endDate="2006-05-06T00:00:00"/>
<groupItems count="14">
<s v="<1/1/2002"/>
<s v="Jan"/>
<s v="Feb"/>
<s v="Mar"/>
<s v="Apr"/>
<s v="May"/>
<s v="Jun"/>
<s v="Jul"/>
<s v="Aug"/>
<s v="Sep"/>
<s v="Oct"/>
<s v="Nov"/>
<s v="Dec"/>
<s v=">5/6/2006"/>
</groupItems>
</fieldGroup>
</cacheField>
<cacheField name="Name" numFmtId="0">
<sharedItems count="4">
<s v="Joe"/>
<s v="John"/>
<s v="Bob"/>
<s v="Robert"/>
</sharedItems>
<fieldGroup par="4"/>
</cacheField>
<cacheField name="ProductID" numFmtId="0">
<sharedItems containsSemiMixedTypes="0" containsString="0" containsNumber="1"
containsInteger="1" minValue="1" maxValue="4" count="4">
<n v="1"/>
<n v="2"/>
<n v="3"/>
<n v="4"/>
</sharedItems>
<fieldGroup base="2">
<rangePr startNum="1" endNum="4" groupInterval="2"/>
<groupItems count="4">
<s v="<1"/>
<s v="1-2"/>
<s v="3-4"/>
<s v=">5"/>
</groupItems>
</fieldGroup>
…
end example]
Parent Elements |
|---|
fieldGroup (§18.10.1.30) |
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 |
Attributes |
Description |
|---|---|
count (Items Created Count) |
Specifies the number of items created for this grouped field. 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_GroupItems) 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.