easyExcel导出表格_easyexcel导出字段为list-CSDN博客

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

本文介绍如何通过Java库EasyExcel实现Excel文件的导出功能。包括在项目中引入EasyExcel依赖、编写控制器方法处理导出请求、设置HTTP响应头以下载文件、定义实体类并使用注解来控制导出样式等内容。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

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;
}