Reading Data from Excel Sheet in Selenium WebDriver

Question

I am Using Selenium WebDriver and reading Data from a excel sheet that contains

Username and Password but the problem is this sheet contains both numeric Values and String Values due to which its throwing error:

Cannot get a STRING value from a NUMERIC cell

Username: rainrrr , shamz, tabraiz

Password: rainrrr ,123456,123456

Please Help

public void AdminLogin(String UserName, String Password) throws Exception
{

    System.setProperty("webdriver.chrome.driver", "C:\\Users\\amomin\\Desktop\\selinium\\chromedriver.exe");
     driver =new ChromeDriver();
    driver.manage().window().maximize();
    driver.manage().timeouts().implicitlyWait(15, TimeUnit.SECONDS);

    driver.get("My Path");

    driver.findElement(By.xpath(".//*[@id='UserName']")).sendKeys(UserName);

    driver.findElement(By.xpath(".//*[@id='Password']")).sendKeys(Password);

    driver.findElement(By.xpath(".//*[text()='Submit']")).click();

    Thread.sleep(5000);


    Assert.assertTrue(driver.getTitle().contains("Dashboard - RainMaker"),"Login Fail");

    System.out.println("User Login Successfully");

}
public Object[][] LoginData()
{


    libDDT config=new libDDT("C:\\Users\\amomin\\workspace\\DataDrivenTest\\TestData\\TestData.xls");
    int rows=config.getRowCount(0);

    Object[][] data = new Object[rows][2];

    for(int i=0;i<rows;i++)
    {

        data[i][0]=config.getdata(0, i, 0);
        data[i][1]=config.getdata(0, i, 1);

    }

    return data;
}

If the string is starting with number, in excel, format data as text by prefixing numeric value with single quotation ('). Ex: 123 as '123 — Girish Bellamkonda
– Girish Bellamkonda, Commented Dec 21, 2016 at 12:16

Girish Bellamkonda · Accepted Answer · 2016-12-23 03:00:13Z

1

Try this by saving Numeric values in text format.

If the string is starting with number, in excel, format data as text by prefixing numeric value with single quotation ('). Ex: 123 as '123

answered Dec 23, 2016 at 3:00

Girish Bellamkonda

5011 gold badge8 silver badges17 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Reading Data from Excel Sheet in Selenium WebDriver

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related