Hi Everyone,
In the application I am building, I am writing huge data to the csv file. I am using below writer to accomplish my task. In csv files we can write data till 1048576 rows, and later it throws
java heap memory issue. Can anyone suggest on how to create a new sheet in the csv, and later move data (after 1048576) to this new sheet.
response.setContentType("text/csv");
response.setHeader("CACHE_CONTROL", " NO_CACHE");
response.setHeader("PRAGMA", " NO_CACHE");
response.setHeader("Content-Disposition",
"attachment; filename= data.csv");
OutputStreamWriter outWriter = new OutputStreamWriter(output);
BufferedWriter writer = new BufferedWriter(outWriter, (int) MEG);