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?