I doubt if there are any "pure" Java VBA interpreters. (there can be implementations based on various Java-COM bridges).
Creating a VBA interpreter is out of scope of the POI HSSF project but some really useful functionality can be added. I mean to add the following: - read VBA modules using POI. AFAIK, VBA modules are stored as POIFS entries. Did anybody investigate it? - be able to programmatically inject a VBA module in XLS (or modify an existing VBA module). Yegor TM> Unfortunately, the ability to invoke a macro may be a requirement. That TM> said, does anyone know of another Java-Excel project (e.g. JExcelAPI, TM> Pagos spreadsheet component) that does include a VBA interpreter? TM> Tom TM> PS. On a side note, the POI HSSF project seems to be very easy to use. I TM> had a proof of concept up and running in very little time. TM> 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/ >> TM> --------------------------------------------------------------------- TM> To unsubscribe, e-mail: [EMAIL PROTECTED] TM> Mailing List: http://jakarta.apache.org/site/mail2.html#poi TM> 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/