merging cells.rb

require 'axlsx'
package = Axlsx::Package.new
package.workbook do |workbook|
  workbook.add_worksheet name: 'merged_cells' do |sheet|
    
    sheet.add_row %w(a b c d e f g)
    sheet.add_row %w(b c d x y z z)
    
    sheet.merge_cells "A1:A2"
    sheet.merge_cells "B1:B2"
  end
end
package.serialize 'merged_cells.xlsx'