You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@poi.apache.org by Tom Muldoon <to...@firstbest.com> on 2007/02/03 15:53:19 UTC

What is the state of the project?

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: poi-user-unsubscribe@jakarta.apache.org
Mailing List:     http://jakarta.apache.org/site/mail2.html#poi
The Apache Jakarta Poi Project:  http://jakarta.apache.org/poi/


Re[2]: What is the state of the project?

Posted by Yegor Kozlov <ye...@dinom.ru>.
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: poi-user-unsubscribe@jakarta.apache.org
>>>>> Mailing List:     http://jakarta.apache.org/site/mail2.html#poi
>>>>> The Apache Jakarta Poi Project:  http://jakarta.apache.org/poi/
>>>>>
>>>>>
>>>>
>>>>
>>>
>>>
>>> ---------------------------------------------------------------------
>>> To unsubscribe, e-mail: poi-user-unsubscribe@jakarta.apache.org
>>> Mailing List:     http://jakarta.apache.org/site/mail2.html#poi
>>> The Apache Jakarta Poi Project:  http://jakarta.apache.org/poi/
>>>
>>
>>
>>
>> ---------------------------------------------------------------------
>> To unsubscribe, e-mail: poi-user-unsubscribe@jakarta.apache.org
>> 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: poi-user-unsubscribe@jakarta.apache.org
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: poi-user-unsubscribe@jakarta.apache.org
Mailing List:     http://jakarta.apache.org/site/mail2.html#poi
The Apache Jakarta Poi Project:  http://jakarta.apache.org/poi/


Re: What is the state of the project?

Posted by Tom Muldoon <to...@firstbest.com>.
Anthony,

I certainly understand the "fraud" feeling. I felt guilty simply asking 
the question on the POI user list. All the same, thanks for the input. I 
haven't checked out jxcell but I will if it turns out that HSSF doesn't 
meet my needs.

Tom

Anthony Andrews wrote:
> 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" <ac...@buni.org> 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: poi-user-unsubscribe@jakarta.apache.org
>>>>>> Mailing List:     http://jakarta.apache.org/site/mail2.html#poi
>>>>>> The Apache Jakarta Poi Project:  http://jakarta.apache.org/poi/
>>>>>>
>>>>>>
>>>>>>             
>>>>>           
>>>> ---------------------------------------------------------------------
>>>> To unsubscribe, e-mail: poi-user-unsubscribe@jakarta.apache.org
>>>> Mailing List:     http://jakarta.apache.org/site/mail2.html#poi
>>>> The Apache Jakarta Poi Project:  http://jakarta.apache.org/poi/
>>>>
>>>>         
>>>
>>> ---------------------------------------------------------------------
>>> To unsubscribe, e-mail: poi-user-unsubscribe@jakarta.apache.org
>>> Mailing List:     http://jakarta.apache.org/site/mail2.html#poi
>>> The Apache Jakarta Poi Project:  http://jakarta.apache.org/poi/
>>>
>>>       
>> ---------------------------------------------------------------------
>> To unsubscribe, e-mail: poi-user-unsubscribe@jakarta.apache.org
>> Mailing List:     http://jakarta.apache.org/site/mail2.html#poi
>> The Apache Jakarta Poi Project:  http://jakarta.apache.org/poi/
>>
>>
>>     
>
>
>   


---------------------------------------------------------------------
To unsubscribe, e-mail: poi-user-unsubscribe@jakarta.apache.org
Mailing List:     http://jakarta.apache.org/site/mail2.html#poi
The Apache Jakarta Poi Project:  http://jakarta.apache.org/poi/


Re[2]: What is the state of the project?

