Java实现EasyExcel导入

 依赖

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

 项目结构

 

 excel表头对应实体类

import com.alibaba.excel.annotation.ExcelProperty;
import io.swagger.annotations.ApiModel;
import io.swagger.annotations.ApiModelProperty;
import lombok.Data;

@ApiModel("销售人员上传VO")
@Data
public class SalesmanUploadVO {

    @ExcelProperty(value = "所属销售团队", index = 0)
    @ApiModelProperty("所属销售团队")
    private String team;

    @ApiModelProperty("所属销售团队编号")
    private String teamCode;

    @ExcelProperty(value = "销售角色", index = 1)
    @ApiModelProperty("销售角色")
    private String role;

    @ApiModelProperty("销售角色编号")
    private String roleCode;

    @ExcelProperty(value = "销售人员姓名", index = 2)
    @ApiModelProperty("销售人员姓名")
    private String name;

    @ExcelProperty(value = "销售人员手机号", index = 3)
    @ApiModelProperty("销售人员手机号")
    private String phone;

}

EasyExcel导入监听类，用于EasyExcel在读取数据时进行相关操作

import com.alibaba.excel.annotation.ExcelProperty;
import com.alibaba.excel.context.AnalysisContext;
import com.alibaba.excel.event.AnalysisEventListener;
import com.slt.exception.BusinessException;
import com.slt.model.salesman.vo.SalesmanUploadVO;
import lombok.extern.slf4j.Slf4j;
import org.apache.commons.lang3.StringUtils;

import java.lang.reflect.Field;
import java.util.ArrayList;
import java.util.List;
import java.util.Map;


/**
 * @Author: CQian
 * @Date: 2024/2/28 16:10
 */

@Slf4j
public class SalesmanListener extends AnalysisEventListener<SalesmanUploadVO> {

    List<SalesmanUploadVO> list =