EasyExcel导出xlsx-工具类

public class EasyUtil {

    public ResponseResult putExcel(HttpServletResponse response, Collection<?> data,
                                    Class head, String sheetName) throws IOException {

        //设置表名
        String fileName = new String((new SimpleDateFormat("yyyy-MM-dd").format(new Date())).getBytes(), "UTF-8");
        //设置字符编码
        response.setCharacterEncoding("utf-8");
        //设置内容类型
        response.setContentType("application/json;charset=utf-8");
        //设置标题
        response.setHeader("Content-Disposition", "attachment;filename=" + URLEncoder.encode(fileName + ".xlsx", "utf-8"));
        //核心代码
        EasyExcel.write(response.getOutputStream(),head).sheet(sheetName).doWrite(data);
        return ResponseResult.okResult(HttpCodeEnum.SUCCESS);
    }

}

impl

 

    @Override
    public ResponseResult download(HttpServletResponse response, List<Integer> id) {
        List<Demo> feedbacks = listByIds(id);
        EasyUtil easyUtil = new EasyUtil();
        String string = "测试一下";
        try {
            easyUtil.putExcel(response, feedbacks, Feedback.class, string);
        } catch (IOException e) {
            throw new RuntimeException(e);
        }
        return ResponseResult.okResult(HttpCodeEnum.SUCCESS);
    }