导出excel通常使用的是apache poi,但是poi的api相当复杂，所以当导出的excel样式比较复杂时，写起来就比较头疼了，这里推荐使用easypoi, 可以很方便的根据模板来导出复杂excel

文档地址: 1.1 介绍 - Powered by MinDoc

我们要实现如图所示效果，该怎么实现呢

 第一步,导入依赖

<dependency><groupId>cn.afterturn</groupId><artifactId>easypoi-spring-boot-starter</artifactId><version>4.5.0</version>
</dependency>

第二步，新建excel模板，然后写入内容

如果是变量，就用双大括号包裹变量，如果是列表，则使用$fe指令,maplist是变量名,t.id是要输出的字段，最后以t.hdje}}结果表示结束

模板指令文档:EasyPoi教程_V1.0

示例模板下载地址:  src/test/resources/WEB-INF/doc/专项支出用款申请书_map.xls · 悟耘开源/easypoi-test - Gitee.com

 

第三步，获取数据，写入输出流

public class ExportController extends BaseController {@Operation(summary = "导出支出用款申请书")@GetMapping("exportPayForm")public void exportPayForm(HttpServletRequest request, HttpServletResponse response) throws IOException {TemplateExportParams params = new TemplateExportParams("template/专项支出用款申请书_map.xls");Map<String, Object> map = new HashMap<String, Object>();map.put("date", "2014-12-25");map.put("money", 2000000.00);map.put("upperMoney", "贰佰万");map.put("company", "执笔潜行科技有限公司");map.put("bureau", "财政局");map.put("person", "JueYue");map.put("phone", "1879740****");List<Map<String, String>> listMap = new ArrayList<Map<String, String>>();for (int i = 0; i < 4; i++) {Map<String, String> lm = new HashMap<String, String>();lm.put("id", i + 1 + "");lm.put("zijin", i * 10000 + "");lm.put("bianma", "A001");lm.put("mingcheng", "设计");lm.put("xiangmumingcheng", "EasyPoi " + i + "期");lm.put("quancheng", "开源项目");lm.put("sqje", i * 10000 + "");lm.put("hdje", i * 10000 + "");listMap.add(lm);}map.put("maplist", listMap);Workbook workbook = ExcelExportUtil.exportExcel(params, map);addFileHeader(request, response, "专项支出用款申请书.xls", "application/octet-stream");workbook.write(response.getOutputStream());}
}public void addFileHeader(HttpServletRequest request, HttpServletResponse response,     String fileName, String contentType) {try {String agent = request.getHeader("USER-AGENT").toLowerCase();response.setContentType(contentType);String codedFileName = java.net.URLEncoder.encode(fileName, "UTF-8");if (agent.contains("firefox")) {response.setCharacterEncoding("utf-8");response.setHeader("content-disposition", "attachment;filename=" + new String(fileName.getBytes(), "ISO8859-1"));} else {response.setHeader("content-disposition", "attachment;filename=" + codedFileName);}} catch (Exception e) {e.printStackTrace();}}