Friday, 15 August 2014

set cell or row background color in a google spreadsheet using google_drive gem on ruby -


I am trying to set the background color for a cell and a line and using the 'google_drive' gem I am It seems that this option is in the 'spreadsheet' gem

  format = Spreadsheet :: Format.new: color = & gt; : Blue ,: pattern_fg_color = & gt; : Yellow, Pattern = & gt; 1   

If the 'google_drive' gem also has this option, please tell me!

Thanks in advance.

The problem is that you : color = & gt; You are trying to set background color by setting. : Blue . Instead, set : pattern_bg_color = & gt; : Blue .

All options: : bottom_color ,: top_color ,: left_color ,:right_color ,: pattern_fg_color ,: pattern_bg_color ,: diagonal_color

Hope this helps is!

No comments:

Post a Comment