CODEWITHSUNDEEP
ruby-on-railsexcelspreadsheet
John
John

Reputation: 13735

Merging cells with Ruby Gem Spreadsheet

How do I merge cells using the Ruby Spreadsheet gem. I would like to merge the first 6 cells on the first row of a worksheet. When I try the following it does not work:

merge_format = Spreadsheet::Format.new :align => :merge
6.times do |j|
  sheet.row(0).set_format(j,merge_format)
end

What am I doing wrong?

Upvotes: 6

Views: 6917

Answers (1)

HargrimmTheBleak
HargrimmTheBleak

Reputation: 2167

You can simply do

sheet.merge_cells(start_row, start_col, end_row, end_col)

If you want to go with set_format, I'd advise trying :vertical_align => :merge, although I didn't use it since merge_cells always worked for me.

Upvotes: 21

Related Questions