话密不是我的性格 今天分享Easyexcel 读
导入依赖
<dependency>
<groupId>com.alibaba</groupId>
<artifactId>easyexcel</artifactId>
<version>3.1.1</version>
</dependency>
创建监听器交给Spring管理
@Component
public class NoModelDataListener extends AnalysisEventListener<GuangdongPoJo> {
@Autowired
private GuangdongPoJoMapper guangdongPoJoMapper;
@Override
public void invoke(GuangdongPoJo guangdongPoJo, AnalysisContext analysisContext) {
com.zy.cn.user.entity.GuangdongPoJo guangdongPoJo1 = new com.zy.cn.user.entity.GuangdongPoJo();
BeanUtils.copyProperties(guangdongPoJo, guangdongPoJo1);
guangdongPoJoMapper.insert(guangdongPoJo1);
}
@Override
public void doAfterAllAnalysed(AnalysisContext analysisContext) {
}
}
@PostMapping("/importData")
public Result importData(MultipartFile file){
guangdongpojOervice.importDictData(file);
return Result.ok();
}
void importDictData(MultipartFile file);
@Override
public void importDictData(MultipartFile file) {
try {
EasyExcel.read(file.getInputStream(),com.zy.cn.common.GuangdongPoJo.class,noModelDataListener).excelType(ExcelTypeEnum.CSV).sheet().doRead();
} catch (IOException e) {
throw new RuntimeException(e);
}
}
@ExcelProperty(value = "名称", index = 0)
private String name;
@ExcelProperty(value = "地址", index = 1)
private String address;
@ExcelProperty(value = "城市", index = 2)
private String city;
@ExcelProperty(value = "区域", index = 3)
private String region;
@ExcelProperty(value = "经度", index = 4)
private String longitude;
@ExcelProperty(value = "纬度", index = 5)
private String latitude;
@ExcelProperty(value = "UID", index = 6)
private String uid;
想要写入数据库的字段 必须上满加上 ExcelProperty
下期更精彩