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?