Hi, I am new to POI API.In my project,I am using POI API to generate xsl format report. I am also facing same problem. I am using POI 3.0 Version. When I am trying to generate the reports,it throwing coredump and heapdump files in my websphere app server.But,the same report I am generating as html correctly(without POI API).
I know that problem with memory leakage.but,I don't know where exactly happening. is any problem with POI API . In my reports,the data valume is minimum 30,000 records. Thanks dnr. Marx, Stefan ext. MA Fa. Lynx-2 wrote: > > Hi Prashant, > > since I needed only lists that can be handled with Excel or a text > editor I switched to write the records as plain ASCII with tabs as > a column separator and named the files *.xls. When I open such > a file in my enviroment, Excel will read and display them without > complaining. But, of cause all possibilities of formatting in the > Excel file are lost. Code for this is fairly generic since you only > have to append your data to a StringBuffer (data + "\t" + data and > so on). > > May be a solution with Excel format is the new Excel API in the > 3.* version which seems to have a very smaller footprint in re- > source consumption. I played around with that version but couldn't > use it in production sinced it is still only a release version. > > Last not leased you may break up the huge data blocks in smaller > once by blocking them into chunks with convenient sizes. I can't > take this approach 'cause I program in a multi tier env. with stateless > http so adding a state (block handling) is cumbersome and expensive. > And you have to juggle with more than one file. > > hth, cu Stefan > > P.S.: Mailing this to the list may enhance the chance of getting > a better answer ;=). > > Stefan Marx > Marx Consulting (extern) > > REWE GROUP > Geschäftsbereich Konzern-Systeme > Funktionsbereich Business-Systeme > > REWE-Informations-Systeme GmbH > Humboldtstraße 140-144 - 51149 Köln > > Telefon: +49 (0)221 149 - 5953 > Telefax: +49 (0)221 149 - 97 5953 > E-Mail: [EMAIL PROTECTED] > www.rewe-group.com > > >> -----Ursprüngliche Nachricht----- >> Von: Prashant Revankar [SMTP:[EMAIL PROTECTED] >> Gesendet am: Donnerstag, 14. September 2006 06:31 >> An: [EMAIL PROTECTED] >> Betreff: AW: Handling very large Excel files with HSSF? >> >> Stefan, >> I am having similar program handling writing large >> data with POI .jar file. It errors out with out of >> memory usng HSSF. Did your problem get resolved and if >> so could you send me a code snippet. >> >> Regards >> Prashant >> >> __________________________________________________ >> Do You Yahoo!? >> Tired of spam? Yahoo! Mail has the best spam protection around >> http://mail.yahoo.com > > > --------------------------------------------------------------------- > To unsubscribe, e-mail: [EMAIL PROTECTED] > Mailing List: http://jakarta.apache.org/site/mail2.html#poi > The Apache Jakarta Poi Project: http://jakarta.apache.org/poi/ > > > -- View this message in context: http://www.nabble.com/AW%3A-Handling-very-large-Excel-files-with-HSSF--tf2270049.html#a6356802 Sent from the POI - User forum at Nabble.com. --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] Mailing List: http://jakarta.apache.org/site/mail2.html#poi The Apache Jakarta Poi Project: http://jakarta.apache.org/poi/
