IXlMergedCells Interface

Represents a collection of merged cells in a worksheet.

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

NuGet Package : DevExpress.Printing.Core

Declaration

csharp

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

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

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.