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

来源：互联网发布：湖南青果软件好不好编辑：程序博客网时间：2024/05/18 00:15

今天在用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)