easyExcel导出表格

最新推荐文章于 2024-06-03 15:08:51 发布

weixin_47467938

最新推荐文章于 2024-06-03 15:08:51 发布

阅读量264

点赞数

文章标签： java 开发语言

本文链接：https://blog.csdn.net/weixin_47467938/article/details/128325311

版权

1.pom文件加入jar包

		<dependency>
            <groupId>com.alibaba</groupId>
            <artifactId>easyexcel</artifactId>
            <version>3.1.1</version>
        </dependency>

2.代码案例

@RequestMapping("/download")
    public static ResponseEntity<Void> download(HttpServletResponse response) throws IOException {
        ResponseEntity<Void> responseEntity = new ResponseEntity<>();
        // 这里的 ContentType 要和前端请求携带的 ContentType 相对应
        response.setContentType("application/vnd.ms-excel");
        response.setCharacterEncoding("utf-8");
        // 这里URLEncoder.encode可以防止中文乱码 当然和easyexcel没有关系   1360
        String fileName = URLEncoder.encode("过人数据", "UTF-8");
        // 可更换为对应业务从数据库中查询获取list
        List<EasyExcelTestVO> easyExcelTestVOList = new ArrayList<>();
        EasyExcelTestVO easyExcelTestVO = new EasyExcelTestVO();
        easyExcelTestVO.setName("孙悟空").setAge(800).setMobile("15688888888");
        easyExcelTestVO.setImg(new URL("http://10.0.6.26/data/phonecall/result_img/2022-09-08/00007.jpg"));
        easyExcelTestVOList.add(easyExcelTestVO);//
        response.setHeader("Content-disposition", "attachment;filename=" + fileName + ".xlsx");
        // DownloadData 是实体类，sheet 里面是 sheet 名称，doWrite 里面放要写入的数据，类型为 List<DownloadData>
        EasyExcel.write(response.getOutputStream(), EasyExcelTestVO.class).autoCloseStream(Boolean.FALSE).sheet("测试数据").doWrite(easyExcelTestVOList);
        return responseEntity;
    }

3.实体类

@Data
@ToString
@Builder
@ApiModel(description = "审核列表导出")
@AllArgsConstructor
@NoArgsConstructor
@Accessors(chain = true)
@ColumnWidth(30)
@ContentRowHeight(50)
@Excel(value = "资源上报")
@ContentFontStyle(fontHeightInPoints = 13)
@ContentStyle(horizontalAlignment = HorizontalAlignmentEnum.CENTER, verticalAlignment = VerticalAlignmentEnum.CENTER, wrapped = BooleanEnum.TRUE)
public class EasyExcelTestVO {
    @ExcelProperty(value = "姓名", index = 4)
    @ApiModelProperty(value = "姓名")
    private String name;

    @ExcelProperty(value = "年龄", index = 3)
    @ApiModelProperty(value = "年龄")
    private Integer age;

    @ExcelProperty(value = "手机号", index = 2)
    @ApiModelProperty(value = "手机号")
    private String mobile;

    @ExcelProperty(value = "图片", index = 1)
    @ApiModelProperty(value = "图片")
    private URL img;
}