加入依赖
<dependency>
<groupId>com.alibaba</groupId>
<artifactId>easyexcel</artifactId>
<version>2.1.7</version>
</dependency>
实体 接收参数加入注解 @ExcelProperty("起始时间")
@ApiOperation(value = "通过本地文件导入车辆数据")
@PostMapping(value = "/importDataExcel")
public Result importDataExcel(@RequestPart("file") MultipartFile file) {
List<ApproveExcel> memberList = null;
try {
memberList = EasyExcel.read(file.getInputStream()).head(ApproveExcel.class).sheet().doReadSync();
if (memberList == null) {
return Result.err("文档暂无数据", ApproveExcel.class);
}
approveService.importDataExcel(memberList);
return Result.ok(true);
} catch (IOException e) {
e.printStackTrace();
}
return Result.ok(false);
}
转map
Map<String, Integer> maps1 = collect1.stream().collect(Collectors.toMap(Dept::getUnitName, Dept::getId));
分割字符串成数组
Arrays.asList(approveExcelW.getParking().split(","));
excel导入
最新推荐文章于 2024-07-05 08:59:17 发布