Contents

#!/usr/bin/env ruby -w -s
# -*- coding: utf-8 -*-
$LOAD_PATH.unshift "#{File.dirname(__FILE__)}/../lib"

#```ruby
require 'axlsx'
package = Axlsx::Package.new
package.workbook do |workbook|
  workbook.styles do |s|
    gridstyle_border =  s.add_style :border => { :style => :thin, :color =>"FFCDCDCD" }
    workbook.add_worksheet :name => "Custom Borders"  do |sheet|
      sheet.sheet_view.show_grid_lines = false
      sheet.add_row ["with", "grid", "style"], :style => gridstyle_border
      sheet.add_row ["no", "border"]
    end
  end
end
package.serialize 'no_grid_with_borders.xlsx'

Version data entries

12 entries across 12 versions & 6 rubygems

Version	Path
bonio-axlsx-2.2.3	examples/no_grid_with_borders.rb
caxlsx-3.0.2	examples/no_grid_with_borders.rb
caxlsx-3.0.1	examples/no_grid_with_borders.rb
caxlsx-3.0.0	examples/no_grid_with_borders.rb
axlsx-alt-3.0.1	examples/no_grid_with_borders.rb
axlsx-alt-3.0.0	examples/no_grid_with_borders.rb
axlsx-3.0.0.pre	examples/no_grid_with_borders.rb
bonio-axlsx-2.2.2	examples/no_grid_with_borders.rb
bonio-axlsx-2.2.1	examples/no_grid_with_borders.rb
dg-axlsx-2.1.0	examples/no_grid_with_borders.rb
axlsx-2.1.0.pre	examples/no_grid_with_borders.rb
l_axlsx-2.0.1	examples/no_grid_with_borders.rb