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