数组在Excel、Selenium和Java中迭代行

Question

我正在使用excel表格： Excel snapshot

需要在从getCelldata(rownum, colnum)获取值并从同一行验证相同值后，逐个迭代行。 但这里我只需要迭代行号

代码示例：

    @Test (priority=1, description = "Login Functionality") 
public void login() {

    driver.get(data.getProperty("base.url"));
    obj_login = new login (driver);
    ExcelBase.setExcelFileSheet("Capacitor_unit");
    obj_login.enter_username(ExcelBase.getCellData(3,1));
    obj_login.enter_password(ExcelBase.getCellData(3,2));
    obj_login.select_login();
}

下一个应该是(ExcelBase.getCellData(4,1))，然后是(5,1)，直到数据结束

完整类代码概述：

public class TC01_newDesign extends TestBase{

    login obj_login;
    createNewDesign obj_CreateNewDesign;
    saveDesign obj_SaveDesign;
    capacitorUnit obj_capacitorUnit;
    logout obj_logout;




    @Test (priority=1, description = "Login Functionality") 
    public void login() {

        driver.get(data.getProperty("base.url"));
        obj_login = new login (driver);
        ExcelBase.setExcelFileSheet("Capacitor_unit");
        ..
        obj_login.select_login();

    }

    @Test (priority=2, description = "Create new Design")   
    public void createNewDesign() {

        log.info("Create New Design");
        obj_CreateNewDesign = new createNewDesign (driver);
        ..
    }

    @Test (priority=3, description = "Capacitor Unit Design")   
    public void capacitorUnit() {

        log.info("Capacitor Unit Design");
        obj_capacitorUnit = new capacitorUnit (driver);
        ..

        log.info("Assert actual searched string with expected string from Excel.");
        assertStrings(obj_capacitorUnit.get_unitVoltage().replaceAll("\\s+",""),ExcelBase.getCellData(3,50));
        ..

    }


    @Test (priority=4, description = "Logout app")  
    public void logout() {

        log.info("Logout from CapDes");
        obj_logout = new logout (driver);


    }



}