java集成easyApi实现excel数据导入

pom.xml

       
            com.alibaba
            easyexcel
            2.1.4
        

controller方法：

public JSonObject readExcelCenter(MultipartFile file) throws Exception {
        JSonObject jsonObject = new JSonObject();
        int success = 0;
        int error = 0;
        List list = ExcelUtil.readDCenterDemandEntityExcel(file);
        for(DCenterDemandEntity dCenterDemandEntity : list){
           boolean bool = dCenterDemandService.saveimport(dCenterDemandEntity);
           if(bool){
               success += 1;
           }else{
               error += 1;
           }
        }
        jsonObject.put("successNum",success);
        jsonObject.put("error",error);
        jsonObject.put("success",true);
        return jsonObject;
    }

实体：

import com.alibaba.excel.annotation.ExcelProperty;
import com.alibaba.excel.metadata.baseRowModel;
import com.fasterxml.jackson.annotation.JsonFormat;
import io.swagger.annotations.ApiModelProperty;
import lombok.Data;
import lombok.ToString;

import java.io.Serializable;
import java.util.Date;


@Data
@ToString
public class DCenterDemandEntity extends baseRowModel implements Serializable {

    private static final long serialVersionUID = 1L;


    
    @ExcelProperty(index = 0)
    @ApiModelProperty(value = "城市")
    private String cityName;

    
    @ExcelProperty(index = 1)
    @ApiModelProperty(value = "需求")
    private String content;

    
    @ExcelProperty(index = 2)
    private String field;
}

ExcelUtil工具类：

package com.pro.main.utils;

import com.alibaba.excel.ExcelReader;
import com.alibaba.excel.metadata.baseRowModel;
import com.alibaba.excel.metadata.Sheet;
import com.pro.main.fill.entity.DCenterDemand;
import com.pro.main.fill.entity.excelEntity.DCenterDemandEntity;
import com.pro.main.fill.entity.excelEntity.DProjectDemandEntity;
import com.pro.main.fill.entity.excelEntity.DProjectGroundEntity;
import org.apache.commons.lang3.StringUtils;
import org.springframework.web.multipart.MultipartFile;

import java.io.BufferedInputStream;
import java.io.File;
import java.io.FileInputStream;
import java.io.InputStream;
import java.util.List;


public class ExcelUtil {
    
    private ExcelUtil() {
    }

    private static List readExcel(String path, Class clazz) throws Exception {
        if (StringUtils.isNotEmpty(path)) {
            File file = new File(path);
            if (!file.exists()) {
                throw new Exception("文件不存在 !");
            }
            InputStream inputStream = new FileInputStream(file);
            BufferedInputStream bis = new BufferedInputStream(inputStream);
            return readExcel(bis, clazz);
        }
        return null;
    }

    private static List readExcel(File file, Class clazz) throws Exception {
        if (file != null && file.exists()) {
            InputStream inputStream = new FileInputStream(file);
            BufferedInputStream bis = new BufferedInputStream(inputStream);
            return readExcel(bis, clazz);
        }
        return null;
    }

    private static List readExcel(InputStream inputStream, Class clazz) throws Exception {
        return readExcel(inputStream, null, clazz);
    }

    private static List readExcel(MultipartFile excelFile, Class clazz) throws Exception {
        if (excelFile != null) {
            return readExcel(excelFile.getInputStream(), null, clazz);
        }
        return null;
    }

    public static List readExcel(InputStream inputStream, Object customContent, Class clazz) throws Exception {
        ExcelListener excelListener = new ExcelListener();
        ExcelReader excelReader;
        if (inputStream instanceof BufferedInputStream) {
            excelReader = new ExcelReader(inputStream, customContent, excelListener);
        } else {
            excelReader = new ExcelReader(new BufferedInputStream(inputStream), customContent, excelListener);
        }
        excelReader.read(new Sheet(1, 1, clazz));
        return excelListener.getDataList();
    }


    public static List readDCenterDemandEntityExcel(MultipartFile file) throws Exception{
        List list = readExcel(file,DCenterDemandEntity.class);
        return BeanCopy.convert(list, DCenterDemandEntity.class) ;
    }
    public static List readDProjectDemandEntityExcel(MultipartFile file) throws Exception{
        List list = readExcel(file,DProjectDemandEntity.class);
        return BeanCopy.convert(list, DProjectDemandEntity.class) ;
    }
    public static List readDProjectGroundEntityExcel(MultipartFile file) throws Exception{
        List list = readExcel(file,DProjectGroundEntity.class);
        return BeanCopy.convert(list, DProjectGroundEntity.class) ;
    }
}

ExcelListener:

package com.pro.main.utils;

import com.alibaba.excel.annotation.ExcelProperty;
import com.alibaba.excel.context.AnalysisContext;
import com.alibaba.excel.event.AnalysisEventListener;

import java.lang.reflect.Field;
import java.util.ArrayList;
import java.util.List;

public class ExcelListener extends AnalysisEventListener {

    private List