merge method

merge

Merges a specified range of cells into a single cell.

def merge(self, first_row, first_column, total_rows, total_columns):
    ...
ParameterTypeDescription
first_rowintFirst row of this range(zero based)
first_columnintFirst column of this range(zero based)
total_rowsintNumber of rows(one based)
total_columnsintNumber of columns(one based)

Remarks

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

merge

Merges a specified range of cells into a single cell.

def merge(self, first_row, first_column, total_rows, total_columns, merge_conflict):
    ...
ParameterTypeDescription
first_rowintFirst row of this range(zero based)
first_columnintFirst column of this range(zero based)
total_rowsintNumber of rows(one based)
total_columnsintNumber of columns(one based)
merge_conflictboolMerge 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.

merge

Merges a specified range of cells into a single cell.

def merge(self, first_row, first_column, total_rows, total_columns, check_conflict, merge_conflict):
    ...
ParameterTypeDescription
first_rowintFirst row of this range(zero based)
first_columnintFirst column of this range(zero based)
total_rowsintNumber of rows(one based)
total_columnsintNumber of columns(one based)
check_conflictboolIndicates whether check the merged cells intersects other merged cells
merge_conflictboolMerge 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