In the HEAD there is code which combines all rows and columns into one object and uses the smallest possible type for each. Its not mature yet and some features aren't supported by it.
-Andy -- Andrew C. Oliver http://www.superlinksoftware.com/poi.jsp Custom enhancements and Commercial Implementation for Jakarta POI http://jakarta.apache.org/poi For Java and Excel, Got POI? The views expressed in this email are those of the author and are almost definitely not shared by the Apache Software Foundation, its board or its general membership. In fact they probably most definitively disagree with everything espoused in the above email. > From: "Ryan Crumley" <[EMAIL PROTECTED]> > Reply-To: "POI Users List" <[EMAIL PROTECTED]> > Date: Mon, 26 Apr 2004 17:23:26 -0500 > To: "POI Users List" <[EMAIL PROTECTED]> > Subject: RE: POI Optimizations > > I am experiencing quite a few problems with POI, speed, and memory usage > lately. Thank you for sharing your work. > > I have a question regarding the first optimization that involves > removing the empty rows. Is POI creating all the empty rows when you do > something like: > > sheet.createRow(0); > sheet.createRow(10); > sheet.createRow(20); > > Or is it your client code that is the culprit? The reason I ask is that > I have an issue where POI is using so much memory an OOM exception is > thrown. After analyzing the heap dump a majority of that memory is un > HSSFCell objects (I have not performed a heap dump after adding your > optimizations but I am still experiencing the OOM exception so I suspect > there is still an issue). I am wondering if there could be a similar > situation with a bunch of empty HSSFCell objects being created. Could > you give me any pointers in how I can figure out if a similar situation > is occurring but with cells instead of rows? > > Thanks, > ryan > > -----Original Message----- > From: David Medinets [mailto:[EMAIL PROTECTED] > Sent: Monday, April 26, 2004 12:25 PM > To: [EMAIL PROTECTED]; [EMAIL PROTECTED] > Subject: POI Optimizations > > Hi. I've posted several POI optimizations to my http://www.codebits.com/ > website. Please consider them public domain. If they are useful, please > feel free to incorporate them into the official codebase. > > thanks, > David Medinets > Senior Software Developer > WorldWide Retail Exchange > 703-234-5216 > > --------------------------------------------------------------------- > 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] > --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
