EasyExcel: 入门案例

            com.alibaba
            easyexcel
            3.1.0
        

        
            org.projectlombok
            lombok
            1.18.24
        

import com.alibaba.excel.annotation.ExcelProperty;
import lombok.Data;

import java.util.Date;

@Data
public class SimpleData {

    @ExcelProperty("姓名")
    private String name;

    @ExcelProperty("日期")
    private Date date;

    @ExcelProperty("数字")
    private Double num;
}

import com.alibaba.excel.context.AnalysisContext;
import com.alibaba.excel.event.AnalysisEventListener;
import com.alibaba.excel.read.listener.ReadListener;
import com.itheima.model.SimpleData;

import java.util.ArrayList;
import java.util.List;


public class SimpledataListener  extends AnalysisEventListener {


    private List list = new ArrayList<>();

    
    @Override
    public void invoke(SimpleData simpleData, AnalysisContext analysisContext) {
        if(list.size()>=10){
            System.out.println("集合内容："+ list);
            list.clear();
        }

        list.add(simpleData);
    }

    
    @Override
    public void doAfterAllAnalysed(AnalysisContext analysisContext) {
        System.out.println("最后剩余数据："+ list);
    }
}

import com.alibaba.excel.EasyExcel;
import com.itheima.listener.SimpledataListener;
import com.itheima.model.SimpleData;

import java.io.File;

public class AppMain {

    public static void main(String[] args) {
        String fileName = "G:\173project\easyExcel_demo\src\main\resources\simpleData.xlsx";
        // 这里默认读取第一个sheet
        EasyExcel.read(fileName, SimpleData.class, new SimpledataListener()).sheet().doRead();
    }
}