1. @GetMapping("getExcel")
    2.     @ApiOperation(value = "获取excel")
    3.     public void getExcel(HttpServletResponse response) {
    5.         ExcelWriter writer = null;
    6.         ServletOutputStream out = null;
    7.         try {
    8.             List<Map<String, Object>> rows = service.getTarget(null);
    10.             // 通过工具类创建writer，默认创建xls格式
    11.             writer = ExcelUtil.getWriter();
    12.             // 自定义标题别名
    13.             writer.addHeaderAlias("api_id", "ID");
    14.             writer.addHeaderAlias("factory", "厂别");
    15.             writer.addHeaderAlias("type_name", "类别");
    16.             writer.addHeaderAlias("target", "目标");
    17.             writer.addHeaderAlias("max_limit", "最大值");
    18.             writer.addHeaderAlias("min_limit", "最小值");
    19.             // 一次性写出内容，使用默认样式，强制输出标题
    20.             writer.write(rows, true);
    21.             // out为OutputStream，需要写出到的目标流
    23.             // response为HttpServletResponse对象
    24.             response.setContentType("application/vnd.ms-excel;charset=utf-8");
    25.             // test.xls是弹出下载对话框的文件名，不能为中文，中文请自行编码
    26.             response.setHeader("Content-disposition",
    27.                     "attachment;filename=" + URLEncoder.encode("Flow标准数据导出.xls", "UTF-8"));// 设置头部信息
    29.             out = response.getOutputStream();
    31.             writer.flush(out, true);
    33.         } catch (IOException e) {
    34.             // TODO Auto-generated catch block
    35.             e.printStackTrace();
    36.         } finally {
    37.             if (writer != null) {
    38.                 // 关闭writer，释放内存
    39.                 writer.close();
    40.             }
    41.             if (out != null) {
    42.                 // 此处记得关闭输出Servlet流
    43.                 IoUtil.close(out);
    44.             }
    45.         }
    46.     }