- Chowdary.287
- Posts : 1
Join date : 2014-04-28
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.
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.
Permissions in this forum:
You cannot reply to topics in this forum