Contents

require 'axlsx_styler'

axlsx = Axlsx::Package.new
workbook = axlsx.workbook

workbook.add_worksheet do |sheet|
  sheet.add_row
  sheet.add_row ['', 'Product', 'Category',  'Price']
  sheet.add_row ['', 'Butter', 'Dairy',      4.99]
  sheet.add_row ['', 'Bread', 'Baked Goods', 3.45]
  sheet.add_row ['', 'Broccoli', 'Produce',  2.99]
  sheet.column_widths 5, 20, 20, 20

  # using AxlsxStyler DSL
  sheet['B2:D2'].add_style b: true
  sheet['B2:B5'].add_style b: true
  sheet['B2:D2'].add_style bg_color: '95AFBA'
  sheet['B3:D5'].add_style bg_color: 'E2F89C'
  sheet['D3:D5'].add_style alignment: { horizontal: :left }
  sheet['B2:D5'].add_border
  sheet['B3:D3'].add_border [:top]
end

workbook.apply_styles

axlsx.serialize File.expand_path('../../tmp/grocery.xlsx', __FILE__)

Version data entries

2 entries across 2 versions & 1 rubygems

Version	Path
axlsx_styler-0.0.5	examples/colors_and_borders.rb
axlsx_styler-0.0.4	examples/colors_and_borders.rb