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