Feel a complete fraud posting this here but, have you looked at jxcell? I must admit that I have not be this link does boast of it's support for formulae.
http://www.jxcell.net/ "Andrew C. Oliver" <[EMAIL PROTECTED]> wrote: AFAIK there is no Java-based VBA interpreter in existence. You might be able to do something slick with IKVM and MONO but probably with a formidable performance cost. If you really need this, an implementation can be created, contact me offline. (acoliver ot buni dat org) 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/ > > -- No PST Files Ever Again Buni Meldware Communication Suite Email, Calendaring, ease of configuration/administration http://buni.org --------------------------------------------------------------------- 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/ __________________________________________________ Do You Yahoo!? Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com
