I'm using Java and OpenXLS to write out an Excel spreadsheet. I want to set a formula for a cell but I haven't got a clue how to do it. Can anybody help me, please? :)
(Can't tag this with "openxls" because I'm a new user...)
+1
A:
I don't know about OpenXLS, but it's easy to do with Andy Khan's JExcel. I'd recommend trying it. I think it's far superior to POI; I'm betting that it's better than OpenXLS as well.
duffymo
2009-07-06 15:26:02
Ultimately I did swap to JExcel. Turns out that OpenXLS doesn't support formulae at all - if you want to use them then you need to upgrade to the paid version :(
Cosmic Flame
2009-07-25 14:15:01
Hey, so vote me up.
duffymo
2009-07-25 16:28:52
A:
Ultimately it turned out that OpenXLS doesn't support formula cells. They are included in the paid for version, though...
Cosmic Flame
2009-11-03 16:00:50