[ms-xlsx]: Excel (. xlsx) Extensions to the Office Open xml spreadsheetml file Format Intellectual Property Rights Notice for Open Specifications Documentation

1370.1.1CT_TupleSet

Target namespace: http://schemas.microsoft.com/office/spreadsheetml/2009/9/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 3,000.

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 3,000.

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

1371

1372

1373

1374

1375

1376

1377

1378

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

1378.1.1CT_TupleSetHeaders

Target namespace: http://schemas.microsoft.com/office/spreadsheetml/2009/9/main

Referenced by: CT_TupleSet

A complex type that specifies the MDX unique names of the OLAP hierarchies and the MDX unique names of the OLAP levels of the OLAP named set.

Child Elements:

header: CT_TupleSetHeader elements that specify the MDX unique names of the OLAP hierarchies and the MDX unique names of the OLAP levels of the OLAP named set. The number of these elements MUST be equal to the value of the columnCount attribute in the CT_TupleSet element that is the ancestor of this element.

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

1379

1380

1381

1382

1383

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

1383.1.1CT_TupleSetHeader

Target namespace: http://schemas.microsoft.com/office/spreadsheetml/2009/9/main

Referenced by: CT_TupleSetHeaders

A complex type that specifies the MDX unique name of the OLAP hierarchy and the MDX unique name of the OLAP level of the OLAP named set that is specified by the CT_TupleSet element that is an ancestor of this element.

Attributes:

uniqueName: An ST_Xstring ([ISO/IEC29500-1:2012] section 22.9.2.19) attribute that specifies the MDX unique name of the OLAP level. MUST be less than or equal to 65,535 characters in length.

hierarchyName: An ST_Xstring ([ISO/IEC29500-1:2012] section 22.9.2.19) attribute that specifies the MDX unique name of the OLAP hierarchy. MUST be less than or equal to 65,535 characters in length.

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

1384

1385

1386

1387

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

1387.1.1CT_TupleSetRows

Target namespace: http://schemas.microsoft.com/office/spreadsheetml/2009/9/main

Referenced by: CT_TupleSet

A complex type that specifies the OLAP tuples for this OLAP named set.

Child Elements:

row: CT_TupleSetRow elements that specify the OLAP tuples for this OLAP named set. The number of these elements MUST be equal to the value of the rowCount attribute in the parent CT_TupleSet element.

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

1388

1389

1390

1391

1392

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

1392.1.1CT_TupleSetRow

Target namespace: http://schemas.microsoft.com/office/spreadsheetml/2009/9/main

Referenced by: CT_TupleSetRows

A complex type that specifies an OLAP tuple for this OLAP named set.

Child Elements:

rowItem: CT_TupleSetRowItem elements that specify the OLAP members that are part of the OLAP tuple that is specified by this CT_TupleSetRow element. The number of these elements MUST be equal to value of the columnCount attribute in the CT_TupleSet element that is an ancestor of this element.

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

1393

1394

1395

1396

1397

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