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]
