Hi, I solve my problem I used workbook.getBytes() method, this method do not save macro in xls file.
instead I use ByteArrayOutputStream class for saving outout file Thanks for your attention On Sat, Oct 2, 2010 at 12:23 PM, Shayesteh Alavi <[email protected]>wrote: > I appreciate if anyone can help me to solve my problem, its really > emergency > > Thank you > > > On Wed, Sep 29, 2010 at 9:28 AM, Shayesteh Alavi < > [email protected]> wrote: > >> >> Thanks for reply >> I attach both xls files(template file with macro(40K) and output file >> edited with POI(20K)) >> (OS is winXP) >> >> >> >> On Tue, Sep 28, 2010 at 5:30 PM, David Fisher <[email protected]>wrote: >> >>> We have no problems preserving a Macro contained within an XLS. We have >>> no problems with signed macros. >>> >>> Please post some code so that we can have an idea what you are doing. For >>> example, you need to modify your macro containing file and not copy it >>> within POI. >>> >>> Regards, >>> Dave >>> >>> On Sep 28, 2010, at 5:09 AM, Shayesteh Alavi wrote: >>> >>> > Hi, >>> > I have an excel file as a template with Macro inside it. >>> > when I want to edit my file with POI (for example add new rows), the >>> macro >>> > has been removed in output file. >>> > Can anybody knows how to fix this problem? >>> > >>> > Thank you in advance >>> >>> >>> --------------------------------------------------------------------- >>> To unsubscribe, e-mail: [email protected] >>> For additional commands, e-mail: [email protected] >>> >>> >> >
