<mergeCells> (Merge Cells)

This collection expresses all the merged cells in the sheet.

example:

This example shows that three ranges are merged. The formatting and content for the merged range is always stored in the top left cell.

<mergeCells>
  <mergeCell ref="C2:F2"/>
  <mergeCell ref="B19:C20"/>
  <mergeCell ref="E19:G19"/>
</mergeCells>

Parent Elements

<worksheet> (§3.3.1.96)

Child Elements

Subclause

<mergeCell> (Merged Cell)

§3.3.1.53

Attributes

Description

<count> (Count)

A count of merged cell collections.

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

The following XML Schema fragment defines the contents of this element:

<complexType name="CT_MergeCells">
	<sequence>
	<element name="mergeCell" type="CT_MergeCell" minOccurs="1" maxOccurs="unbounded"/>
	</sequence>
	<attribute name="count" type="xsd:unsignedInt" use="optional"/>
</complexType>