summaryrefslogtreecommitdiffhomepage
path: root/examples/styles.rb
diff options
context:
space:
mode:
authorraiis <[email protected]>2012-11-26 21:13:55 +0200
committerraiis <[email protected]>2012-11-26 21:13:55 +0200
commit0962f913904343db03d253cc72681c8213aacea3 (patch)
tree1e700d31f7413d9620592d450c564f1b389db6da /examples/styles.rb
parent25ebea9143c136999bdaeb372fb26d2c070ca730 (diff)
downloadcaxlsx-0962f913904343db03d253cc72681c8213aacea3.tar.gz
caxlsx-0962f913904343db03d253cc72681c8213aacea3.zip
Added individual border override options.
Diffstat (limited to 'examples/styles.rb')
-rw-r--r--examples/styles.rb4
1 files changed, 4 insertions, 0 deletions
diff --git a/examples/styles.rb b/examples/styles.rb
index b69251b4..e8047ab1 100644
--- a/examples/styles.rb
+++ b/examples/styles.rb
@@ -48,6 +48,9 @@ wb.styles do |style|
# A style that a applies a font size and a custom formatting code
custom_format = wb.styles.add_style :sz => 20, :format_code => 'yyyy-mm-dd'
+ # A style that overrides top and left border style
+ one_border = wb.styles.add_style :border => { :style => :thin, :color =>"FAAC58", :edges => [:right, :top, :left] }, :border_top => { :style => :thick, :color => "01DF74" }, :border_left => { :color => "0101DF" }
+
wb.add_worksheet do |sheet|
@@ -55,6 +58,7 @@ wb.styles do |style|
sheet.add_row [123, "123", Time.now], style: [nil, large_font, predefined_format]
sheet.add_row [123, "123", Date.new(2012, 9, 14)], style: [large_font, nil, custom_format]
sheet.add_row [123, "123", Date.new(2000, 9, 12)] # This uses the axlsx default format_code (14)
+ sheet.add_row [123, "123", Time.now], style: [large_font, one_border, predefined_format]
end
end