EasyExcel简单的使用（课程目录项目文件上传）和实践

1. 课程目录需求

2.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;

/**
 * @author 桐叔
 * @email liangtong@itcast.cn
 */
@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;

/**
 * @author 桐叔
 * @email liangtong@itcast.cn
 */
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 = "G:/czxy_2019_java34/xls/student_demo.xls";
        // 进行写操作，确定表头，表名，内容
        EasyExcel.write(file,Student.class).sheet("Java34")