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]
