Read data from Excel to DataProvider in Selenium

We can read data from Excel by using Apachi POI.

Hi Krishna, Can you tell me how to merge two data providers?
@DataProvider
public static Object[][] getStep1TestData()

{
Object data1[][]= TestUtil.getTestData(sheet1);

return data1;
}


@DataProvider
public Object[][] getStep2TestData()

{
Object data2[][]= TestUtil.getTestData(sheet2);
return data2;
}

@DataProvider
public Object[][] mergeData()

{


}

@Test(dataProvider="mergeData")
public void validateStep2Page(String customer, String customertype, String iscontractsigned, String productname,String productamount,String locationname,
String address1,String address2,String city,String state,String postalcode,String county,String country,String daysofservices,String servicebranchcode,
String csvbranchcode,String product,String quantity,String changeorder) throws Exception

{
salescreatecontractstep1Page.addloc1(customer,customertype,iscontractsigned,productname,productamount) ;
salescreatecontractstep2Page.addlocation(locationname, address1, address2, city, state, postalcode, county, country, daysofservices, servicebranchcode, csvbranchcode, product, quantity, changeorder);


}

thank you

hi sir give a ExcelRead data code and share your github link

Thanks bro..

Hello Krishna ,
If we add one more coloumn "Run_Status" and set it as Y. How we will do that ?

Sir,your video is very helpful plz could you explain click,double click,and drop down option using through this way means it's very helpful sir

gettting error- the data provider 'userData' returned an empty array or iterator, so this test is not doing anything

Hi Krishna, In Dataprovider approach , i have noticed that we need to give same number of arguments in the function as the number of columns we have in the excel. Is there an approach in Test dataprovider in which i can only fetch data from few columns ? Suppose my excel has 10 columns and i only want to fetch data from any 3 columns, would it be possible in TestData provider ?

Hi Krishna,

Thanks a lot. It is really good and useful... Keep up the Good Work.

please provide solution Dataprovider trying to pass one parameter but method takes 3

Hi Krishna,
Very good video.
I have one problem. when I write in ExcelAPITest class 'CellTYPE' its giving me compile error, what is solution do i need to import anything?
please Reply
Thanks

Hi - Can you please share the getCellData() method code?

Too good . From basics to advance. Very nice

Hello Krishna. Thanks for your share, it's very helpful.

Hello Krishna,

Thanks for the informative videos you have posted. I saw all the excel related videos and while accessing excel through Dataprovider, i copied your code exactly how its shown in the video. But, i am being presented with the following error- "Data provider mismatch". Could you please help me resolve this issue???

hi Krishna,
your effords was tooo good really greate yar but can u answer my question ?
my question is what is difference between to use reading data from excel dataprovider and apage poi ???what is the difference between poi and dataprovider???

"ExcelApiTest" got a compileError .what type of jar file required to avoid this error.

Hello sir, from the class"ExcelToDataProvider" the last section where we have"excelData[i-1][j] = eat.getCellData(sheetName, j, i);" i am getting error on eat.getCellData

When i hover over it says "The method getCellData(string int, int) is undefined for the type ExcelApiTest.
Can you please help

Hello Krishna Sakinala sir, it would be very helpful if you will please provide the file "ExcelApiTest".