SpringBoot 整合EasyExcel 获取动态Excel列名

        <dependency>
            <groupId>com.alibaba</groupId>
            <artifactId>easyexcel</artifactId>
            <version>2.2.6</version>
        </dependency>
        <!--fastjson-->
        <dependency>
            <groupId>com.alibaba</groupId>
            <artifactId>fastjson</artifactId>
            <version>1.2.76</version>
        </dependency>

importcom.alibaba.excel.context.AnalysisContext;
importcom.alibaba.excel.event.AnalysisEventListener;
importcom.alibaba.fastjson.JSON;

import java.util.*;

/*** @Description：Excel监听器
 * @Author：chenyanbin
 * @Date：2021/4/28 下午3:36
 * @Versiion：1.0
 */

public class ExcelListener extends AnalysisEventListener<Map<Integer, String>>{
    //Excel数据
    private List<Map<Integer, Map<Integer, String>>>list;
    //Excel列名
    private Map<Integer, String> headTitleMap = new HashMap<>();

    publicExcelListener() {
        list = new ArrayList<>();
    }

    @Override
    public void invoke(Map<Integer, String>data, AnalysisContext context) {
        System.out.println("解析到一条数据：" +JSON.toJSONString(data));
        Map<Integer, Map<Integer, String>> map = new HashMap<>();
        map.put(context.readRowHolder().getRowIndex(), data);
        list.add(map);
    }

    @Override
    public voiddoAfterAllAnalysed(AnalysisContext context) {
        System.out.println("所有数据解析完成");
    }

    @Override
    public void invokeHeadMap(Map<Integer, String>headMap, AnalysisContext context) {
        headTitleMap =headMap;
    }

    public List<Map<Integer, Map<Integer, String>>>getList() {
        returnlist;
    }

    public void setList(List<Map<Integer, Map<Integer, String>>>list) {
        this.list =list;
    }

    public Map<Integer, String>getHeadTitleMap() {
        returnheadTitleMap;
    }

    public void setHeadTitleMap(Map<Integer, String>headTitleMap) {
        this.headTitleMap =headTitleMap;
    }
}

importcom.alibaba.excel.EasyExcel;
importcom.alibaba.fastjson.JSON;
importcom.ybchen.springbooteasyexcel.listener.ExcelListener;
importorg.springframework.web.bind.annotation.RequestMapping;
importorg.springframework.web.bind.annotation.RestController;
importorg.springframework.web.multipart.MultipartFile;

importjava.io.IOException;
importjava.util.ArrayList;
importjava.util.HashMap;
importjava.util.List;
importjava.util.Map;

/*** @Description：
 * @Author：chenyanbin
 * @Date：2021/4/28 下午3:36
 * @Versiion：1.0
 */@RestController
public classDemoController {
    /*** 导入
     *
     * @paramfile
     * @throwsIOException
     */@RequestMapping(value = "import")
    public List<Object> importStudentInfos(MultipartFile file) throwsIOException {
        ExcelListener studentListener = newExcelListener();
        EasyExcel.read(file.getInputStream(), studentListener).sheet().doRead();
        List<Map<Integer, Map<Integer, String>>> list =studentListener.getList();
        Map<Integer, String> headTitleMap =studentListener.getHeadTitleMap();
        List<Map<String, String>> mapList = new ArrayList<>();
        for (int i = 0; i < list.size(); i++) {
            Map<Integer, Map<Integer, String>> integerMapMap =list.get(i);
            integerMapMap.forEach((k, l) ->{
                Map<String, String> map = new HashMap<>();
                l.forEach((y, z) ->{
                    map.put(headTitleMap.get(y), z);
                });
                mapList.add(map);
            });
        }
        System.out.println(mapList);
        System.out.println("=============================");
        System.out.println(JSON.toJSONString(mapList));
        return null;
    }
}