Help on specifying color using color code

Hi All,

In my application i am using Spreadsheet::Excel gem for export to excel. Is it possible to set color of a row using color code instead of using exact color name like below

h1 = Spreadsheet::Format.new(                              :color => "green",                              :bold => true,                              :size => 15,                              :pattern_fg_color => "yellow", :pattern => 1 )

when i use like below

h1 = Spreadsheet::Format.new(                              :color => "green",                              :bold => true,                              :size => 15,                              :pattern_fg_color => "#00FFFF", :pattern => 1 )

it gives me error like invalid color..

so how i can specify color code ....

Kindly let me know your suggestions.

Thanks for your time.

Newb Newb <lists@...> writes:

Hi All,

In my application i am using Spreadsheet::Excel gem for export to excel.

Kindly let me know your suggestions.

Thanks for your time.

Check this out - http://andisxp.blogspot.in/2011/12/export-to-excel-with- spreadsheet-gem.html

Newb Newb <lists@...> writes:

Hi All,

In my application i am using Spreadsheet::Excel gem for export to excel.

Kindly let me know your suggestions.

Thanks for your time.

Check this out - http://andisxp.blogspot.in/2011/12/export-to-excel-with- spreadsheet-gem.html

Since the post you answered was dated over four years ago I suspect the OP may have got bored with waiting for an answer and found a way to get round his problem.

Colin