blob: aed9eb76686e17aa1a0de373839487afb585412b (
plain)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
|
#!/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'
|
