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

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

on 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