POI导出Excel万级数据分页实现处置内存溢出下场

[{"title":"（22个子文件2.36MB）POI导出Excel万级数据分页实现解决内存溢出问题","children":[{"title":"尚明导出Excel的demo","children":[{"title":"ExcelTest","children":[{"title":"src","children":[{"title":"com","children":[{"title":"rxx","children":[{"title":"test","children":[{"title":"AddData.java <span style='color:#111;'>1.41KB</span>","children":null,"spread":false},{"title":"GetData.java <span style='color:#111;'>2.80KB</span>","children":null,"spread":false},{"title":"DataModel.java <span style='color:#111;'>3.28KB</span>","children":null,"spread":false}],"spread":true}],"spread":true}],"spread":true}],"spread":true},{"title":".classpath <span style='color:#111;'>501B</span>","children":null,"spread":false},{"title":".mymetadata <span style='color:#111;'>300B</span>","children":null,"spread":false},{"title":".settings","children":[{"title":"org.eclipse.wst.jsdt.ui.superType.container <span style='color:#111;'>49B</span>","children":null,"spread":false},{"title":"org.eclipse.wst.jsdt.ui.superType.name <span style='color:#111;'>6B</span>","children":null,"spread":false},{"title":".jsdtscope <span style='color:#111;'>500B</span>","children":null,"spread":false},{"title":"org.eclipse.jdt.core.prefs <span style='color:#111;'>330B</span>","children":null,"spread":false}],"spread":true},{"title":".myeclipse","children":null,"spread":false},{"title":".project <span style='color:#111;'>1.38KB</span>","children":null,"spread":false},{"title":"WebRoot","children":[{"title":"META-INF","children":[{"title":"MANIFEST.MF <span style='color:#111;'>36B</span>","children":null,"spread":false}],"spread":true},{"title":"index.jsp <span style='color:#111;'>834B</span>","children":null,"spread":false},{"title":"PoiTest.jsp <span style='color:#111;'>4.41KB</span>","children":null,"spread":false},{"title":"download.jsp <span style='color:#111;'>2.26KB</span>","children":null,"spread":false},{"title":"first.jsp <span style='color:#111;'>1.05KB</span>","children":null,"spread":false},{"title":"WEB-INF","children":[{"title":"classes","children":[{"title":"com","children":[{"title":"rxx","children":[{"title":"test","children":[{"title":"AddData.class <span style='color:#111;'>2.08KB</span>","children":null,"spread":false},{"title":"DataModel.class <span style='color:#111;'>4.67KB</span>","children":null,"spread":false},{"title":"GetData.class <span style='color:#111;'>4.29KB</span>","children":null,"spread":false}],"spread":false}],"spread":false}],"spread":false}],"spread":false},{"title":"lib","children":[{"title":"classes12.jar <span style='color:#111;'>1.35MB</span>","children":null,"spread":false},{"title":"poi2.jar <span style='color:#111;'>1.13MB</span>","children":null,"spread":false}],"spread":false},{"title":"web.xml <span style='color:#111;'>371B</span>","children":null,"spread":false}],"spread":false}],"spread":true}],"spread":true},{"title":"testdata.dmp <span style='color:#111;'>2.38MB</span>","children":null,"spread":false}],"spread":true}],"spread":true}]