模板
List supplyAreaList= saBiz.getSupplyAreaById(supplyAreaId);
String templateDir= "D:/excel/template/SupplyAreaDynaMergeCells.xls";
String targetDir="D:/excel/export/testDynaMergeCells.xls";
InputStream is = newFileInputStream(templateDir);
Map beans = new HashMap();
beans.put("suplyArea", supplyAreaList);
//关联模板
XLSTransformertransformer = new XLSTransformer();
HSSFWorkbook workBook= transformer.transformXLS(is, beans);
OutputStream os = newFileOutputStream(targetDir);
workBook.write(os);
os.close();
导出结果