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<UserExcel> {
|
private List<ExcelDataWithRow<UserExcel>> 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<ExcelDataWithRow<UserExcel>> getDataList() {
|
return dataList;
|
}
|
|
}
|
