From a1006751413997ff5be88bd1321859d2f5dd566c Mon Sep 17 00:00:00 2001 From: shifakhan Date: Sat, 23 May 2015 16:20:22 +0530 Subject: Option to change tab color --- examples/example.rb | 12 ++++++++++++ 1 file changed, 12 insertions(+) (limited to 'examples') 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 -- cgit v1.2.3