本文共 2450 字,大约阅读时间需要 8 分钟。
com.alibaba easyexcel 2.1.6
@Overridepublic 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();}
package tech.niua.admin.utils;import com.alibaba.excel.context.AnalysisContext;import com.alibaba.excel.event.AnalysisEventListener;import com.alibaba.fastjson.JSON;import lombok.extern.slf4j.Slf4j;import org.mybatis.logging.LoggerFactory;import org.springframework.beans.factory.annotation.Autowired;import org.springframework.stereotype.Component;import tech.niua.admin.domain.FormTemplate;import tech.niua.admin.domain.SignupUserinfo;import tech.niua.admin.service.IFormTemplateService;import tech.niua.admin.service.ISignupUserinfoService;import javax.annotation.PostConstruct;import java.util.ArrayList;import java.util.List;import java.util.Map;@Slf4jpublic class NoModleDataListener extends AnalysisEventListener
转载地址:http://yjyki.baihongyu.com/