Would someone point out to me what changes would i need to make in order to preserve the macros that are present in the original EXCEL file.
Thanks Romin. -----Original Message----- From: Romin Irani [mailto:[EMAIL PROTECTED]] Sent: Thursday, May 16, 2002 10:17 AM To: POI Users List Subject: RE: Excel File With Macros - schedule Any idea if this change would be implemented in the next dev release or something ? <CARD NAME="Romin Irani" EMAIL="[EMAIL PROTECTED]"/> -----Original Message----- From: Andrew C. Oliver [mailto:[EMAIL PROTECTED]] Sent: Wednesday, May 15, 2002 5:09 PM To: POI Users List Subject: Re: Excel File With Macros - schedule Romin Irani wrote: >Hi, > >Is it possible to give us some idea on when support is planned for writing >Excel Files containing Macros. > I've no plans for this specifically and I know of no one planning to do this for 2.0. It is an opportunity for contributiong. > > >In our current project, I am using POI to populate certain cells in the >spreadsheet with backend data. The problem is that the spreadsheet has some >prebuilt macros which cannot be removed. And once we write the spreadsheet >file using POI, the macros are gone. > > This should be easy to solve by adapting the HSSFWorkbook to preserve other entries in the underlying POIFS filesystem. I suspect this is about a 10-20 line code change. -Andy >I am using POI-1.5, JDK 1.4, WinNT > >Thanks >Romin. > > >-- >To unsubscribe, e-mail: <mailto:[EMAIL PROTECTED]> >For additional commands, e-mail: <mailto:[EMAIL PROTECTED]> > > > > -- To unsubscribe, e-mail: <mailto:[EMAIL PROTECTED]> For additional commands, e-mail: <mailto:[EMAIL PROTECTED]> -- To unsubscribe, e-mail: <mailto:[EMAIL PROTECTED]> For additional commands, e-mail: <mailto:[EMAIL PROTECTED]> -- To unsubscribe, e-mail: <mailto:[EMAIL PROTECTED]> For additional commands, e-mail: <mailto:[EMAIL PROTECTED]>
