Contents

require_relative '../lib/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 "../grocery.xlsx"

Version data entries

2 entries across 2 versions & 1 rubygems

Version	Path
axlsx_styler-0.0.3	examples/colors_and_borders.rb
axlsx_styler-0.0.2	examples/colors_and_borders.rb