EasyExcel入门
2.1 导入坐标
<dependencies>
<dependency>
<groupId>com.alibaba</groupId>
<artifactId>easyexcel</artifactId>
<version>2.2.6</version>
</dependency>
<dependency>
<groupId>org.projectlombok</groupId>
<artifactId>lombok</artifactId>
</dependency>
<dependency>
<groupId>org.springframework.boot</groupId>
<artifactId>spring-boot-starter-test</artifactId>
</dependency>
</dependencies>
2.2 封装类
package com.czxy.test.excel;
import com.alibaba.excel.annotation.ExcelProperty;
import lombok.Data;
@Data
public class Student {
@ExcelProperty("编号")
private String id;
@ExcelProperty("姓名")
private String name;
@ExcelProperty("年龄")
private Integer age;
@ExcelProperty("电话")
private String telephone;
@ExcelProperty("邮箱")
private String email;
@ExcelProperty("生日")
private String birthday;
}
2.3 写操作
package com.czxy.test.excel;
import com.alibaba.excel.EasyExcel;
import org.junit.Test;
import java.util.ArrayList;
import java.util.List;
public class TestExcelWrite {
private List<Student> getData() {
List<Student> list = new ArrayList<>();
for(int i = 0 ; i < 20 ; i ++) {
Student student = new Student();
student.setId( i + "");
student.setName("jack" + i);
student.setAge(i);
student.setTelephone("13699" + i);
student.setEmail("jack" + i + "@czxy.com") ;
student.setBirthday("2021-12-21");
list.add(student);
}
return list;
}
@Test
public void write() {
String file = "路径名/xls/student_demo.xls";
EasyExcel.write(file,Student.class).sheet("xxx").doWrite(getData());
}
}
2.4 读操作
监听器
package com.czxy.test.excel;
import com.alibaba.excel.context.AnalysisContext;
import com.alibaba.excel.event.AnalysisEventListener;
public class StudentListener extends AnalysisEventListener<Student> {
@Override
public void invoke(Student student, AnalysisContext analysisContext) {
System.out.println(student);
}
@Override
public void doAfterAllAnalysed(AnalysisContext analysisContext) {
System.out.println("解析完成");
}
}
读
package com.czxy.test.excel;
import com.alibaba.excel.EasyExcel;
import org.junit.Test;
public class TestExcelRead {
private String getPath() {
return TestExcelRead.class.getResource("/").getPath();
}
@Test
public void testRead() {
String file = getPath() + "student_demo.xls";
EasyExcel.read(file,Student.class, new StudentListener()).sheet("xxx").doRead();
}
}