Table of Contents

ExcelFile.UnMergeAllCellsInRange Method

This method will unmerge all the cells that are inside a range of cells.

Syntax

Namespace: FlexCel.Core

public abstract void UnMergeAllCellsInRange(Int32 firstRow, Int32 firstCol, Int32 lastRow, Int32 lastCol, Boolean fullyInside)

Parameters

<-> Parameter Type Description
firstRow Int32 First row of the range.
firstCol Int32 First column of the range.
lastRow Int32 Last row of the range.
lastCol Int32 Last column of the range.
fullyInside Boolean If true, the merged cells have to be completely inside the range to be deleted.
For example, if the file has a merged cell A1:A5, and you call UnMergeAllCellsInRange(1, 1, 1, 1, true) A1:A5 won't be unmerged because it isn't completely inside the range. If false, all merged cells that have at least one cell inside the range will be deleted. In the example with the merged cell A1:A5, UnMergeAllCellsInRange(1, 1, 1, 1, false) would remove the merged cell, because it has the cell A1 inside the range.

See also