阿里easyexcel读取excel文件

maven依赖，内部依赖poi，注意处理冲突
<!-- alibaba/easyexcel -->
<dependency>
   <groupId>com.alibaba</groupId>
   <artifactId>easyexcel</artifactId>
   <version>2.0.5</version>
</dependency>

1.定义解析excel类

@Data
public class ExcelModel {
    //根据列角标匹配excel
    @ExcelProperty(index = 0)
    private Integer warehouseId;
    
    //根据列名匹配excel
    @ExcelProperty(value = "姓名")
    private Integer subject;

    @ExcelProperty(index = 3)
    private Integer productType;

    @ExcelProperty(index = 4)
    private Integer hqydWid;

    @ExcelProperty(index = 8)
    private Integer ydtWid;

    @ExcelProperty(index = 10)
    private Integer isTrade;

    @ExcelProperty(index = 11)
    private Integer tradeHqydWid;

    @ExcelProperty(index = 13)
    private Integer tradeYdtWid;
}