XlsFile.MergeCells Method
Merges a number of cells into one.
Remarks
This method might return a bigger range than the one you specify. For example, if you have a merged cell (A1:C1), calling MergeCells(1,2,2,2) will merge the cell with the existing one, returning ONE merged cell (A1:C2), and not (B1:B2)
Other thing to consider, is that Excel honors individual linestyles inside a merged cell. That is, you can have only the first 2 columns of the merged cell with a line and the others without. Normally, after merging the cells, you will want to call ExcelFile.SetCellFormat(Int32, Int32, Int32) on the range to make them all similar. FlexCel does not do it by default, to give the choice to you.
Syntax
Namespace: FlexCel.XlsAdapter
public override void MergeCells(Int32 firstRow, Int32 firstCol, Int32 lastRow, Int32 lastCol)
Parameters
<-> | Parameter | Type | Description |
---|---|---|---|
firstRow | Int32 | First row of the merged cell. | |
firstCol | Int32 | First column of the merged cell. | |
lastRow | Int32 | Last row of the merged cell. | |
lastCol | Int32 | Last column of the merged cell. |