Merge

Merge(int, int, int, int)

Merges a specified range of cells into a single cell.

public void Merge(int firstRow, int firstColumn, int totalRows, int totalColumns)
Parameter Type Description
firstRow Int32 First row of this range(zero based)
firstColumn Int32 First column of this range(zero based)
totalRows Int32 Number of rows(one based)
totalColumns Int32 Number of columns(one based)

Remarks

Reference the merged cell via the address of the upper-left cell in the range.

See Also


Merge(int, int, int, int, bool)

Merges a specified range of cells into a single cell.

public void Merge(int firstRow, int firstColumn, int totalRows, int totalColumns, 
    bool mergeConflict)
Parameter Type Description
firstRow Int32 First row of this range(zero based)
firstColumn Int32 First column of this range(zero based)
totalRows Int32 Number of rows(one based)
totalColumns Int32 Number of columns(one based)
mergeConflict Boolean Merge conflict merged ranges.

Remarks

Reference the merged cell via the address of the upper-left cell in the range. If mergeConflict is true and the merged range conflicts with other merged cells, other merged cells will be automatically removed.

See Also


Merge(int, int, int, int, bool, bool)

Merges a specified range of cells into a single cell.

public void Merge(int firstRow, int firstColumn, int totalRows, int totalColumns, 
    bool checkConflict, bool mergeConflict)
Parameter Type Description
firstRow Int32 First row of this range(zero based)
firstColumn Int32 First column of this range(zero based)
totalRows Int32 Number of rows(one based)
totalColumns Int32 Number of columns(one based)
checkConflict Boolean Indicates whether check the merged cells intersects other merged cells
mergeConflict Boolean Merge conflict merged ranges.

Remarks

Reference the merged cell via the address of the upper-left cell in the range. If mergeConflict is true and the merged range conflicts with other merged cells, other merged cells will be automatically removed.

See Also