webFlux框架postman导入读取excel

1、maven引用

		<dependency>
			<groupId>org.apache.poi</groupId>
			<artifactId>poi</artifactId>
			<version>4.0.0</version>
		</dependency>
		<dependency>
			<groupId>org.apache.poi</groupId>
			<artifactId>poi-ooxml</artifactId>
			<version>4.0.0</version>
		</dependency>
		<dependency>
			<groupId>org.apache.poi</groupId>
			<artifactId>poi-ooxml-schemas</artifactId>
			<version>4.0.0</version>
		</dependency>

2、postman调用上传方法

注意key：excel 和后台 @RequestPart(“excel”) 保持一致

3、后端代码

用FilePart接收

处理FilePart

相关代码

/**
 * excel读写工具类
 */
@Slf4j
public class FilePartReadExcel {

    public static List<Map<Integer, Object>> readExcel(FilePart excel, int firstRowNum) throws IOException {
        File tempFile = null;
        Path tempFilePath = FileUtils.createTempFile(excel);
        AsynchronousFileChannel channel = null;
        CountDownLatch countDownLatch = new CountDownLatch(1);
        try {
            channel = AsynchronousFileChannel.open(tempFilePath, StandardOpenOption.WRITE);
            DataBufferUtils.write(excel.content(), channel, 0).doOnComplete(() -> countDownLatch.countDown())
                    .subscribe();
            tempFile = tempFilePath.toFile();
            countDownLatch.await();

            return FilePartReadExcel.readExcel(new FileInputStream(tempFile), firstRowNum);
        } catch (Exception e) {
            throw new RuntimeException(e);
        } finally {
            countDownLatch.countDown();
            tempFile.delete();
            CloseableUtils.close(channel);
        }
    }

    /**
     * 读入excel文件，解析后返回
     *
     * @param is
     * @param firstRowNum 获得当前sheet的开始行
     * @throws IOException
     */
    public static List<Map<Integer, Object>> readExcel(InputStream is, int firstRowNum) throws IOException {

        // 获得Workbook工作薄对象
        Workbook workbook = getWorkBook(is);
        // 创建返回对象，把每行中的值作为一个数组，所有行作为一个集合返回

        if (workbook == null) {
            return null;
        }

        // 获得当前sheet工作表
        Sheet sheet = workbook.getSheetAt(0);
        if (sheet == null) {
            return null;
        }

        List<Map<Integer, Object>> list = new ArrayList<>();

        // 获得当前sheet的结束行
        int lastRowNum = sheet.getLastRowNum();

        // 循环除了第一行的所有行
        for (int rowNum = firstRowNum; rowNum <= lastRowNum; rowNum++) {
            // 获得当前行
            Row row = sheet.getRow(rowNum);

            // 获得当前行的列数
            int lastCellNum = row.getLastCellNum();

            Map<Integer, Object> resMap = new HashMap<>();
            for (int cellNum = 0; cellNum < lastCellNum; cellNum++) {
                resMap.put(cellNum, getCellValue(row.getCell(cellNum)));
            }

            list.add(resMap);
        }
        workbook.close();
        return list;
    }

    public static void checkFile(MultipartFile file) throws IOException {
        // 判断文件是否存在
        if (null == file) {
            log.error("文件不存在！");
            throw new FileNotFoundException("文件不存在！");
        }
        // 获得文件名
        String fileName = file.getOriginalFilename();
        // 判断文件是否是excel文件
        if (!fileName.endsWith(".xlsx")) {
            log.error(fileName + "不是excel文件");
            throw new IOException(fileName + "不是excel文件");
        }
    }

    public static Workbook getWorkBook(InputStream is) {
        // 获得文件名
        // fileName = file.getOriginalFilename();
        // 创建Workbook工作薄对象，表示整个excel
        Workbook workbook = null;
        try {
            return new XSSFWorkbook(is);
//			// 获取excel文件的io流
//			//InputStream is = file.getInputStream();
//			// 根据文件后缀名不同(xls和xlsx)获得不同的Workbook实现类对象
//			if (fileName.endsWith(xls)) {
//				// 2003
//				workbook = new HSSFWorkbook(is);
//			} else if (fileName.endsWith(xlsx)) {
//				// 2007
//				workbook = new XSSFWorkbook(is);
//			}
        } catch (IOException e) {
            log.info(e.getMessage());
        }
        return workbook;
    }

    public static String getCellValue(Cell cell) {
        String cellValue = "";
        if (cell == null) {
            return cellValue;
        }
//        //把数字当成String来读，避免出现1读成1.0的情况
//        if (cell.getCellType() == CellType.NUMERIC) {
//            cell.setCellType(CellType.STRING);
//        }
        // 判断数据的类型
        switch (cell.getCellType()) {
            case NUMERIC: // 数字
                if (DateUtil.isCellDateFormatted(cell)) {
                    cellValue = new SimpleDateFormat("yyyy-MM-dd HH:mm:ss").format(cell.getDateCellValue());
                } else {
                    cell.setCellType(CellType.STRING);
                    return cell.getStringCellValue();

//                    cellValue = String.valueOf(cell.getNumericCellValue());
//                    if (cellValue.contains("E")) {
//                        cell.setCellType(CellType.STRING);
//                        return cell.getStringCellValue();
//                    }
                }
                break;
            case STRING: // 字符串
                cellValue = String.valueOf(cell.getStringCellValue());
                break;
            case BOOLEAN: // Boolean
                cellValue = String.valueOf(cell.getBooleanCellValue());
                break;
            case FORMULA: // 公式
                cellValue = String.valueOf(cell.getCellFormula());
                break;
            case BLANK: // 空值
                cellValue = "";
                break;
            case ERROR: // 故障
                cellValue = "非法字符";
                break;
            default:
                cellValue = "未知类型";
                break;
        }
        return cellValue;
    }

    public static void main(String[] args) throws IOException {
        var is = new FileInputStream("E:\\template.xlsx");
        var value = FilePartReadExcel.readExcel(is, 1);
        System.out.println(Json.asString(value));
    }

}

public class FileUtils {
    public FileUtils() {
    }

    public static final void deleteFile(File tempFile) {
        if (tempFile != null) {
            tempFile.delete();
        }

    }

    public static final Path createTempFile(FilePart part) {
        try {
            return Files.createTempFile("upload_temp_", part.filename());
        } catch (IOException var2) {
            throw new RuntimeException();
        }
    }

    public static final Path createTempFile(String name) {
        try {
            return Files.createTempFile("upload_temp_", name);
        } catch (IOException var2) {
            throw new RuntimeException();
        }
    }
}