testng 接口测试，读取Excel表格数据，做数据驱动2(读取某些固定列数据)

public classTestRegister {


    @Test(dataProvider="datas")
    public voidtest1(String,url,String username,String pwd){
    
        Map<String, String> params = new HashMap<String, String>();
        params.put("username", username);
        params.put("pwd", pwd);
        System.out.println(HttpUtils.doPost(params,url));
    }

    @DataProvider
    publicObject[][] datas(){
        //取出固定列的数据
        int[] rows = {1,2,3,4,5,6};
        int[] cols = {2,3,4};
        Object[][] datas = ExcelUtil.readExcel2("C:\\Users\\Administrator\\Desktop\\register.xls",rows,cols);
        returndatas;
    }

}

    public static Object[] [] readExcel2(String  url,int[] rows,int[] cols){

        Object[] [] datas = newObject[rows.length][cols.length];
        //获取Workbook对象
        try{
            File file = newFile(url);
            Workbook workBook =WorkbookFactory.create(file);
            //获取sheet 对象
            Sheet sheet =  workBook.getSheet("Sheet1");
            DataFormatter  formatter = newDataFormatter();
            //获取行
            for(int i = 0;i < rows.length ;i++){
                Row row =sheet.getRow(rows[i]);
                for(int j = 0;j < cols.length;j++){
                    Cell cell =row.getCell(cols[j], Row.MissingCellPolicy.CREATE_NULL_AS_BLANK);
                    String value =formatter.formatCellValue(cell);
                    datas[i][j] =value;
                }
                System.out.println();
            }
        } catch(IOException e) {
            e.printStackTrace();
        }

        returndatas;
    }