I am trying to upload a excel file if it as 100000 of rows then a get the java heap space error
how will resolve this
this is my code.
FileInputStream myInput = new FileInputStream(fileName);
XSSFWorkbook wb = new XSSFWorkbook(myInput);
XSSFSheet sheet = wb.getSheetAt(0);
else if (extention.equalsIgnoreCase("xls"))
POIFSFileSystem fileSystem = new POIFSFileSystem(myInput);
HSSFWorkbook myWorkBook = new HSSFWorkbook(fileSystem);
HSSFSheet mySheet = myWorkBook.getSheetAt(0);
please help me.
posted 1 year ago
Welcome to JavaRanch.
How much memory have you allocated to the JVM? POI is known to use lots of memory; try upping it substantially.
Also, having separate code for handling XLS and XLSX is unnecessarily complicated. Use the classes in the org.apache.poi.ss package instead which can handle both varieties.
I also question a design that uses Excel files with 100.000 rows - no human being should be subjected to such files, and if the file is not touched by humans, then XLS/XLSX is not the best way to store the data.