SXSSF is designed for writing large volumes of data. If you need to read and update content then give your JVM more memory and use XSSF
Yegor On Mon, Nov 7, 2011 at 3:27 PM, mayankmails <[email protected]> wrote: > Thanks for Response. > > I want to know how we can user SXSSF API to read xlsx and and write values > in it.In above example I have used XSSFWorkbook to read xlsx file and then > used SXSSFWorkbook to write data in it. > > But it didn't worked.It just created copy of xlsx file i have read using > XSSFWorkbook. > > What is the correct approach to get the updated xlsx file. > > > > -- > View this message in context: > http://apache-poi.1045710.n5.nabble.com/How-to-user-SXSSFWorkbook-for-updating-existing-excel-file-tp4954431p4971019.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]
