easpoi exce模板导出, 适用固定复杂表头报表信息导出

1.创建导出的空模板信息（只有表头信息的空exce,/module/amount.xslx)
2.controller

public void exportRecList(RecListQueryVO vo, HttpServletResponse response)
			throws Exception {
	//需要导出的数据结果
	List<JtRecListVo> pos = recListService.selectRecListPagerByParams(vo);
	//底部合计
	List<JtRecListVo> footer = recListService.selectRecListTotalByParams(vo);
	//获取导出模板
	TemplateExportParams params = new TemplateExportParams("module/amount.xlsx");
	//放入导出结果信息
	Map<String,Object> data = new HashMap<String, Object>();
	data.put("list", pos);
	pos.addAll(footer);
	Workbook workbook = ExcelExportUtil.exportExcel(params, data);
    response.setContentType("applicationnd.ms-excel"); // 改成输出excel文件
     String fileName = java.net.URLEncoder.encode("明细", "UTF-8");
     response.setHeader("Content-disposition",
             "attachment; filename=" + fileName + ".xls");// 03版本后缀xls，之后的xlsx
     OutputStream out = response.getOutputStream();
     workbook.write(out);
}

3.实例图片

ExcelExportUtil.java

import cn.afterturn.easypoi.excel.ExcelExportUtil;