Hi,
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);
try{
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.