EasyExcel演示

大浪淘沙r

已于 2022-08-02 09:57:59 修改

阅读量271

点赞数

文章标签： java

于 2022-08-02 09:57:06 首次发布

本文链接：https://blog.csdn.net/weixin_45084769/article/details/126116120

版权

//实体类
@Getter
@Setter
@ToString
@Accessors
@ContentRowHeight(20)
@HeadRowHeight(50)
@ColumnWidth(25)
public class xxxVO implements Serializable {

    @ExcelProperty(value = "xxx名称")
    private String xxx;
...
}

//controller导出
@PostMapping("/billExport")
public void export(@RequestBody @Validated xxxDTO dto,
                   HttpServletResponse response)throws Exception{
    ResponseVO<List<xxxVO>> vo = consumer.export(dto);
    //设置导出为excel表
    response.setContentType("application/vnd.ms-excel");
    response.setCharacterEncoding("utf-8");
    // 防止中文乱码
    String fileName = URLEncoder.encode("账单信息", "UTF-8");
    response.setHeader("Content-disposition", "attachment;filename=" + fileName + ".xlsx");
    EasyExcel.write(response.getOutputStream(), xxxVO.class)
            .sheet("账单信息")
            .doWrite(vo.getData());
}