swagger hutool excel导出

pom导入

            <dependency>
                <groupId>cn.hutool</groupId>
                <artifactId>hutool-poi</artifactId>
                <version>5.8.11</version>
            </dependency>

java控制层

    @ApiOperation(value = "hutool导出",produces = "application/octet-stream")
    @GetMapping("/hutool/export")
    public void hutoolExport(ExcelDTO excelDTO, HttpServletResponse response) throws IOException {

        //查询所有用户
        Map<String, Object> row1 = new LinkedHashMap<>();
        row1.put("username", "张三");
        row1.put("password", 23);
        row1.put("nickname", 88.32);
        row1.put("email", true);


        Map<String, Object> row2 = new LinkedHashMap<>();
        row2.put("username", "李四");
        row2.put("password", 33);
        row2.put("nickname", 59.50);
        row2.put("email", false);


        ArrayList<Map<String, Object>> rows = CollUtil.newArrayList(row1, row2);

        ExcelWriter writer= cn.hutool.poi.excel.ExcelUtil.getWriter(true);
        //自定义标题别名
        writer.addHeaderAlias("username","姓名");
        writer.addHeaderAlias("password","年龄");
        writer.addHeaderAlias("nickname","成绩");
        writer.addHeaderAlias("email","是否合格");

        //默认配置
        writer.write(rows,true);
        //设置content—type
        response.setContentType("application/vnd.openxmlformats-officedocument.spreadsheetml.sheet;charset:utf-8");

        //设置标题
//        String fileName= URLEncoder.encode("用户信息1111","UTF-8");
        String fileName="测试1";
        //Content-disposition是MIME协议的扩展，MIME协议指示MIME用户代理如何显示附加的文件。
        response.setHeader("Content-Disposition","attachment;filename="+fileName+".xlsx");
        ServletOutputStream outputStream= response.getOutputStream();

        //将Writer刷新到OutPut
        writer.flush(outputStream,true);
        outputStream.close();

    }

swagger导出样子