运用Poi读取大数据量excel的方法

[{"title":"（43个子文件10.46MB）使用Poi读取大数据量excel的方法","children":[{"title":"HarlanPoi","children":[{"title":".project <span style='color:#111;'>385B</span>","children":null,"spread":false},{"title":"poi-ooxml-schemas-3.11-20141221.jar <span style='color:#111;'>5.34MB</span>","children":null,"spread":false},{"title":"poi-ooxml-3.11-20141221.jar <span style='color:#111;'>1.15MB</span>","children":null,"spread":false},{"title":"src","children":[{"title":"com","children":[{"title":"harlan","children":[{"title":"poi","children":[{"title":"excelutil","children":[{"title":"ExcelProcessor.java <span style='color:#111;'>1.97KB</span>","children":null,"spread":false},{"title":"ExcelRowProcessor.java <span style='color:#111;'>403B</span>","children":null,"spread":false},{"title":"XCell.java <span style='color:#111;'>635B</span>","children":null,"spread":false},{"title":"ReadExcelUtil.java <span style='color:#111;'>1.38KB</span>","children":null,"spread":false},{"title":"StringUtil.java <span style='color:#111;'>782B</span>","children":null,"spread":false},{"title":"Excel2003RowProcessor.java <span style='color:#111;'>9.99KB</span>","children":null,"spread":false},{"title":"Excel2007RowProcessor.java <span style='color:#111;'>6.07KB</span>","children":null,"spread":false},{"title":"XRow.java <span style='color:#111;'>635B</span>","children":null,"spread":false}],"spread":true},{"title":"util","children":[{"title":"xls","children":[{"title":"HxlsAbstract.java <span style='color:#111;'>8.82KB</span>","children":null,"spread":false},{"title":"XxlsAbstract.java <span style='color:#111;'>4.36KB</span>","children":null,"spread":false}],"spread":true}],"spread":true},{"title":"xls","children":[{"title":"Xls2Do.java <span style='color:#111;'>1.34KB</span>","children":null,"spread":false},{"title":"XxlsPrint.java <span style='color:#111;'>617B</span>","children":null,"spread":false},{"title":"XxlsBig.java <span style='color:#111;'>3.98KB</span>","children":null,"spread":false},{"title":"HxlsBig.java <span style='color:#111;'>4.33KB</span>","children":null,"spread":false},{"title":"HxlsPrint.java <span style='color:#111;'>941B</span>","children":null,"spread":false}],"spread":true}],"spread":true}],"spread":true}],"spread":true}],"spread":true},{"title":"xmlbeans-2.6.0.jar <span style='color:#111;'>2.60MB</span>","children":null,"spread":false},{"title":".settings","children":[{"title":"org.eclipse.jdt.core.prefs <span style='color:#111;'>598B</span>","children":null,"spread":false}],"spread":true},{"title":"xercesImpl.jar <span style='color:#111;'>1.15MB</span>","children":null,"spread":false},{"title":".classpath <span style='color:#111;'>662B</span>","children":null,"spread":false},{"title":"poi-3.11-20141221.jar <span style='color:#111;'>1.98MB</span>","children":null,"spread":false},{"title":"bin","children":[{"title":"com","children":[{"title":"harlan","children":[{"title":"poi","children":[{"title":"excelutil","children":[{"title":"StringUtil.class <span style='color:#111;'>1.33KB</span>","children":null,"spread":false},{"title":"Excel2003RowProcessor.class <span style='color:#111;'>7.00KB</span>","children":null,"spread":false},{"title":"ExcelProcessor$MyExcel2007RowProcessor.class <span style='color:#111;'>1.04KB</span>","children":null,"spread":false},{"title":"ExcelRowProcessor.class <span style='color:#111;'>350B</span>","children":null,"spread":false},{"title":"ReadExcelUtil.class <span style='color:#111;'>1.68KB</span>","children":null,"spread":false},{"title":"XRow.class <span style='color:#111;'>1.21KB</span>","children":null,"spread":false},{"title":"Excel2003RowProcessor$MyHSSFListener.class <span style='color:#111;'>7.90KB</span>","children":null,"spread":false},{"title":"Excel2007RowProcessor.class <span style='color:#111;'>4.47KB</span>","children":null,"spread":false},{"title":"Excel2007RowProcessor$MyHander.class <span style='color:#111;'>4.66KB</span>","children":null,"spread":false},{"title":"ExcelProcessor.class <span style='color:#111;'>1.93KB</span>","children":null,"spread":false},{"title":"ExcelProcessor$MyExcel2003RowProcessor.class <span style='color:#111;'>1.04KB</span>","children":null,"spread":false},{"title":"XCell.class <span style='color:#111;'>957B</span>","children":null,"spread":false}],"spread":false},{"title":"util","children":[{"title":"xls","children":[{"title":"XxlsAbstract.class <span style='color:#111;'>5.12KB</span>","children":null,"spread":false},{"title":"HxlsAbstract.class <span style='color:#111;'>8.11KB</span>","children":null,"spread":false}],"spread":false}],"spread":false},{"title":"xls","children":[{"title":"XxlsPrint.class <span style='color:#111;'>1.46KB</span>","children":null,"spread":false},{"title":"HxlsBig.class <span style='color:#111;'>4.15KB</span>","children":null,"spread":false},{"title":"XxlsBig.class <span style='color:#111;'>3.63KB</span>","children":null,"spread":false},{"title":"HxlsPrint.class <span style='color:#111;'>1.72KB</span>","children":null,"spread":false},{"title":"Xls2Do.class <span style='color:#111;'>2.02KB</span>","children":null,"spread":false}],"spread":false}],"spread":true}],"spread":true}],"spread":true}],"spread":true},{"title":"xml-apis.jar <span style='color:#111;'>189.65KB</span>","children":null,"spread":false}],"spread":false}],"spread":true}]