4

I'm trying to set a background color for a cell and a row and am using the 'google_drive' gem. It looks like that the 'spreadsheet' gem does have this option 

format = Spreadsheet::Format.new :color=> :blue, :pattern_fg_color => :yellow, :pattern => 1

if the 'google_drive' gem also has this option, please let me know!

Thanks in Advance.

piyush
  • 601
  • 3
  • 23
sylvian
  • 709
  • 2
  • 9
  • 19

1 Answers1

1

The problem is that you are trying to set the background color by setting :color => :blue. Instead, set :pattern_bg_color => :blue.

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

Hope this helps!

Fomentia
  • 904
  • 7
  • 12