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/
