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>

end example]

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>