easyExcel实现简单的excel导出/下载功能

蚂蚁雅嘿

已于 2023-08-01 14:23:55 修改

阅读量520

点赞数

文章标签： excel java easyExcel

于 2023-07-31 16:47:54 首次发布

本文链接：https://blog.csdn.net/weixin_41507324/article/details/132025627

版权

该文章展示了如何在Java中创建一个Excel实体类，并使用EasyExcel库来导出数据到Excel文件。定义了实体类的属性，如姓名、年龄和生日，并设置了相应的注解。测试代码演示了如何构建数据列表，设置内容样式，然后通过HttpServletResponse将数据写入到Excel文件并下载。

摘要由CSDN通过智能技术生成

1.定义实体类

@Data
public class ExcelEntity {

    @ExcelIgnore
    private Long id;

    //上传的话 可以不加这个注解@ExcelProperty, index从0开始
    @ExcelProperty(value = "姓名",index = 0)
    private String name;

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

    @ColumnWidth(20)
    @ExcelProperty(value = "生日",index = 2)
    private String birthday;

}

2.测试代码

/**
     * 下载/导出 excel
     * @param response
     * @throws IOException
     */
    @RequestMapping("/write")
    public void write(HttpServletResponse response) throws IOException {
        //这里模拟要导出的excel里的数据
        List<ExcelEntity>dataList = new ArrayList<>();
        ExcelEntity excelEntity1 = new ExcelEntity();
        excelEntity1.setAge(20);
        excelEntity1.setName("李明");
        excelEntity1.setBirthday("2021-01-18 13:45:00");
        ExcelEntity excelEntity2 = new ExcelEntity();
        excelEntity2.setName("王刚");
        excelEntity2.setAge(11);
        excelEntity2.setBirthday("2020-11-09 13:45:00");
        dataList.add(excelEntity1);
        dataList.add(excelEntity2);
        //文件名必须经过encode，否则名称不对
        String fileName = URLEncoder.encode("导出的excel.xlsx", "UTF-8");
        response.setContentType("application/vnd.ms-excel");
        response.setCharacterEncoding("utf-8");
        response.setHeader("content-disposition", "attachment;fileName="+fileName);
        //内容样式
        WriteCellStyle cellStyle = new WriteCellStyle();
        //居中
        cellStyle.setHorizontalAlignment(HorizontalAlignment.CENTER);

        //参数：表头样式对象，列样式对象
        HorizontalCellStyleStrategy horizontalCellStyleStrategy =
                new HorizontalCellStyleStrategy(null, cellStyle);


        //获取响应的输出流
        ServletOutputStream outputStream = null;
        try{
            outputStream = response.getOutputStream();
            EasyExcel.write(outputStream,ExcelEntity.class)
                    .registerWriteHandler(horizontalCellStyleStrategy)
                    .sheet("sheet1")
                    .doWrite(dataList);
        }catch (Exception e){
            e.printStackTrace();
        }finally {
            if (null != outputStream){
                outputStream.flush();
                outputStream.close();
            }
        }
    }