Hutool工具包导入excel文件数据到数据库

一：导入依赖：

<dependency>
    <groupId>cn.hutool</groupId>
    <artifactId>hutool-all</artifactId>
    <version>${hutool.version}</version>
</dependency>
<dependency>
    <groupId>org.apache.poi</groupId>
    <artifactId>poi-ooxml</artifactId>
    <version>${poi.version}</version>
</dependency>
<dependency>
    <groupId>org.apache.poi</groupId>
    <artifactId>poi</artifactId>
    <version>${poi.version}</version>
</dependency>
<dependency>
    <groupId>org.apache.poi</groupId>
    <artifactId>poi-ooxml-schemas</artifactId>
    <version>${poi.version}</version>
</dependency>

二，编写代码（事例）

 public  HttpResult importFile(@RequestParam("multipartFile") MultipartFile multipartFile) throws IOException {
        ExcelReader reader = ExcelUtil.getReader(multipartFile.getInputStream());
        //添加excel和映射对象的关系
        reader.addHeaderAlias("料号","partNum");
        reader.addHeaderAlias("备件料号名称","partSpareName");
        reader.addHeaderAlias("备件规格","partNorms");
        reader.addHeaderAlias("安全库存","safetyStock");
        reader.addHeaderAlias("入库数量","warehousingNum");
        reader.addHeaderAlias("适用设备","fitEqp");
        reader.addHeaderAlias("库位","location");
        List<SparePart> eqpInfos = reader.readAll(SparePart.class);
        eqpInfos.stream().map(a->{
            a.setCompanyId(Convert.toLong(systemFeignService.getCompanyIdFeign(RequestContext.getInstance().getCompanyName()).getData()));
            return  a;
        }).forEach(a->{
            SparePart one = sparePartService.getOne(new LambdaQueryWrapper<SparePart>().eq(SparePart::getPartNum, a.getPartNum()));
            if (null==one){
                SparePart sparePart=new SparePart();
                BeanUtils.copyProperties(a,sparePart);
                boolean save = sparePartService.save(sparePart);
            }else {
                one.setWarehousingNum(one.getWarehousingNum()+ a.getWarehousingNum());
                boolean save = sparePartService.updateById(one);
            }
        });
        return HttpResult.ok();
    }