读Excel文件的Java相关的代码，仅供参考

private List<RetParam> readExcelFile(String reqParamPath) throws IOException {
    List<RetParam> list = new ArrayList<>(); 
    File excelFile = new File(path);
    FileInputStream fileInputStream = new FileInputStream(excelFile);
    XSSFWorkbook workbook = new XSSFWorkbook(fileInputStream);
    Sheet sheet = workbook.getSheet("Sheet1");
    int totalRowNum = sheet.getPhysicalNumberOfRows();// 获取总行数
    for (int i = 1; i < totalRowNum; i++) {
        Row row = sheet.getRow(i);//获取每一行
        RetParam retParam = new RetParam();
        if(Objects.isNull(row.getCell(m)) || row.getCell(m).getStringCellValue()==""){
            retParam.setField(null);//excel表格中的单元格可能为空
        }else{
            retParam.setField(row.getCell().getStringCellValue());
        }
       list.add(retParam); 
    }
    return list;    
}

对应的excel表格格式如下：