使用EasyExcel进行导入导出

男娘i 2023-10-02 18:45 26阅读 0赞

## 1.导入依赖，注意不要导入其他关于excel的依赖，会冲突 ##

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

## 2. 编写实体类 ##

>     @Data
>     @ToString
>     @AllArgsConstructor
>     @NoArgsConstructor
>     @HeadRowHeight(value = 35) // 表头行高
>     @ContentRowHeight(value = 25) // 内容行高
>     @ColumnWidth(value = 20) // 列宽
>     public class StudentEntity implements java.io.Serializable {
>         /**
>          * 学生姓名
>          */
>         @ExcelProperty(value={"学生信息表","名字"}, index=0)
>         private String  name;
>         /**
>          * 学生性别
>          */
>         @ExcelProperty(value={"学生信息表","性别"}, index=1)
>         private int  sex;
>     
>         @ExcelProperty(value={"学生信息表","生日"}, index=2)
>         private Date birthday;
>     
>         @ExcelProperty(value={"学生信息表","进校日期"}, index=3)
>         private Date registrationDate;
>     }

## 3. 编写导出代码 ##

>     @Test
>     public void test5() {
>         ArrayList<StudentEntity> list = new ArrayList<>();
>         StudentEntity studentEntity = new StudentEntity();
>         studentEntity.setName("aaa");
>         studentEntity.setBirthday(new Date());
>         studentEntity.setSex(1);
>         studentEntity.setRegistrationDate(new Date());
>         list.add(studentEntity);
>         WriteCellStyle headWriteCellStyle = new WriteCellStyle();
>         //设置背景颜色
>         headWriteCellStyle.setFillForegroundColor(IndexedColors.WHITE.getIndex());
>         //设置头字体
>         WriteFont headWriteFont = new WriteFont();
>         headWriteFont.setFontHeightInPoints((short)13);
>         headWriteFont.setBold(true);
>         headWriteCellStyle.setWriteFont(headWriteFont);
>         //内容策略
>         WriteCellStyle contentWriteCellStyle = new WriteCellStyle();
>         //设置 水平居中
>         contentWriteCellStyle.setHorizontalAlignment(HorizontalAlignment.CENTER);
>         HorizontalCellStyleStrategy horizontalCellStyleStrategy =
>                 new HorizontalCellStyleStrategy(headWriteCellStyle, contentWriteCellStyle);
>         EasyExcel.write("学生信息表.xlsx", StudentEntity.class).registerWriteHandler(horizontalCellStyleStrategy).sheet().doWrite(list);
>     }

## 4.运行之后会在项目中生成 ##

![watermark_type_d3F5LXplbmhlaQ_shadow_50_text_Q1NETiBAd2FuZzIwMDEwMTA0_size_14_color_FFFFFF_t_70_g_se_x_16][]

## 5.打开可以看到生成的excel如下 ##

![watermark_type_d3F5LXplbmhlaQ_shadow_50_text_Q1NETiBAd2FuZzIwMDEwMTA0_size_18_color_FFFFFF_t_70_g_se_x_16][]

## 6.详情可见官网 ##

[EasyExcel · 语雀EasyExcel是一个基于Java的简单、省内存的读...![A_CUIoT4xopNYAAAAAAAAAAABkARQnAQ][]https://www.yuque.com/easyexcel/doc/easyexcel][EasyExcel _ _EasyExcel_Java_..._A_CUIoT4xopNYAAAAAAAAAAABkARQnAQ_https_www.yuque.com_easyexcel_doc_easyexcel]

或者其他博主详细解析

[框架篇-easyexcel使用 - 简书EasyExcel 1.简介 传统Excel操作或者解析都是利用Apach POI进行操作，但是使用过这个框架的人都知道，这个框架并不完美，有较多的缺陷： 使用步骤繁琐 动态...https://www.jianshu.com/p/d1d264c817ef][-easyexcel_ - _EasyExcel 1._ _Excel_Apach POI_ _ _...https_www.jianshu.com_p_d1d264c817ef]

[watermark_type_d3F5LXplbmhlaQ_shadow_50_text_Q1NETiBAd2FuZzIwMDEwMTA0_size_14_color_FFFFFF_t_70_g_se_x_16]: https://img-blog.csdnimg.cn/7a1c6396d864459fbae68e2f7edd7bb3.png?x-oss-process=image/watermark,type_d3F5LXplbmhlaQ,shadow_50,text_Q1NETiBAd2FuZzIwMDEwMTA0,size_14,color_FFFFFF,t_70,g_se,x_16
[watermark_type_d3F5LXplbmhlaQ_shadow_50_text_Q1NETiBAd2FuZzIwMDEwMTA0_size_18_color_FFFFFF_t_70_g_se_x_16]: https://img-blog.csdnimg.cn/796924bb20d94a149c99717416daa302.png?x-oss-process=image/watermark,type_d3F5LXplbmhlaQ,shadow_50,text_Q1NETiBAd2FuZzIwMDEwMTA0,size_18,color_FFFFFF,t_70,g_se,x_16
[A_CUIoT4xopNYAAAAAAAAAAABkARQnAQ]: https://gw.alipayobjects.com/mdn/prod_resou/afts/img/A*CUIoT4xopNYAAAAAAAAAAABkARQnAQ
[EasyExcel _ _EasyExcel_Java_..._A_CUIoT4xopNYAAAAAAAAAAABkARQnAQ_https_www.yuque.com_easyexcel_doc_easyexcel]: https://www.yuque.com/easyexcel/doc/easyexcel
[-easyexcel_ - _EasyExcel 1._ _Excel_Apach POI_ _ _...https_www.jianshu.com_p_d1d264c817ef]: https://www.jianshu.com/p/d1d264c817ef