pom.xml
<dependency>
<groupId>com.alibaba</groupId>
<artifactId>easyexcel</artifactId>
<version>3.0.5</version>
</dependency>
3.0.5版本，不会因为poi的依赖报错java.lang.NoClassDefFoundError: org/apache/poi/poifs/filesystem/FileMagic
读取的xlsx样式
ExcelReadDemo类
import com.alibaba.excel.annotation.ExcelProperty;
import lombok.Data;
@Data //提供getset方法读取到list
public class ExcelReadDemo {
@ExcelProperty(value ="工号")
private Stringjob_number;
@ExcelProperty(value ="姓名")
private Stringjob_name;
@ExcelProperty(value ="总积分")
private Stringtotal_score;
@ExcelProperty(value ="健步积分")
private Stringstep_socre;
@ExcelProperty(value ="健身积分")
private Stringfit_socre;
@ExcelProperty(value ="阅读积分")
private Stringread_score;
@ExcelProperty(value ="志愿者积分")
private Stringvolunteer_score;
@ExcelProperty(value ="工间操积分")
private Stringwork_exercise_score;
}
读取代码>>>>>>
FileInputStream fileInputStream =null;
try {
//获取读取的文件
fileInputStream =new FileInputStream("C:\\Users\\1113\\Desktop\\查询信息表.xlsx");
}catch (FileNotFoundException e) {
throw new BusinessException(BusinessStatus.FAIL,"IO读取异常");
}
//读取
List list = EasyExcel.read(fileInputStream)
//设置读取的类
.head(ExcelReadDemo.class)
//默认读取第一个
.sheet()
//设置标题所在行
.headRowNumber(1)
//异步读取
.doReadSync();
