(急!求救!)用POI和jxl提取excel文档,文件大小有限制,内存溢出了:(
用POI和jxl提取excel文档,POI包只能加载3M,用jxl能加载提取18M的文档。超过这些上限会报内在溢出,请问如果解决?
poi代码溢出处:
public ArrayList getExcelPOI(BufferedInputStream is) {
POIFSFileSystem fs = new POIFSFileSystem(is);//此处加载时就溢出了
HSSFWorkbook wb = new HSSFWorkbook(fs,true);
...
}
jxl代码溢出处:
public ArrayList getExcel(BufferedInputStream is) {
Workbook wb = Workbook.getWorkbook(is);
...
}
项目快结项了,突然测出此问题。特急!求高手相助!万分感谢!