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

Declaration

C#

public interface IXlMergedCells :
    IEnumerable<XlCellRange>,
    IEnumerable,
    ICollection

VB.NET

Public Interface IXlMergedCells
    Inherits IEnumerable(Of XlCellRange),
             IEnumerable,
             ICollection

Related API Members

The following members return IXlMergedCells objects:

• IXlSheet.MergedCells

Remarks

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.