From: steve Date: 2009-10-09T09:35:57+09:00 Subject: Re: Ruby and Excel and colour question Gilbo wrote: > On Oct 5, 1:07 pm, Axel Etzold 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. >> >> 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 > > 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