Group class

Office 2013 and later

OLAP Group. When the object is serialized out as xml, its qualified name is x:group.

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]

group (OLAP Group)

Represents an OLAP level group.

[Example:

<group name="CategoryXl_Grp_1" uniqueName="[Product].[Product Categories].  [Product Categories1].[GROUPMEMBER.[CategoryXl_Grp_1]].[Product]].  [Product Categories]].[All Products]]]" caption="Group1"   uniqueParent="[Product].[Product Categories].[All Products]" id="1">
  <groupMembers count="2">
    <groupMember      uniqueName="[Product].[Product Categories].[Category].&amp;[4]"/>
    <groupMember      uniqueName="[Product].[Product Categories].[Category].&amp;[1]"/>
  </groupMembers>
</group>

end example]

Parent Elements

groups (§18.10.1.43)

Child Elements

Subclause

groupMembers (OLAP Group Members)

§18.10.1.42

Attributes

Description

caption (Group Caption)

Specifies the caption for this group.

The possible values for this attribute are defined by the ST_Xstring simple type (§22.9.2.19).

id (Group Id)

Specifies the unique number for this group within the level.

The possible values for this attribute are defined by the W3C XML Schema int datatype.

name (Group Name)

Specifies the name of this group.

The possible values for this attribute are defined by the ST_Xstring simple type (§22.9.2.19).

uniqueName (Unique Group Name)

Specifies the unique name of this group.

The possible values for this attribute are defined by the ST_Xstring simple type (§22.9.2.19).

uniqueParent (Parent Unique Name)

Specifies the unique name of the parent of this group.

The possible values for this attribute are defined by the ST_Xstring simple type (§22.9.2.19).

[Note: The W3C XML Schema definition of this element’s content model (CT_LevelGroup) 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: