Monday, 2 September 2013

Set width and background for cell in excel using spreadsheet rails

Set width and background for cell in excel using spreadsheet rails

I used the following code
title_format = Spreadsheet::Format.new(:color => :blue, :pattern_fg_color
=> :red, :weight => :bold, :size => 18)
sheet1.row(0).set_format(0, title_format)
Font color is working but I am unable to get background color and also i
need to increase the width of the cell. How can i do.

No comments:

Post a Comment