Skip to main content

IXlMergedCells Interface

Represents a collection of merged cells in a worksheet.

Namespace: DevExpress.Export.Xl

Assembly: DevExpress.Printing.v22.2.Core.dll

NuGet Packages: DevExpress.Printing.Core, DevExpress.Win.Dashboard.Design


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