Start with o.a.c.p.h.usermodel.HSSFWorkbook/o.a.c.p.h.model.Workbook. Anywhere there are calls to org.apache.poi.poifs.* make sure its getting ALL files (within the OLE 2 CDF) and not just "Workbook" -- According to my understanding the Macros are stored as seperate "files" in the XLS filesystem. Does that make sense?
Romin Irani wrote: >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]> > > > > -- To unsubscribe, e-mail: <mailto:[EMAIL PROTECTED]> For additional commands, e-mail: <mailto:[EMAIL PROTECTED]>
