You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@poi.apache.org by Dong Chen <Do...@ariba.com> on 2004/05/13 02:24:28 UTC
Use Macro in Excel through POI
Hi,
I'm new to POI/HSSF and this mailing list.
I have some questions regarding using Macros in Excel through POI:
1) Can I use POI to write (export) VBScripts macros to an Excel spreadsheet
(.xls) file? If yes, then what version of POI (HSSF) do I need?
2) If I aleady have a separately developed Excel spreadsheet with embeded
VBScript macros, can I use POI to write (export) additional non-macro data
to that Excel file without affecting (overwriting or losing) the macros?
Thanks!
-Dong
---------------------------------------------------------------------
To unsubscribe, e-mail: poi-dev-unsubscribe@jakarta.apache.org
For additional commands, e-mail: poi-dev-help@jakarta.apache.org
Re: Use Macro in Excel through POI
Posted by Avik Sengupta <av...@itellix.com>.
> 1) Can I use POI to write (export) VBScripts macros to an Excel spreadsheet
> (.xls) file? If yes, then what version of POI (HSSF) do I need?
>
Nope.
> 2) If I aleady have a separately developed Excel spreadsheet with embeded
> VBScript macros, can I use POI to write (export) additional non-macro data
> to that Excel file without affecting (overwriting or losing) the macros?
>
Yep!
---------------------------------------------------------------------
To unsubscribe, e-mail: poi-user-unsubscribe@jakarta.apache.org
For additional commands, e-mail: poi-user-help@jakarta.apache.org
AW: Use Macro in Excel through POI
Posted by Karl-Heinz Zengerle <ka...@sawag.com>.
Hi Dong.
Excel macros aren't lost when you modify Excel files using POI (2).
I never had to use (1).
Regards, Karl-Heinz.
-----Ursprüngliche Nachricht-----
Von: Dong Chen [mailto:Dong.Chen@ariba.com]
Gesendet: Donnerstag, 13. Mai 2004 02:24
An: 'poi-user@jakarta.apache.org'
Cc: 'poi-dev@jakarta.apache.org'
Betreff: Use Macro in Excel through POI
Hi,
I'm new to POI/HSSF and this mailing list.
I have some questions regarding using Macros in Excel through POI:
1) Can I use POI to write (export) VBScripts macros to an Excel
spreadsheet
(.xls) file? If yes, then what version of POI (HSSF) do I need?
2) If I aleady have a separately developed Excel spreadsheet with
embeded
VBScript macros, can I use POI to write (export) additional non-macro
data
to that Excel file without affecting (overwriting or losing) the macros?
Thanks!
-Dong
---------------------------------------------------------------------
To unsubscribe, e-mail: poi-user-unsubscribe@jakarta.apache.org
For additional commands, e-mail: poi-user-help@jakarta.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: poi-user-unsubscribe@jakarta.apache.org
For additional commands, e-mail: poi-user-help@jakarta.apache.org