Skip to content
Ahmed Kamal edited this page Jun 11, 2019 · 1 revision

Merging Cells

book = Spreadsheet::Workbook.new
sheet = book.create_worksheet name: "Sheet 1"
row = sheet.row(1)

merge_cells(start_row, start_col, end_row, end_col)

Example

sheet.merge_cells(0, 15, 0, 30)

Will merge cells on row no. 0 from column 15 to column 30.

Clone this wiki locally