Easyexcel 快速入门到使用

话密不是我的性格  今天分享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 

下期更精彩