sam_yu 发表于 2015-11-14 10:08:52

Apache POI组件读取Excel文档内存溢出

  今天在用POI处理excel时,发生内存溢出,excel大概有3万多行
  Exception in thread "main" java.lang.OutOfMemoryError: Java heap space
at org.apache.poi.hssf.usermodel.HSSFCell.<init>(HSSFCell.java:180)
at org.apache.poi.hssf.usermodel.HSSFRow.createCellFromRecord(HSSFRow.java:211)
at org.apache.poi.hssf.usermodel.HSSFSheet.setPropertiesFromSheet(HSSFSheet.java:210)
at org.apache.poi.hssf.usermodel.HSSFSheet.<init>(HSSFSheet.java:120)
at org.apache.poi.hssf.usermodel.HSSFWorkbook.<init>(HSSFWorkbook.java:292)
at org.apache.poi.hssf.usermodel.HSSFWorkbook.<init>(HSSFWorkbook.java:243)
at org.apache.poi.hssf.usermodel.HSSFWorkbook.<init>(HSSFWorkbook.java:187)
at org.apache.poi.hssf.usermodel.HSSFWorkbook.<init>(HSSFWorkbook.java:169)
at com.disease.basedata.readexcel.ExcelReader.readExcelTitle(ExcelReader.java:35)
at com.disease.basedata.main.Test.main(Test.java:30)         版权声明:本文为博主原创文章,未经博主允许不得转载。
页: [1]
查看完整版本: Apache POI组件读取Excel文档内存溢出