Help on specifying color using color code

28 views
Skip to first unread message

Newb Newb

unread,
Feb 24, 2010, 6:16:23 AM2/24/10
to rubyonra...@googlegroups.com
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.
--
Posted via http://www.ruby-forum.com/.

Maitreya Dwaipayan

unread,
Jul 9, 2014, 2:41:52 AM7/9/14
to rubyonra...@googlegroups.com
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


Colin Law

unread,
Jul 9, 2014, 3:03:22 PM7/9/14
to rubyonra...@googlegroups.com
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

>
>
> --
> You received this message because you are subscribed to the Google Groups "Ruby on Rails: Talk" group.
> To unsubscribe from this group and stop receiving emails from it, send an email to rubyonrails-ta...@googlegroups.com.
> To post to this group, send email to rubyonra...@googlegroups.com.
> To view this discussion on the web visit https://groups.google.com/d/msgid/rubyonrails-talk/loom.20140709T083500-194%40post.gmane.org.
> For more options, visit https://groups.google.com/d/optout.
Reply all
Reply to author
Forward
0 new messages