POI使用Excel模板文件循环输出行并导出Excel

[{"title":"（33个子文件39KB）POI使用Excel模板文件循环输出行并导出Excel","children":[{"title":"poiDemo2","children":[{"title":"src","children":[{"title":"main","children":[{"title":"java","children":[{"title":"com","children":[{"title":"sdut","children":[{"title":"PoiDemo2","children":[{"title":"ExcelExportDemo.java <span style='color:#111;'>1.22KB</span>","children":null,"spread":false},{"title":"ExcelReporter.java <span style='color:#111;'>4.90KB</span>","children":null,"spread":false}],"spread":true}],"spread":true}],"spread":true},{"title":"config","children":[{"title":"demo.xlsx <span style='color:#111;'>8.45KB</span>","children":null,"spread":false},{"title":"demo1.xlsx <span style='color:#111;'>6.54KB</span>","children":null,"spread":false}],"spread":true}],"spread":true},{"title":"main.iml <span style='color:#111;'>606B</span>","children":null,"spread":false}],"spread":true},{"title":"test","children":[{"title":"java","children":[{"title":"com","children":[{"title":"sdut","children":null,"spread":false}],"spread":true}],"spread":true}],"spread":true}],"spread":true},{"title":"pom.xml <span style='color:#111;'>4.39KB</span>","children":null,"spread":false},{"title":"out","children":[{"title":"production","children":[{"title":"main","children":[{"title":"config","children":[{"title":"demo.xlsx <span style='color:#111;'>8.45KB</span>","children":null,"spread":false}],"spread":true}],"spread":true}],"spread":true}],"spread":true},{"title":"target","children":[{"title":"classes","children":[{"title":"com","children":[{"title":"sdut","children":[{"title":"PoiDemo2","children":[{"title":"ExcelExportDemo.class <span style='color:#111;'>1.98KB</span>","children":null,"spread":false},{"title":"ExcelReporter.class <span style='color:#111;'>5.38KB</span>","children":null,"spread":false}],"spread":true}],"spread":true}],"spread":true}],"spread":true},{"title":"generated-sources","children":[{"title":"annotations","children":null,"spread":false}],"spread":true}],"spread":true},{"title":".idea","children":[{"title":"misc.xml <span style='color:#111;'>439B</span>","children":null,"spread":false},{"title":"encodings.xml <span style='color:#111;'>172B</span>","children":null,"spread":false},{"title":"libraries","children":[{"title":"Maven__com_github_virtuald_curvesapi_1_04.xml <span style='color:#111;'>539B</span>","children":null,"spread":false},{"title":"Maven__org_apache_poi_poi_3_17.xml <span style='color:#111;'>477B</span>","children":null,"spread":false},{"title":"Maven__commons_lang_commons_lang_2_6.xml <span style='color:#111;'>525B</span>","children":null,"spread":false},{"title":"Maven__org_apache_ant_ant_1_8_2.xml <span style='color:#111;'>484B</span>","children":null,"spread":false},{"title":"Maven__org_apache_ant_ant_launcher_1_8_2.xml <span style='color:#111;'>547B</span>","children":null,"spread":false},{"title":"Maven__org_apache_poi_poi_ooxml_3_17.xml <span style='color:#111;'>519B</span>","children":null,"spread":false},{"title":"Maven__org_apache_xmlbeans_xmlbeans_2_6_0.xml <span style='color:#111;'>539B</span>","children":null,"spread":false},{"title":"Maven__stax_stax_api_1_0_1.xml <span style='color:#111;'>479B</span>","children":null,"spread":false},{"title":"Maven__org_apache_poi_poi_examples_3_17.xml <span style='color:#111;'>540B</span>","children":null,"spread":false},{"title":"Maven__commons_codec_commons_codec_1_10.xml <span style='color:#111;'>543B</span>","children":null,"spread":false},{"title":"Maven__org_apache_poi_poi_scratchpad_3_17.xml <span style='color:#111;'>554B</span>","children":null,"spread":false},{"title":"Maven__org_apache_commons_commons_collections4_4_1.xml <span style='color:#111;'>605B</span>","children":null,"spread":false},{"title":"Maven__org_apache_poi_ooxml_schemas_1_3.xml <span style='color:#111;'>540B</span>","children":null,"spread":false},{"title":"Maven__org_hamcrest_hamcrest_core_1_3.xml <span style='color:#111;'>532B</span>","children":null,"spread":false},{"title":"Maven__org_apache_poi_poi_ooxml_schemas_3_17.xml <span style='color:#111;'>575B</span>","children":null,"spread":false},{"title":"Maven__org_apache_poi_poi_excelant_3_17.xml <span style='color:#111;'>540B</span>","children":null,"spread":false},{"title":"Maven__junit_junit_4_11.xml <span style='color:#111;'>455B</span>","children":null,"spread":false}],"spread":false},{"title":"workspace.xml <span style='color:#111;'>32.40KB</span>","children":null,"spread":false},{"title":"uiDesigner.xml <span style='color:#111;'>8.59KB</span>","children":null,"spread":false},{"title":"inspectionProfiles","children":null,"spread":false},{"title":"compiler.xml <span style='color:#111;'>673B</span>","children":null,"spread":false},{"title":"modules.xml <span style='color:#111;'>256B</span>","children":null,"spread":false}],"spread":true},{"title":"poiDemo2.iml <span style='color:#111;'>2.33KB</span>","children":null,"spread":false}],"spread":true}],"spread":true}]