?依賴配置 (Maven pom.xml)

<dependencies><!-- FastExcel 核心庫 --><dependency><groupId>cn.idev.excel</groupId><artifactId>fastexcel</artifactId><version>1.0.0</version></dependency><!-- Apache POI 依賴 --><dependency><groupId>org.apache.poi</groupId><artifactId>poi</artifactId><version>5.2.3</version></dependency><dependency><groupId>org.apache.poi</groupId><artifactId>poi-ooxml</artifactId><version>5.2.3</version></dependency>
</dependencies>

映射實體類SetMealDetailsVo

package com.fantaibao.module.vo.appDish;import cn.idev.excel.annotation.ExcelIgnoreUnannotated;
import cn.idev.excel.annotation.ExcelProperty;
import cn.idev.excel.annotation.write.style.ColumnWidth;
import cn.idev.excel.annotation.write.style.HeadFontStyle;
import cn.idev.excel.annotation.write.style.HeadStyle;
import cn.idev.excel.enums.BooleanEnum;
import cn.idev.excel.enums.poi.FillPatternTypeEnum;
import com.fantaibao.module.po.DishAppManagementOriginal;
import lombok.AllArgsConstructor;
import lombok.Builder;
import lombok.Data;
import lombok.NoArgsConstructor;import java.math.BigDecimal;
import java.util.Date;@Data
@Builder
@AllArgsConstructor
@NoArgsConstructor
@ExcelIgnoreUnannotated
@HeadStyle(fillPatternType = FillPatternTypeEnum.SOLID_FOREGROUND, fillForegroundColor = 22)
@HeadFontStyle(fontName = "Microsoft YaHei", fontHeightInPoints = 11, bold = BooleanEnum.TRUE)
public class SetMealDetailsVo {/*** 套餐ID*/@ColumnWidth(30)@ExcelProperty("套餐ID")private String code;/*** 標準套餐名稱*/@ColumnWidth(30)@ExcelProperty("標準套餐名稱")private String menuName;/*** 套餐定價*/private BigDecimal price;/*** 套餐定價*/@ColumnWidth(20)@ExcelProperty("套餐定價")private String priceStr;/*** 套餐毛利率(%)*/@ColumnWidth(20)@ExcelProperty("套餐毛利率(%)")private String grossMarginStr;/*** 毛利率(%)*/private BigDecimal grossMargin;/*** 明細菜編碼*/@ColumnWidth(30)@ExcelProperty("明細菜編碼")private String detailsCode;/*** 明細菜品名稱*/@ColumnWidth(30)@ExcelProperty("明細菜品名稱")private String detailsMenuName;/*** 明細菜單位*/@ColumnWidth(30)@ExcelProperty("明細菜品單位")private String detailsUnit;/*** 明細菜定價*/@ColumnWidth(20)@ExcelProperty("明細菜定價")private String detailsPriceStr;private BigDecimal detailsPrice;/*** 明細菜毛利率(%)*/@ColumnWidth(20)@ExcelProperty("明細菜毛利率(%)")private String detailsGrossMarginStr;/*** 明細菜毛利率(%)*/private BigDecimal detailsGrossMargin;/*** 明細菜分類*/@ColumnWidth(20)@ExcelProperty("明細菜分類")private String detailsClass;}

自定義監聽器CustomSheetListener（帶校驗表頭）

package com.fantaibao.listener;import cn.hutool.core.collection.CollUtil;
import cn.idev.excel.annotation.ExcelProperty;
import cn.idev.excel.context.AnalysisContext;
import cn.idev.excel.metadata.data.ReadCellData;
import cn.idev.excel.read.listener.ReadListener;
import cn.idev.excel.util.StringUtils;
import lombok.Getter;
import lombok.RequiredArgsConstructor;
import lombok.extern.slf4j.Slf4j;import java.lang.reflect.Field;
import java.util.Arrays;
import java.util.List;
import java.util.Map;@Slf4j
@Getter
@RequiredArgsConstructor
public class CustomSheetListener<T> implements ReadListener<T> {/*** 返回最終解析的數據*/private List<T> dataList;private List<String> fields;public CustomSheetListener(List<T> dataList, Class clazz) {this.dataList = dataList;this.fields = getFields(clazz);}/*** 根據class通過反射獲取字段上@ExcelProperty注解的值** @param clazz 類名* @return 注解的值*/private static List<String> getFields(Class clazz) {List<String> fields = CollUtil.newArrayList();//根據class通過反射獲取字段上@ExcelProperty注解的值Field[] declaredFields = clazz.getDeclaredFields();for (Field field : declaredFields) {ExcelProperty annotation = field.getAnnotation(ExcelProperty.class);if (annotation != null) {String[] value = annotation.value();// 添加到列表中fields.addAll(Arrays.asList(value));}}return fields;}@Overridepublic void invokeHead(Map<Integer, ReadCellData<?>> headMap, AnalysisContext context) {// 在這里檢查表頭是否正確for (Map.Entry<Integer, ReadCellData<?>> entry : headMap.entrySet()) {String headerValue = entry.getValue().getStringValue();// 根據你的需求檢查表頭值if (!isValidHeader(headerValue)) {throw new RuntimeException("模版錯誤，請重新上傳");}}//if(!fields.isEmpty() && context.readSheetHolder().getHeadRowNumber()-1 == context.readSheetHolder().getRowIndex()){throw new RuntimeException("模版錯誤，請重新上傳");}}@Overridepublic void invoke(T data, AnalysisContext context) {dataList.add(data);}@Overridepublic void doAfterAllAnalysed(AnalysisContext context) {log.info("excel解析完成,sheet名為：{}", context.readSheetHolder().getSheetName());}/**** @param header 表頭名稱* @return 是否存在 存在則移除掉*/private boolean isValidHeader(String header) {if (StringUtils.isBlank(header)) {return true;}if(this.fields.contains(header)){fields.removeIf(field->field.equals(header));return true;}return false;}
}

業務菜調用

//fileUrl是文件全路徑(我這里是騰訊云OSS文件路徑)
List<SetMealDetailsVo> setMealDetails = CollUtil.newArrayList();
try {EasyExcel.read(new URL(fileUrl).openStream(),SetMealDetailsVo.class,new CustomSheetListener(setMealDetails, SetMealDetailsVo.class)).sheet(0).doRead();
} catch (Exception e) {throw new RuntimeException("模版錯誤，請重新上傳");
}