spring boot 读取excel转换为List或者map

1、引入依赖

<dependency>
            <groupId>com.alibaba</groupId>
            <artifactId>easyexcel</artifactId>
            <version>2.2.10</version>
        </dependency>

2、在utils定义工具函数

package com.example.springboottest.utils;

import org.apache.poi.hssf.usermodel.HSSFWorkbook;
import org.apache.poi.ss.usermodel.Workbook;
import org.apache.poi.xssf.usermodel.XSSFWorkbook;
import org.springframework.web.multipart.MultipartFile;

import java.io.IOException;
import java.io.InputStream;

public class ImportExcelFile {

    //获取WorkBook对象
    public static Workbook getExcelWorkBook(MultipartFile multipartFile) throws IOException {
        InputStream inputStream=multipartFile.getInputStream();
        String originalFileName=multipartFile.getOriginalFilename();
        String fileType=originalFileName.substring(originalFileName.lastIndexOf(".")+1);
        if (fileType.equalsIgnoreCase("xls")) {
            //xls格式
            return new HSSFWorkbook(inputStream);
        } else {
            //xlsx格式
            return new XSSFWorkbook(inputStream);
        }
    }
}

3、控制器或service如下代码

public Map<String,String> ImportExcelList(MultipartFile multipartFile) throws IOException {
        //行List,也是最终要返回的List
        List<List<String>> rowList=new ArrayList<>();
        Map<String,String> result=new HashMap<String,String>();
        Workbook workbook= ImportExcelFile.getExcelWorkBook(multipartFile);
        Sheet sheet = workbook.getSheetAt(1);
        if (sheet == null) {
            throw new IOException("创建Sheet失败！");
        }
        //开始遍历行
        for (int i=sheet.getFirstRowNum();i<= sheet.getLastRowNum();i++){
            Row row = sheet.getRow(i);
            //列List
            List<String> cellList=new ArrayList<>();
            //转换为List数组
            for (int cellNum=0;cellNum< row.getLastCellNum();cellNum++){
                cellList.add(String.valueOf(row.getCell(cellNum)));
            }
            rowList.add(cellList);
        }
        workbook.close();
        for(int i=1;i<rowList.size();i++){
            result.put(rowList.get(i).get(2),rowList.get(i).get(3));
        }
        return result;
    }

3、注意：
用postman测试可以成功，swagger暂时不可用