读取excel文件转换为java bean对象

1. 引入maven依赖

       <dependency>
               <groupId>com.alibaba</groupId>
               <artifactId>easyexcel</artifactId>
               <version>1.1.2-beta5</version>
        </dependency>
   

2. 编写对应的实体类

   import com.alibaba.excel.annotation.ExcelProperty;
   import com.alibaba.excel.metadata.BaseRowModel;
   import io.swagger.annotations.ApiModelProperty;
   import lombok.Data;
   @Data
   public class PersonExcelBo extends BaseRowModel {
   
       @ExcelProperty(index = 0)
       @ApiModelProperty("人物id")
       private String personId;
   
       @ExcelProperty(index = 1)
       @ApiModelProperty("人物名称")
       private String name;
   }
   

3. 读取excel文件并转换为javabean

   // sheetNo --> 读取哪一个 表单
   // headLineMun --> 从哪一行开始读取( 不包括定义的这一行，比如 headLineMun为2 ，那么取出来的数据是从 第三行的数据开始读取 )
   // clazz --> 将读取的数据，转化成对应的实体，需要 extends BaseRowModel
   FileInputStream inperson = new FileInputStream("E:\\persons.xlsx");
   Sheet sheetPerson = new Sheet(1, 1, PersonExcelBo.class);
   List<Object> personList = EasyExcelFactory.read(inperson, sheetPerson);
   for (Object obj : personList) {
       //强制转换
      PersonExcelBo personExcel = (PersonExcelBo) obj
   }