Performance of xssfworkbook.write was improved in POI-3.7 Details can be found here: http://markmail.org/message/3o7o4t7laesacvwl
Upgrade your system to POI-3.7 or to the latest 3.8-beta3. Yegor On Fri, Jun 17, 2011 at 8:42 AM, dpront <[email protected]> wrote: > Hi Guys, > > I have a simple code that reads and writes xlsm file. But the problem is, > the program is taking too long to create the output xlsm file (average time > is 8minutes). By the way, I have substituted the > poi-ooxml-schemas-3.6-20091214.jar into ooxml-schemas-1.1.jar because that > jar has more class files than the poi-ooxml-schemas-3.6-2009121.jar. > > The input xlsm file got a size of 1.4MB, has 9 worksheets on it and on > every worksheet has an image of around 1x1 inch. On every worksheet also, > there are some column that has drop down box that consists of legal inputs. > > My code is here: > http://pastebin.com/mbXJsHf3 > > Thanks. > > -- > View this message in context: > http://apache-poi.1045710.n5.nabble.com/taking-too-long-to-create-xlsm-tp4497635p4497635.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] > > --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
