Help on specifying color using color code

Rails
1

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.

2

Newb N. <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

3

On 9 July 2014 07:36, Maitreya D. [email protected] wrote:

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