EasyExcel入门与读写操作练习

EasyExcel入门

2.1 导入坐标

    <dependencies>
        <!-- easy excel 依赖-->
        <dependency>
            <groupId>com.alibaba</groupId>
            <artifactId>easyexcel</artifactId>
            <version>2.2.6</version>
        </dependency>
        <!--lombok , @Data 等-->
        <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() {
        // 确定文件位置 ： 路径名\zx-test-parent\zx-test-excel\target\classes\student_demo.xls
        String file = getPath() + "student_demo.xls";
        // 读取excel文件
        EasyExcel.read(file,Student.class, new StudentListener()).sheet("xxx").doRead();

    }
}