selenium code to fetch data from excel

Question

I am using below mentioned selenium code to fetch data from excel and type that in textbox of website. It is fetching and storing data correctly in object array but it is giving me error while writing that data in excel i.e last line of the code is not working. Can anyone help me that how can i pass value of obj[0][2] into textbox ?

XLSDatatable_Connectivity data= new XLSDatatable_Connectivity (System.getProperty("user.dir") +"\\src\\Excel\\CreateUser.xlsx");    
int rows= data.totalRow("CreateUser");
int column= data.totalColumn("CreateUser");


Object obj[][]=new Object[rows-1][column];

for(int row=2; row<=rows;row++)
{
    for(int col=0;col<column;col++)
    {
    obj[row-2][col]= data.getData("CreateUser", col, row);
    }
}

driver.findElement(By.xpath("//*[@id='oUsersInfo_Name']")).sendKeys(obj[0][2]);

Holy crap. Selenium can pull data from Excel. I didn't know that, thanks. — Glen Pierce
– Glen Pierce, Commented Apr 22, 2017 at 19:06
@GlenPierce XLSDatatable_Connectivity is not a Selenium Class. He probably made the class himself or uses a library. — Simon Baars
– Simon Baars, Commented Apr 22, 2017 at 20:13
@swati It looks like bad design you're getting "Object" classes out of the excel sheet. There's no way to know what type of stuff you're trying to put into the textfield for us now. Could you clear up where the XLSDatatable_Connectivity class comes from? — Simon Baars
– Simon Baars, Commented Apr 22, 2017 at 20:16
@GlenPierce Selenium isn't pulling data from Excel. That's Java and some other library. — JeffC
– JeffC, Commented Apr 23, 2017 at 0:37

jithinkmatthew · Accepted Answer · 2017-04-23 06:45:31Z

1

You should use @Dataprovider to pass your test data into test class. Please follow this Link

answered Apr 23, 2017 at 6:45

jithinkmatthew

9608 silver badges17 bronze badges

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

Collectives™ on Stack Overflow

selenium code to fetch data from excel

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