Hi, 1) Try to extract the part around "wb.write(fileOut);" to another method, so profiler can show if exactly write() method is perfomance bottlecheck.
2) Personally i think the biggest problem is a lot of calls to shiftRow() operation. Can profiler show the time spent for this method execution? If it's the case, then try to replace deleting rows with coping "good" rows to new sheet and replacing old one with new. Best regards, Sergey. On Wed, Jun 22, 2011 at 1:55 PM, dpront <[email protected]> wrote: > Hi, > > I have already used the poi-3.8 but it still yield the same result. > > This is the profiling result of my code: > > http://s760.photobucket.com/albums/xx242/gerardagda/?action=view¤t=Profileresult.jpg > > And here is my latest code so far: > http://privatepaste.com/2167f7bc2c > > Thanks. > > -- > View this message in context: > http://apache-poi.1045710.n5.nabble.com/taking-too-long-to-create-xlsm-tp4497635p4513516.html > Sent from the POI - User mailing list archive at Nabble.com. > > --------------------------------------------------------------------- > To unsubscribe, e-mail: [email protected] > For additional commands, e-mail: [email protected] > > -- Sergey Vladimirov --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
