使用反射封裝，實現統一讀取

import cn.afterturn.easypoi.excel.annotation.Excel;
import cn.afterturn.easypoi.excel.annotation.ExcelTarget;
import cn.hutool.core.annotation.AnnotationUtil;
import cn.hutool.core.io.IoUtil;
import cn.hutool.core.util.ReflectUtil;
import cn.hutool.core.util.StrUtil;
import cn.hutool.poi.excel.ExcelReader;
import cn.hutool.poi.excel.ExcelUtil;import java.io.ByteArrayInputStream;
import java.io.ByteArrayOutputStream;
import java.io.InputStream;
import java.lang.reflect.Field;
import java.util.*;
import java.util.stream.Collectors;/*** 【工具類】Excel 多 Sheet 導入工具類** @author jason*/
public class ExcelSheetUtil {/*** 獲取 Sheet 名字*/public static <T> String getSheetName(Class<T> clazz) {return AnnotationUtil.getAnnotationValue(clazz, ExcelTarget.class, "value");}/*** 讀取多個sheet** @param inputStream* @param classList* @return*/public static Map<String, List<?>> readExcelList(InputStream inputStream, List<Class<?>> classList) {Map<String, List<?>> sheetMap = new HashMap<>();// 解決 InputStream 流只能讀一次的問題，復制一個 ByteArrayOutputStreamByteArrayOutputStream cacheInputStream = new ByteArrayOutputStream();IoUtil.write(cacheInputStream, true, IoUtil.readBytes(inputStream));classList.forEach(tClass -> {String sheetName = AnnotationUtil.getAnnotationValue(tClass, ExcelTarget.class, "value");InputStream inputStreamSingleton = new ByteArrayInputStream(cacheInputStream.toByteArray());List<?> excelData3List = readExcelList(sheetName, inputStreamSingleton, tClass);sheetMap.put(sheetName, excelData3List);});return sheetMap;}/*** 讀取單個sheet** @param sheetName* @param inputStream* @param clazz* @param <T>* @return*/public static <T> List<T> readExcelList(String sheetName, InputStream inputStream, Class<T> clazz) {ExcelReader excelReader = ExcelUtil.getReader(inputStream, sheetName);List<Map<String, Object>> mapList = excelReader.read(0, 0, Integer.MAX_VALUE);excelReader.close();return Optional.ofNullable(mapList).orElse(new ArrayList<>()).stream().map(itemMap -> {T excelData = ReflectUtil.newInstance(clazz);Field[] fields = ReflectUtil.getFields(clazz);for (Field field : fields) {String key = AnnotationUtil.getAnnotationValue(field, Excel.class, "name");String value = StrUtil.toStringOrNull(itemMap.get(key));ReflectUtil.setFieldValue(excelData, field, value);}return excelData;}).collect(Collectors.toList());}}

使用

import cn.hutool.core.collection.CollectionUtil;
import cn.hutool.core.io.FileUtil;
import com.excel.tool.putuo.excel.ExcelData0;
import com.excel.tool.putuo.excel.ExcelData1;
import com.excel.tool.putuo.excel.ExcelData2;
import com.excel.tool.putuo.excel.ExcelData3;
import com.excel.tool.putuo.util.ExcelSheetUtil;
import lombok.SneakyThrows;import java.io.File;
import java.io.InputStream;
import java.util.List;
import java.util.Map;public class TestMain {public static void main(String[] args) {File xlsx = FileUtil.file("數據11.21.xlsx");TestMain.startExcel(FileUtil.getInputStream(xlsx));}@SneakyThrowspublic static <T> void startExcel(InputStream inputStream) {List<Class<?>> classList = CollectionUtil.newArrayList(ExcelData0.class,ExcelData1.class,ExcelData2.class,ExcelData3.class);Map<String, List<?>> sheetMap = ExcelSheetUtil.readExcelList(inputStream, classList);List<ExcelData0> excelData0List = (List<ExcelData0>) sheetMap.get(ExcelSheetUtil.getSheetName(ExcelData0.class));List<ExcelData1> excelData1List = (List<ExcelData1>) sheetMap.get(ExcelSheetUtil.getSheetName(ExcelData1.class));List<ExcelData2> excelData2List = (List<ExcelData2>) sheetMap.get(ExcelSheetUtil.getSheetName(ExcelData2.class));List<ExcelData3> excelData3List = (List<ExcelData3>) sheetMap.get(ExcelSheetUtil.getSheetName(ExcelData3.class));System.out.println();}}

實體定義

import cn.afterturn.easypoi.excel.annotation.Excel;
import cn.afterturn.easypoi.excel.annotation.ExcelTarget;
import lombok.Data;
import lombok.experimental.Accessors;@Data
@Accessors(chain = true)
@ExcelTarget(value = "整表")
public class ExcelData0 {@Excel(name = "序號")private String num;@Excel(name = "來源")private String mediaType;@Excel(name = "發布時間")private String publishTime;@Excel(name = "作者")private String author;@Excel(name = "標題")private String title;@Excel(name = "摘要")private String digest;@Excel(name = "原文鏈接")private String link;}