summaryrefslogtreecommitdiffhomepage
path: root/examples/example.rb
diff options
context:
space:
mode:
Diffstat (limited to 'examples/example.rb')
-rwxr-xr-xexamples/example.rb21
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
##```