Selenium Framework - Part 26 - Running iterations for a tests from excel - Data provider with Excel

Hi All,

In this video I have explained about the below topics,

1. Answering clarification from subscriber.
2. Creating sheet with test data.
3. Understanding the mapping between tests and test data.
4. Integration with Excel.
5. Controlling test iterations from excel sheet.

********************************
Understanding listeners

Dataprovider:

Integrating data provider with framework:

[bkumarj]

Your awesome Amuthan bro...now your videos became very interactive...thanks a lot for this video...🙏🏻🙏🏻🙏🏻🙏🏻

[tapaskhandai]

Thanks Amuthan bro. This is completely different from other videos available in YouTube

[supriyassampath]

Thank you so very much for this new concept bringing here to all of us.. really appreciate your efforts. God bless

[Payazee]

I like your one sententence "When we know we are doing something wrong, it's always good to fix it"
this contents are very useful. learning new thing daily. :)

[arunkumarmurugesan]

Learning some new things on your every video...

[ctacts]

I am worring that we can click like button only once.
@Testing Mini Bytes It's greate effort to make the topics very easily understandable.

[chaitanyabuddi]

Hi Amuthan.. Your videos are awesome... I'm learning new things in each video... Can you please update on below questions:
1. Can we use same framework for defining feature files and implementing stepdefintions? If yes, Can you please do a video on it
2.And listeners will work in Cucumber Framework? If yes, can you please do a video on it
--Thanks

Thanks Amruthan for.these amazing contents..very rarely seen in any youtube channel...plz continue ans possible plz explain how to.write a proper test and its assertion in test method and.how automation process are been.followed like hw are regression suite been run in.organisationn etc

[veeraraghavan]

Hi Amuthan, This is indeed a great video about the usage of IMethodInterceptor and Data Provider. Thanks much for the detailed explanation.

I have a query. My current project framework uses @Factory annotation in the constructor of every test class file and tagged with data provider i.e., data provider is not tagged to the individual tests present in a class file rather it is tagged to the constructor with @Factory annotation. It also also uses IMethodInterceptor listener. The reason for this approach could be that multiple test cases are tagged to a single test method (in its description e.g., @Test (description = TC-001#TC-002) and the class file has more than 20 test methods in it. Can you please enhance this video using @Factory annotation (along with data provider and IMethodInterceptor) to pass data to tests that executes multiple cases

[binitarathour]

Hello, sir thanks a lot for this video, it helps a lot to understand concepts, Thank you much again. I have one request if you have a rest assured related video please share, need it!

[bikashtesting]

Hi amudan,
Thank you for teching the framework concept.i need to know how to read and right multiple valu .how to formfilup.and can using excel utils give multiple in put

[sunilkumarakumalla]

Good Content Again!!
Can you also make a video on JSON DataProvider with multiple JSON Arrays and Testcasename as reference using Hashmaps.
It will be really great if we integrate the similar framework with latest Cucumber Version and TestNG. As Parallel Execution and Data Injection is bit different through Feature files. Thanks in advance :)

[pavithrasathyanarayanan]

I am not able to return 1D Object array for data provider method, Getting following compile time error in IDE 'Data provider must return Object[][] or Iterator<Object[]> ' . Can someone help me on this

Hi Amruthan, one doubt, we have a. Regression suite of 150 test cases but upon running all.of them.half of fails Not due to any bug Or locator issues, fails due to.other reasons... How to.avoid this Or wats the best standard way

[PratikHood]

Hello Sir,

Can you create a video where we can fetch the data from excel using the test case name. My team is trying to lot to search such kind of tutorial but we are not getting it.


Logic we are looking for : First it will search for the workbook then sheetName and then TestCaseName and the data which is inline with the test case, that will be fetch in the Test case.

[maxsudik]

Hi Amuthan, I'm just wondering with this approach of managing tests using excel sheet, how can we be sure that multiple engineers who work on the project included those tests in the datasheet? I mean, by mistake someone can just forget to include it in the file and this test will never run. What would you suggest? What are other ways to manage tests and map them between external sources and methods annotated with @Test.
Thank you!

[rajasekharmaddigalla]

Hi Amuthan, in this at video time line 22:53 you are passing map as an argument to loginlogouttest, if I want to use/call this method into another class how can I do that, please advise this is the only step disturbing me a lot?

[caesarcaesar]

"Data Provider must return either Object[][] or Iterator<Object>[], i follow you same code, but face that issue. it because of different version Apache poi or TestNg with you or any other issue? Thank you

[niranjansai]

Need to implement for noOfFields to click uparrow and downarrow if i increase in webpage then it should select 9 fields from excel it should select only nine if i decrease 2 fields for next run then it should run again and select for how many fields are there it should run up to that fields and close the execution and in excel also i need to implement row by row it should select for increase of fields is it possible

[lingeshsd]

Hi Amuthan bro, if I want to get data from multiple sheets instead of getting from one sheet and also if I want to give execute controls to sheet name to run instead of testname in the Run manager. how can we do that in the framework?