jQuery in Action, 3rd edition
The moose likes Other Open Source Projects and the fly likes large Excel file read Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login

Win a copy of OCA Java SE 8 Programmer I Study Guide this week in the OCAJP 8 forum!
JavaRanch » Java Forums » Products » Other Open Source Projects
Bookmark "large Excel file read" Watch "large Excel file read" New topic

large Excel file read

praveenkl kumark

Joined: Mar 28, 2014
Posts: 1

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);
if (extention.equalsIgnoreCase("xlsx"))
XSSFWorkbook wb = new XSSFWorkbook(myInput);
XSSFSheet sheet = wb.getSheetAt(0);
ExcelServiceImpl.saveExceldataxlxsdata(sheet,httpS ervletRequest);
else if (extention.equalsIgnoreCase("xls"))
POIFSFileSystem fileSystem = new POIFSFileSystem(myInput);
HSSFWorkbook myWorkBook = new HSSFWorkbook(fileSystem);
HSSFSheet mySheet = myWorkBook.getSheetAt(0);
ExcelServiceImpl.saveExcelsdata(mySheet,httpServle tRequest);

please help me.
Ulf Dittmer

Joined: Mar 22, 2005
Posts: 42958
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.
I agree. Here's the link: http://aspose.com/file-tools
subject: large Excel file read
It's not a secret anymore!