Skip to main content

IXlMergedCells Interface

Represents a collection of merged cells in a worksheet.

Namespace: DevExpress.Export.Xl

Assembly: DevExpress.Printing.v24.1.Core.dll

NuGet Package: DevExpress.Printing.Core


public interface IXlMergedCells :

The following members return IXlMergedCells objects:


To access an object exposing the IXlMergedCells interface, use the IXlSheet.MergedCells property.

Use the collection’s IXlMergedCells.Add method to merge a specified range of cells into a single cell. To split a merged cell, remove it from the collection by using the IXlMergedCells.Remove or IXlMergedCells.RemoveAt method. To split all merged cells in a worksheet, use the IXlMergedCells.Clear method.

For an example on how to merge and unmerge worksheet cells, refer to the How to: Merge Cells or Split Merged Cells article.

See Also