springboot集成

        <dependency>
            <groupId>cn.afterturn</groupId>
            <artifactId>easypoi-spring-boot-starter</artifactId>
            <version>4.4.0</version>
        </dependency>

导入对应实体类

public class DataImport {
    @Excel(name = "序号")
    private String sno;
    @Excel(name = "姓名")
    private String name;
//省略set get
}

 示例

@PostMapping("/importData")
    public void   importData(@RequestPart("file") MultipartFile file) throws Exception {

        InputStream inputStream = file.getInputStream();
        //导入参数配置
        ImportParams importParams=new ImportParams();
        //表格标题行数,默认0
        importParams.setTitleRows(2);
        //表头行数,默认1
        importParams.setHeadRows(1);
        //开始读取的sheet位置,默认为0
        importParams.setStartSheetIndex(1);
        List<DataImport> list = ExcelImportUtil.importExcel(inputStream, DataImport.class, importParams);



    }

excel 

 参考地址

EasyPoi教程_V1.0

1.1 介绍 - Powered by MinDoc