diff options
| -rwxr-xr-x | examples/example.rb | 21 |
1 files changed, 21 insertions, 0 deletions
diff --git a/examples/example.rb b/examples/example.rb index 0850857a..596da6b2 100755 --- a/examples/example.rb +++ b/examples/example.rb @@ -70,6 +70,27 @@ wb.styles do |s| sheet.add_row [1, 2, 3], :style => blue_border end end + +#```ruby +# Hacking border styles + wb.styles do |s| + top_bottom = s.add_style :border => { :style => :thick, :color =>"FFFF0000", :edges => [:top, :bottom] } + border = s.borders[s.cellXfs[top_bottom].borderId] + # edit existing border parts + border.prs.each do |part| + case part.name + when :top + part.color = Axlsx::Color.new(:rgb => "FFFF0000") + when :bottom + part.color = Axlsx::Color.new(:rgb => "FF00FF00") + end + end + + border.prs << Axlsx::BorderPr.new(:name => :left, :color => Axlsx::Color.new(:rgb => '0000FF'), :style => :mediumDashed) + wb.add_worksheet(:name => 'hacked borders') do |sheet| + sheet.add_row [1,2,3], :style=>top_bottom + end + end ##``` |