Posted by Yegor Kozlov <ye...@dinom.ru>.
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" <ac...@buni.org> 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: poi-user-unsubscribe@jakarta.apache.org
>>>>>> Mailing List:     http://jakarta.apache.org/site/mail2.html#poi
>>>>>> The Apache Jakarta Poi Project:  http://jakarta.apache.org/poi/
>>>>>>
>>>>>>
>>>>>
>>>>>
>>>>
>>>>
>>>> ---------------------------------------------------------------------
>>>> To unsubscribe, e-mail: poi-user-unsubscribe@jakarta.apache.org
>>>> Mailing List:     http://jakarta.apache.org/site/mail2.html#poi
>>>> The Apache Jakarta Poi Project:  http://jakarta.apache.org/poi/
>>>>
>>>
>>>
>>>
>>> ---------------------------------------------------------------------
>>> To unsubscribe, e-mail: poi-user-unsubscribe@jakarta.apache.org
>>> Mailing List:     http://jakarta.apache.org/site/mail2.html#poi
>>> The Apache Jakarta Poi Project:  http://jakarta.apache.org/poi/
>>>
>>
>>
>> ---------------------------------------------------------------------
>> To unsubscribe, e-mail: poi-user-unsubscribe@jakarta.apache.org
>> Mailing List:     http://jakarta.apache.org/site/mail2.html#poi
>> The Apache Jakarta Poi Project:  http://jakarta.apache.org/poi/
>>
>>


---------------------------------------------------------------------
To unsubscribe, e-mail: poi-user-unsubscribe@jakarta.apache.org
Mailing List:     http://jakarta.apache.org/site/mail2.html#poi
The Apache Jakarta Poi Project:  http://jakarta.apache.org/poi/


Re: What is the state of the project?

Posted by Anthony Andrews <py...@yahoo.com>.
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" <ac...@buni.org> 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: poi-user-unsubscribe@jakarta.apache.org
>>>>> Mailing List:     http://jakarta.apache.org/site/mail2.html#poi
>>>>> The Apache Jakarta Poi Project:  http://jakarta.apache.org/poi/
>>>>>
>>>>>
>>>>
>>>>
>>>
>>>
>>> ---------------------------------------------------------------------
>>> To unsubscribe, e-mail: poi-user-unsubscribe@jakarta.apache.org
>>> Mailing List:     http://jakarta.apache.org/site/mail2.html#poi
>>> The Apache Jakarta Poi Project:  http://jakarta.apache.org/poi/
>>>
>>
>>
>>
>> ---------------------------------------------------------------------
>> To unsubscribe, e-mail: poi-user-unsubscribe@jakarta.apache.org
>> Mailing List:     http://jakarta.apache.org/site/mail2.html#poi
>> The Apache Jakarta Poi Project:  http://jakarta.apache.org/poi/
>>
>
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: poi-user-unsubscribe@jakarta.apache.org
> 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: poi-user-unsubscribe@jakarta.apache.org
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 

Re: What is the state of the project?

Posted by "Andrew C. Oliver" <ac...@buni.org>.
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: poi-user-unsubscribe@jakarta.apache.org
>>>>> Mailing List:     http://jakarta.apache.org/site/mail2.html#poi
>>>>> The Apache Jakarta Poi Project:  http://jakarta.apache.org/poi/
>>>>>
>>>>>
>>>>
>>>>
>>>
>>>
>>> ---------------------------------------------------------------------
>>> To unsubscribe, e-mail: poi-user-unsubscribe@jakarta.apache.org
>>> Mailing List:     http://jakarta.apache.org/site/mail2.html#poi
>>> The Apache Jakarta Poi Project:  http://jakarta.apache.org/poi/
>>>
>>
>>
>>
>> ---------------------------------------------------------------------
>> To unsubscribe, e-mail: poi-user-unsubscribe@jakarta.apache.org
>> Mailing List:     http://jakarta.apache.org/site/mail2.html#poi
>> The Apache Jakarta Poi Project:  http://jakarta.apache.org/poi/
>>
>
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: poi-user-unsubscribe@jakarta.apache.org
> 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: poi-user-unsubscribe@jakarta.apache.org
Mailing List:     http://jakarta.apache.org/site/mail2.html#poi
The Apache Jakarta Poi Project:  http://jakarta.apache.org/poi/


Re: What is the state of the project?

