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
···
--
Jetzt kostenlos herunterladen: Internet Explorer 8 und Mozilla Firefox 3.5 -
sicherer, schneller und einfacher! http://portal.gmx.net/de/go/atbrowser
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
···
On Mon, Oct 5, 2009 at 7:07 AM, Axel Etzold <AEtzold@gmx.de> wrote:
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.
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.
···
On Oct 5, 8:07 am, Axel Etzold <AEtz...@gmx.de> wrote:
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.
On Oct 5, 1:07 pm, Axel Etzold <AEtz...@gmx.de> wrote:
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.
On Oct 5, 1:07 pm, Axel Etzold <AEtz...@gmx.de> wrote:
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.
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.