• [SoapUI] 在SoapUI里获取Excel中多行数据并存入List


    ArrayList<ArrayList<String>> getCellValuesH( String filePath, String sheetName,int tr1,int tr2,int td1,int td2){
        ArrayList<ArrayList<String>> cellValues = new ArrayList<ArrayList<String>>();
        try{
            File file = new File(filePath);
            XSSFWorkbook wb = new XSSFWorkbook(new FileInputStream(filePath));
            XSSFSheet sheet = wb.getSheet(sheetName);
            int trLength = sheet.getLastRowNum();
            Row row = sheet.getRow(0);
            int tdLength = row.getLastCellNum();
            String cellValue;
            if(sheet != null){
                for(int i=tr1; i<=tr2; i++){
                    ArrayList<String> rowCellValue = new ArrayList<String>();
                    Row row1 = sheet.getRow(i);
                    for(int j=td1; j<=td2; j++){
                        cellValue = row1.getCell(j);
                        rowCellValue.add(cellValue.trim());    
                    }
                    cellValues.add(rowCellValue);
                }
             }        
            return cellValues;
        }
        catch (Exception e){
            e.printStackTrace();
            return null;
         }
    }
  • 相关阅读:
    按回车键提交表单
    Access数据库类型及属性
    Problem 1002
    问题 1003
    Problem 1003
    Switch Game(摘自LP学C++)
    1006
    膜拜蛇形矩阵
    A == B?
    Rectangles
  • 原文地址:https://www.cnblogs.com/wynlfd/p/6245253.html
Copyright © 2020-2023  润新知