使用EasyExcel完成数据导出

实体类

@Data
public class ExportUserScoreManage {
    @ExcelProperty(value = "用户编号",index = 10)
    private Integer userId;
    @ExcelProperty(value = "已用积分",index = 7)
    private String usedScore;
    @ExcelProperty(value = "可用积分",index = 8)
    private String availableScore;
    @ExcelProperty(value = "总积分",index = 6)
    private String totalScore;
    @ExcelProperty(value = "店铺名称",index = 1)
    private String shopName;
    @ExcelProperty(value = "门店编号",index = 0)
    private String shopId;
    @ExcelProperty(value = "营销大区",index = 2)
    private String shopRegion;
    @ExcelProperty(value = "所属省",index = 3)
    private String shopProvince;
    @ExcelProperty(value = "所属城市",index = 4)
    private String shopCity;
    @ExcelProperty(value = "电话号码",index = 5)
    private String phone;
    @ExcelProperty(value = "创建时间",index = 9)
    private Date createTime;

工具类

public class ExcelUtil {

    /**
     * 导出excel
     *
     * @param fileName excel文件名称
     * @param sheetName excel sheet名称
     * @param list 数据
     * @param clazz
     * @param response
     */
    public static void exportExcel(String fileName, String sheetName, List list, Class clazz, HttpServletResponse response){
        ServletOutputStream outputStream;
        try {
            response.setContentType("application/vnd.ms-excel");
            response.setCharacterEncoding("utf8");
            response.setHeader("Content-Disposition", "attachment; filename=" + fileName + ".xlsx");
            outputStream = response.getOutputStream();
            EasyExcel.write(outputStream)
                    .head(clazz)
                    .excelType(ExcelTypeEnum.XLSX)
                    .sheet(sheetName)
                    .doWrite(list);
            outputStream.flush();
        } catch (Exception e) {
            log.error("导出excel异常：{}",e.getMessage());
            e.printStackTrace();
        }
    }
}

调方法

ExcelUtil.exportExcel("用户积分","积分数据",exportLists,ExportUserScoreManage.class,response);