package com.linghu.listener; import com.alibaba.excel.context.AnalysisContext; import com.alibaba.excel.event.AnalysisEventListener; import com.linghu.model.excel.ExcelDataWithRow; import com.linghu.model.excel.PlatformExcel; import com.linghu.model.excel.UserExcel; import java.util.ArrayList; import java.util.List; // 自定义监听器 public class UserExcelListener extends AnalysisEventListener { private List> dataList = new ArrayList<>(); private int rowNumber = 0; // 行号计数器(从1开始) @Override public void invoke(UserExcel data, AnalysisContext context) { rowNumber++; // 跳过表头行(如果表头是第1行,这里从第2行开始计数) dataList.add(new ExcelDataWithRow<>(rowNumber, data)); } @Override public void doAfterAllAnalysed(AnalysisContext context) { } public List> getDataList() { return dataList; } }