Use SXSSF: http://poi.apache.org/spreadsheet/how-to.html#sxssf
Yegor On Mon, Feb 27, 2012 at 1:18 PM, Bhanu <[email protected]> wrote: > HI All, > > While processing the Excel sheets in uploading and downloading functionality > in web based application I am getting out of memory issue. Increasing the > heap size will fix this issue but due to some other reasons we are limiting > the heap size. So I am looking for work around for handling the large file. > I have tried BigGridDemo examples as well,For current requirement it is not > suitable. Here is the overview of the problem. > > We have 3.2 MB Excel sheet template which contains the 21 sheets with lot of > charts, styles and static data. Among the 21 sheets, in Java we are > interested in 3 sheets(contains plain text cells) which data will be pulled > and populated from the database. After downloading business team will use > this data for calculation purpose in other sheets .To populate this 3 > sheets we are loading the whole workbook and we are getting the memory > exception. > > Please let me know if there are any other ways to handle this requirement > with very minimal memory. > > > Thanks in advance. > > -Bhanu > > > -- > View this message in context: > http://apache-poi.1045710.n5.nabble.com/Need-work-around-for-out-of-memory-issue-tp5518375p5518375.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]
