Excel formulas and VBA macros are conceptually different things. We do support formulas in HSSF and do it well.
Yegor AA> Feel a complete fraud posting this here but, have you looked at jxcell? AA> I must admit that I have not be this link does boast of it's support for formulae. AA> http://www.jxcell.net/ AA> "Andrew C. Oliver" <[EMAIL PROTECTED]> wrote: AFAIK there is no Java-based VBA interpreter in existence. You might be AA> able to do something slick AA> with IKVM and MONO but probably with a formidable performance cost. If AA> you really need this, an implementation can be created, contact me AA> offline. (acoliver ot buni dat org) AA> Tom Muldoon wrote: >> Unfortunately, the ability to invoke a macro may be a requirement. >> That said, does anyone know of another Java-Excel project (e.g. >> JExcelAPI, Pagos spreadsheet component) that does include a VBA >> interpreter? >> >> Tom >> >> PS. On a side note, the POI HSSF project seems to be very easy to use. >> I had a proof of concept up and running in very little time. >> >> Andrew C. Oliver wrote: >>> No. That would require a VBA interpreter. HSSF is not a spreadsheet >>> engine/app/whatever it is an API to deal with a file format. >>> >>> Tom Muldoon wrote: >>>> Andrew, >>>> >>>> by "Macros can be there if ...", do you mean that macros can be >>>> invoked / executed from the Java code? The reason that I ask is that >>>> the Limitations page states simply ... >>>> >>>> "Macros cannot be created. However, reading and re-writing files >>>> containing macros will safely preserve the macros." >>>> >>>> In other words, it doesn't actually state whether or not macros can >>>> be invoked / executed. >>>> >>>> Thanks again, Tom >>>> >>>> Andrew C. Oliver wrote: >>>>> The project is active. We just haven't put out an official release >>>>> in awhile. Partly because builds/milestones are reasonably >>>>> stable. Macros can be there if you set the preserve flag off the >>>>> hssf workbook constructor. >>>>> Tom Muldoon wrote: >>>>>> I'm wondering what the state of the POI-HSSF project is. I noticed >>>>>> that the latest release is dated 06-Aug-2004 and I'm assuming that >>>>>> this project is no longer active. I also noticed that the archive >>>>>> link is broken. That said, I also noticed in the list of >>>>>> limitations that macros cannot be created, however, I'm wondering >>>>>> if macros can be invoked. >>>>>> >>>>>> Thanks in advance, Tom >>>>>> >>>>>> PS. If this project is no longer active, are there other projects >>>>>> out there that are? >>>>>> >>>>>> >>>>>> --------------------------------------------------------------------- >>>>>> To unsubscribe, e-mail: [EMAIL PROTECTED] >>>>>> Mailing List: http://jakarta.apache.org/site/mail2.html#poi >>>>>> The Apache Jakarta Poi Project: http://jakarta.apache.org/poi/ >>>>>> >>>>>> >>>>> >>>>> >>>> >>>> >>>> --------------------------------------------------------------------- >>>> To unsubscribe, e-mail: [EMAIL PROTECTED] >>>> Mailing List: http://jakarta.apache.org/site/mail2.html#poi >>>> The Apache Jakarta Poi Project: http://jakarta.apache.org/poi/ >>>> >>> >>> >>> >>> --------------------------------------------------------------------- >>> To unsubscribe, e-mail: [EMAIL PROTECTED] >>> Mailing List: http://jakarta.apache.org/site/mail2.html#poi >>> The Apache Jakarta Poi Project: http://jakarta.apache.org/poi/ >>> >> >> >> --------------------------------------------------------------------- >> To unsubscribe, e-mail: [EMAIL PROTECTED] >> Mailing List: http://jakarta.apache.org/site/mail2.html#poi >> The Apache Jakarta Poi Project: http://jakarta.apache.org/poi/ >> >> --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] Mailing List: http://jakarta.apache.org/site/mail2.html#poi The Apache Jakarta Poi Project: http://jakarta.apache.org/poi/
