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: [email protected] For additional commands, e-mail: [email protected]
