Compartir a través de


TupleSet Class

Defines the TupleSet Class.This class is only available in Office2010.When the object is serialized out as xml, its qualified name is x14:tupleSet.

Inheritance Hierarchy

System.Object
  DocumentFormat.OpenXml.OpenXmlElement
    DocumentFormat.OpenXml.OpenXmlCompositeElement
      DocumentFormat.OpenXml.Office2010.Excel.TupleSet

Namespace:  DocumentFormat.OpenXml.Office2010.Excel
Assembly:  DocumentFormat.OpenXml (in DocumentFormat.OpenXml.dll)

Syntax

'Declaration
<ChildElementInfoAttribute(GetType(TupleSetRows), FileFormatVersions.Office2010)> _
<OfficeAvailabilityAttribute(FileFormatVersions.Office2010)> _
<ChildElementInfoAttribute(GetType(TupleSetHeaders), FileFormatVersions.Office2010)> _
Public Class TupleSet _
    Inherits OpenXmlCompositeElement
'Usage
Dim instance As TupleSet
[ChildElementInfoAttribute(typeof(TupleSetRows), FileFormatVersions.Office2010)]
[OfficeAvailabilityAttribute(FileFormatVersions.Office2010)]
[ChildElementInfoAttribute(typeof(TupleSetHeaders), FileFormatVersions.Office2010)]
public class TupleSet : OpenXmlCompositeElement

Remarks

The following table lists the possible child types:

  • TupleSetHeaders <x14:headers>

  • TupleSetRows <x14:rows>

2.6.16 CT_TupleSet

Target namespace: https://schemas.microsoft.com/office/spreadsheetml/2010/main

Referenced by: CT_CalculatedMember

A complex type that specifies an OLAP named set.

Child Elements:

headers : A CT_TupleSetHeaders element that specifies the MDX unique names of the OLAP hierarchies and the MDX unique names of the OLAP levels specified by this OLAP named set.

rows : A CT_TupleSetRows element that specifies the OLAP tuples specified by this OLAP named set.

Attributes:

rowCount : An unsignedInt ([XMLSCHEMA2] section 3.3.22) attribute that specifies the number of OLAP tuples specified by this OLAP named set. MUST equal the number of CT_TupleSetRow elements within the rows element. rowCount * columnCount MUST be less than or equal to 3000. <20>

columnCount : An unsignedInt ([XMLSCHEMA2] section 3.3.22) attribute that specifies the number of MDX unique names of the OLAP hierarchies and the MDX unique names of the OLAP levels specified by this OLAP named set. MUST equal the number of CT_TupleSetHeader elements within the headers element. rowCount * columnCount MUST be less than or equal to 3000.<21>

The following W3C XML Schema ([XMLSCHEMA1] section 2.1) fragment specifies the contents of this complex type.

<xsd:complexType name="CT_TupleSet">

<xsd:sequence>

<xsd:element name="headers" type="CT_TupleSetHeaders" minOccurs="1" maxOccurs="1"/>

<xsd:element name="rows" type="CT_TupleSetRows" minOccurs="1" maxOccurs="1"/>

</xsd:sequence>

<xsd:attribute name="rowCount" type="xsd:unsignedInt" use="optional" default="1"/>

<xsd:attribute name="columnCount" type="xsd:unsignedInt" use="optional" default="1"/>

</xsd:complexType>

See section 5.3 for the full W3C XML Schema ([XMLSCHEMA1] section 2.1).

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.

See Also

Reference

TupleSet Members

DocumentFormat.OpenXml.Office2010.Excel Namespace