SpringBoot使用easypoi导入Excel

废话不多说直接上代码
pom文件

 <dependency>
            <groupId>cn.afterturn</groupId>
            <artifactId>easypoi-base</artifactId>
            <version>3.0.3</version>
        </dependency>
        <dependency>
            <groupId>cn.afterturn</groupId>
            <artifactId>easypoi-web</artifactId>
            <version>3.0.3</version>
        </dependency>
        <dependency>
            <groupId>cn.afterturn</groupId>
            <artifactId>easypoi-annotation</artifactId>
            <version>3.0.3</version>
        </dependency>

js代码
这里使用的layui的上传组件，且不限于layui

layui.use('upload', function () {
    var upload = layui.upload;
    //执行实例
    var uploadInst = upload.render({
        elem: '#file', //绑定元素
        url: 'url', //上传接口
        size: 51200,
        accept: 'file',
        done: function (r) {
            layer.msg(r.msg);
            console.log(r)
            reLoad();
        },
        error: function (r) {
            layer.msg(r.msg);
        }
    });
});

controller控制层代码

@ResponseBody
	@PostMapping("/importExcel")
	public void importExcel(@RequestParam("file") MultipartFile file ) {
		ImportParams importParams = new ImportParams();
		importParams.setHeadRows(1);
		importParams.setTitleRows(1);
		importParams.setNeedVerfiy(true);
		try {
			ExcelImportResult<DomeDO> result = ExcelImportUtil.importExcelMore(file.getInputStream(), DomeDO.class, importParams);
			List<DomeDO> successList = result.getList();
			for (DomeDO domeDo: successList) {
				System.out.println(domeDo);
			}
		} catch (Exception e) {
			e.printStackTrace();
		}
	}