package com.ruoyi.basic.excel;
|
|
import com.alibaba.excel.EasyExcel;
|
import com.ruoyi.basic.pojo.StructureItemParameter;
|
import com.ruoyi.basic.service.StandardTemplateService;
|
import com.ruoyi.basic.service.StructureItemParameterService;
|
import com.ruoyi.common.utils.StringUtils;
|
import com.ruoyi.system.service.ISysDictTypeService;
|
import org.springframework.web.multipart.MultipartFile;
|
|
import java.io.IOException;
|
|
public class ExcelMultiSheetImporter {
|
|
public static String importExcel(MultipartFile file, StructureItemParameterService service, StandardTemplateService standardTemplateService,
|
ISysDictTypeService dictTypeService) {
|
try {
|
// 读取所有Sheet（通过监听器处理每个Sheet）
|
EasyExcel.read(file.getInputStream())
|
.head(StructureItemParameter.class)
|
// 注册监听器（每个Sheet共用同一个监听器）
|
.registerReadListener(new MultiSheetImportListener(service, standardTemplateService, dictTypeService))
|
// 自动识别所有Sheet并遍历读取
|
.doReadAll();
|
return "导入成功";
|
} catch (IOException e) {
|
System.out.println(e.getMessage());
|
return "导入失败：" + StringUtils.substring(e.getMessage(), 0, 100);
|
}
|
}
|
}
|
