[prev in list] [next in list] [prev in thread] [next in thread] 

List:       poi-user
Subject:    Using SXSSF to replace existing sheet of excel file
From:       user808 <leenaveluri () yahoo ! com>
Date:       2015-03-24 4:51:13
Message-ID: 1427172673747-5718389.post () n5 ! nabble ! com
[Download RAW message or body]

I am trying to write data into a sheet of an existing excel file using SXSSF.
Since the excel file could be very large, I get Out of memory error on the
1st line below:
XSSFWorkbook xssfWb = new XSSFWorkbook("Template.xlsx");
Workbook wb = new SXSSFWorkbook(xssfWb);

I looked at the BigGridDemo example which addresses my issue of
replacing/writing a single sheet to an existing excel file on the disk
instead of loading the whole workbook. Is it possible to achieve the same
using SXSSF api.

Thanks!




--
View this message in context: \
http://apache-poi.1045710.n5.nabble.com/Using-SXSSF-to-replace-existing-sheet-of-excel-file-tp5718389.html
 Sent from the POI - User mailing list archive at Nabble.com.

---------------------------------------------------------------------
To unsubscribe, e-mail: user-unsubscribe@poi.apache.org
For additional commands, e-mail: user-help@poi.apache.org


[prev in list] [next in list] [prev in thread] [next in thread]