导入依赖
<dependency>
<groupId>com.alibaba</groupId>
<artifactId>easyexcel</artifactId>
<version>2.2.6</version>
</dependency>
serviceImpl
public int excelDemo(MultipartFile file)throws IOexception{
if(file ==null)
{
return 0;
}
if(!file.getOriginalFilename().contains("xlsx")){//判断文件后缀名
return 0;
}
List<Entity> list=EasyExcel.read(file.getInputStream)
//excel标题对应实体类,实体类要用@ExcelProperty与标题一致
.head(Entity.class)
//设置sheet,默认读取页数,也可以是sheetName
.sheet(0)
//设置标题所在行数
.headRowNumber(1)
.doReadSync();
}
excel中数据去重
// 单属性去重
List<Entity> unique = list.stream().collect(Collectors.collectingAndThen(Collectors.toCollection(() -> new TreeSet<>(Comparator.comparing(Entity::getId))), ArrayList::new));
// 多属性去重
List<Entity> unique1 = list.stream().collect(Collectors.collectingAndThen(Collectors.toCollection(() -> new TreeSet<>(Comparator.comparing(Entity::getName).thenComparing(Entity::getStuNo))), ArrayList::new));