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暂时不可用