EasyExcel导入Excel

添加 Maven 依赖

        <!-- https://mvnrepository.com/artifact/com.alibaba/easyexcel -->
        <dependency>
            <groupId>com.alibaba</groupId>
            <artifactId>easyexcel</artifactId>
            <version>3.0.5</version>
        </dependency>

创建实体类

@Data
public class YourDataEntity {
    private String column1;
    private String column2;
}

编写监听器

package com.cbnb.listener;

import com.alibaba.excel.context.AnalysisContext;
import com.alibaba.excel.event.AnalysisEventListener;

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

/**
 * EasyExcel通用的监听器
 */
public class EasyExcelListener <T> extends AnalysisEventListener<T> {
    private final List<T> dataList = new ArrayList<>();

    @Override
    public void invoke(T data, AnalysisContext analysisContext) {
        dataList.add(data);
    }

    @Override
    public void doAfterAllAnalysed(AnalysisContext analysisContext) {
        // 所有数据读取完成后的处理
        // 这里可以进行一些后续操作，如入库等
    }

    public List<T> getDataList() {
        return dataList;
    }
}

导入数据

public void importExcel(MultipartFile file) {
        InputStream inputStream = file.getInputStream();
        EasyExcelListener<YourDataEntity> easyExcelListener = new EasyExcelListener<>();
        EasyExcel.read(inputStream, YourDataEntity.class, easyExcelListener).sheet().doReadSync();
        // 获取导入的数据列表
        List<YourDataEntity> dataList = easyExcelListener.getDataList();
        // 入库操作
}