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 N. <[email protected]…> 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

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

This forum is not affiliated to the Ruby language, Ruby on Rails framework, nor any Ruby applications discussed here.

| Privacy Policy | Terms of Service | Remote Ruby Jobs