summaryrefslogtreecommitdiffhomepage
path: root/examples
diff options
context:
space:
mode:
authorshifakhan <[email protected]>2015-05-23 16:20:22 +0530
committershifakhan <[email protected]>2015-05-23 16:57:57 +0530
commita1006751413997ff5be88bd1321859d2f5dd566c (patch)
treec1f5fe8c5d64dfdb07aaff0c2511a1855885aa93 /examples
parent1bec39cebaef6a98481f52587ecc0483b4defc08 (diff)
downloadcaxlsx-a1006751413997ff5be88bd1321859d2f5dd566c.tar.gz
caxlsx-a1006751413997ff5be88bd1321859d2f5dd566c.zip
Option to change tab color
Diffstat (limited to 'examples')
-rwxr-xr-xexamples/example.rb12
1 files changed, 12 insertions, 0 deletions
diff --git a/examples/example.rb b/examples/example.rb
index 15d34ed6..fb4fc924 100755
--- a/examples/example.rb
+++ b/examples/example.rb
@@ -51,6 +51,7 @@ examples << :no_autowidth
examples << :cached_formula
examples << :page_breaks
examples << :rich_text
+examples << :tab_color
p = Axlsx::Package.new
wb = p.workbook
@@ -843,3 +844,14 @@ if examples.include? :rich_text
p.serialize 'rich_text.xlsx'
end
#```
+
+##Change tab color of sheet
+
+#```ruby
+if examples.include? :tab_color
+ wb.add_worksheet(:name => "Change Tab Color") do |sheet|
+ sheet.add_row ["Check", "out", "the", "Tab Color", "below!"]
+ sheet.sheet_pr.tab_color = "FFFF6666"
+ end
+end
+##``` \ No newline at end of file