Selenium Forum: Functional And Regression Testing Tool.
Would you like to react to this message? Create an account in a few clicks or log in to continue.
Search
Display results as :
Advanced Search
Latest topics
AEM Training | Free Online DemoWed Apr 21, 2021 5:45 pmazharuddin
c# PageFactory - issue initializing elementsFri Nov 01, 2019 8:40 pmthegoatboy
Selenium making automatic connection to random urlsMon Jul 08, 2019 12:58 pmrepairtechsolutions1
How can we design the custom framework in Selenium RCMon Jun 24, 2019 2:26 pmrandybonnettes
What are the new features in Selenium 3.0Tue Jun 18, 2019 5:37 pmpappyvicky
What are you using Selenium for? Fri Apr 12, 2019 3:52 amzhl
LIMITATIONS OF SELENIUMWed Apr 10, 2019 11:23 amswara
Navigation
 Portal
 Index
 Memberlist
 Profile
 FAQ
 Search

Go down
avatar
Chowdary.287
Posts : 1
Join date : 2014-04-28

How to pass the data to the @Test method with using @DataProvider Empty How to pass the data to the @Test method with using @DataProvider

Mon Apr 28, 2014 1:23 pm
Hi All,

I read the data from Excel sheet in data provider and return it an object, but while passing the data to the @ Test method i have to pass all the column names,Suppose if 30 columns are there in Sheet i have to pass 30 parameters in Test method, it's a hectic if columns will increase in Excel sheet,

how i have to pass the data to the @ Test method without declare all the parameters name in @ Test Method name it self.

My Code,

@ DataProvider(name="test2")
public Object[][] testData() throws Exception{

Object[][] testObjArray = getExcelData("D:\\Test_Data\\Testdata.xls","Sheet1 ");
return testObjArray;

}


@ Test(dataProvider="test2")
public void testMethod(String parameter1, String parameter2,
String parameter3, String parameter4, String parameter5,
String parameter6) throws Exception {

System.out.println(parameter1);
System.out.println(parameter2);
System.out.println(parameter3);
System.out.println(parameter4);
System.out.println(parameter5);
System.out.println(parameter6);
}

In the above test method, i passed 6 parameters because in Excel sheet 6 columns are available, if i didnt pass any single parameter it throws exception.
Is there any possibility to directly pass as a list or any other solution.

Am using Selenium Webdriver+Java+TestNG

Please help me.

Thanks in Advance,
Chowdary.
Back to top
Permissions in this forum:
You cannot reply to topics in this forum