Ruby and Excel and colour question

[Axel Etzold]

Dear all,

I need to be able to write a file in Excel format, where the
fields have different background colours based on
some condition which is evaluated based on the entries
at runtime.
I tried to look at the spreadsheet gem, but couldn't figure out how to do it. I'd much prefer if you could point me to a solution that
is platform-independent (Excel files can be opened
from OpenOffice etc.) and/or would work together with JRuby.

Thank you very much !

Best regards,

Axel

 

[Thomas E Enebo]

Dear all,

I need to be able to write a file in Excel format, where the
fields have different background colours based on
some condition which is evaluated based on the entries
at runtime.
I tried to look at the spreadsheet gem, but couldn't figure out how to do it. I'd much prefer if you could point me to a solution that
is platform-independent (Excel files can be opened
from OpenOffice etc.) and/or would work together with JRuby.

OpenOffice has some Java API support for accessing and manipulating
files. I have not tried it, but I know there are examples of doing it
from Java. JRuby should be able to access those Java classes just
fine.

-Tom

 

[Mark Thomas]

Dear all,

I need to be able to write a file in Excel format, where the
fields have different background colours based on
some condition which is evaluated based on the entries
at runtime.
I tried to look at the spreadsheet gem, but couldn't figure out how to doit. I'd much prefer if you could point me to a solution that
is platform-independent (Excel files can be opened
from OpenOffice etc.) and/or would work together with JRuby.

The most popular platform-independent Excel creation library is POI
(http://poi.apache.org). It's a java library so you should be able to
use it from JRuby. You should be able to put in the formulas that
change the background color based on runtime content.

- Mark.

 

[Gilbo]

Dear all,

I need to be able to write a file in Excel format, where the
fields have different background colours based on
some condition which is evaluated based on the entries
at runtime.
I tried to look at the spreadsheet gem, but couldn't figure out how to doit. I'd much prefer if you could point me to a solution that
is platform-independent (Excel files can be opened
from OpenOffice etc.) and/or would work together with JRuby.

Thank you very much !

Best regards,

Axel

Axel,

have a look at surpass - it might be enough for what you want
(not sure about JRuby support though)

http://surpass.rubyforge.org/

HTH

Mike

 

[steve]

Axel,

have a look at surpass - it might be enough for what you want
(not sure about JRuby support though)

http://surpass.rubyforge.org/

HTH

Mike

Wow! Surpass looks amazing! I was thinking of using jruby to invoke the
java package OpenXLS to satisfy a similar requirement, but if this works
it will be much easier.

Steve