spring动态导入无模板excel

spring动态导入无模板excel

导入maven依赖

<dependency>
   <groupId>com.alibaba</groupId>
   <artifactId>easyexcel</artifactId>
   <version>2.1.6</version>
</dependency>

实现层代码

@Override
public void importExcelUserInfo(MultipartFile file, Long signupId) throws Exception {
    this.signupId=signupId;
    File tofile = multipartFileToFile(file);
    NoModleDataListener noModleDataListener = new NoModleDataListener();
    //这里因为出现过地址指向错误，看自己具体需求是否需要
    noModleDataListener.setSignupUserinfoService(signupUserinfoService);
    //这里调用的是EasyExcel自带的方法不需要自己写
    EasyExcel.read(tofile,noModleDataListener).sheet().doRead();
}

excel数据表格解析

package tech.niua.admin.utils;

import com.alibaba.excel.context.AnalysisContext;
import com.alibaba.excel.event.Analysis