Posted by Tom Muldoon <to...@firstbest.com>.
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: poi-user-unsubscribe@jakarta.apache.org
>>>> Mailing List:     http://jakarta.apache.org/site/mail2.html#poi
>>>> The Apache Jakarta Poi Project:  http://jakarta.apache.org/poi/
>>>>
>>>>
>>>
>>>
>>
>>
>> ---------------------------------------------------------------------
>> To unsubscribe, e-mail: poi-user-unsubscribe@jakarta.apache.org
>> Mailing List:     http://jakarta.apache.org/site/mail2.html#poi
>> The Apache Jakarta Poi Project:  http://jakarta.apache.org/poi/
>>
>
>
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: poi-user-unsubscribe@jakarta.apache.org
> Mailing List:     http://jakarta.apache.org/site/mail2.html#poi
> The Apache Jakarta Poi Project:  http://jakarta.apache.org/poi/
>


---------------------------------------------------------------------
To unsubscribe, e-mail: poi-user-unsubscribe@jakarta.apache.org
Mailing List:     http://jakarta.apache.org/site/mail2.html#poi
The Apache Jakarta Poi Project:  http://jakarta.apache.org/poi/


Re: What is the state of the project?

Posted by "Andrew C. Oliver" <ac...@buni.org>.
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: poi-user-unsubscribe@jakarta.apache.org
>>> Mailing List:     http://jakarta.apache.org/site/mail2.html#poi
>>> The Apache Jakarta Poi Project:  http://jakarta.apache.org/poi/
>>>
>>>
>>
>>
>
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: poi-user-unsubscribe@jakarta.apache.org
> Mailing List:     http://jakarta.apache.org/site/mail2.html#poi
> The Apache Jakarta Poi Project:  http://jakarta.apache.org/poi/
>



---------------------------------------------------------------------
To unsubscribe, e-mail: poi-user-unsubscribe@jakarta.apache.org
Mailing List:     http://jakarta.apache.org/site/mail2.html#poi
The Apache Jakarta Poi Project:  http://jakarta.apache.org/poi/


Re: What is the state of the project?

Posted by "Andrew C. Oliver" <ac...@buni.org>.
Not to be spammy but...we actually came very close to writing a VBA 
engine on 3 separate occasions.  Its not an inexpensive proposition but 
it is feasible. 

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: poi-user-unsubscribe@jakarta.apache.org
>>> Mailing List:     http://jakarta.apache.org/site/mail2.html#poi
>>> The Apache Jakarta Poi Project:  http://jakarta.apache.org/poi/
>>>
>>>
>>
>>
>
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: poi-user-unsubscribe@jakarta.apache.org
> Mailing List:     http://jakarta.apache.org/site/mail2.html#poi
> The Apache Jakarta Poi Project:  http://jakarta.apache.org/poi/
>



---------------------------------------------------------------------
To unsubscribe, e-mail: poi-user-unsubscribe@jakarta.apache.org
Mailing List:     http://jakarta.apache.org/site/mail2.html#poi
The Apache Jakarta Poi Project:  http://jakarta.apache.org/poi/


Re: What is the state of the project?

Posted by Tom Muldoon <to...@firstbest.com>.
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: poi-user-unsubscribe@jakarta.apache.org
>> Mailing List:     http://jakarta.apache.org/site/mail2.html#poi
>> The Apache Jakarta Poi Project:  http://jakarta.apache.org/poi/
>>
>>
>
>


---------------------------------------------------------------------
To unsubscribe, e-mail: poi-user-unsubscribe@jakarta.apache.org
Mailing List:     http://jakarta.apache.org/site/mail2.html#poi
The Apache Jakarta Poi Project:  http://jakarta.apache.org/poi/


Re: What is the state of the project?

Posted by "Andrew C. Oliver" <ac...@buni.org>.
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: poi-user-unsubscribe@jakarta.apache.org
> 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: poi-user-unsubscribe@jakarta.apache.org
Mailing List:     http://jakarta.apache.org/site/mail2.html#poi
The Apache Jakarta Poi Project:  http://jakarta.apache.org/poi/