@Test1 @Test2 . . .@TestN Read Different Test Data from Excel for Each Test Cases in Selenium

@Test1 Test2 . . .TestN Read Different Test Data for Each Test Cases in Selenium TestNG Framework tutorial || How to Read Data from Excel and Convert into HashMap || Read Excel and Store in HashMap Java #TestDatainSelenium #readexcelfile #seleniumtutorial
Previous tutorial - • Read Data from Excel a...
Subscribe to this channel and press bell icon to get some more interesting videos on Selenium and Automation:
www.youtube.co...
Follow me on groups - / 247868358996762
/ 10393547

[@HafizurRahman-dr3xe]

Very much impressive, go ahead.

[@vinothmurali]

Still here, the index is hardcoded, which again will be questioned? Is it possible to get the data using testcase name rather than Index?

[@testerstalk]

Thanks for watching this tutorial. There are other ways check below videos. Here is the answer for your question. Part 1 - kzbin.info/www/bejne/p4jKopZqrbR_a9E Part 2 - kzbin.info/www/bejne/aHLck2iEnL6AbtU

[@AthenaTolga]

Thank you !

[@testerstalk]

You're welcome!

[@sharmilam3143]

Thanks

[@testerstalk]

Thanks for watching! Please share these tutorials with your network 😊

[@Knotoriouz]

why don't you provide the code set along with explanation in some readable document. That makes it more useful. easy to use the code and understand the implementation

[@testerstalk]

Code is already in the channel comments.

[@sunilpandey7197]

@@testerstalk Sorry, somehow, I am not able to find the code. Could you please help me?

[@akashmaurya4495]

Thanks for an amazing explanation. I have a question where if we don't know the index but want to run the test case with test case name. is it possible? Thanks in advance.

[@DileepKumar-wh5zf]

Wonder ful Explanation.. Why only TreeMap here? Can you please explain me?

[@yuvashreeravindranathrao2926]

Hi, Can you create a video on generating testng xml from java code for test cases marked yes in excel test suite(contains class names of each test case in one column). Programmatically created Testng xml will contain all the class names which needs to be executed.

[@akhileshreddy7941]

Very Useful Thank you so much, and I need to Iterate @test methed with out hard coding with get(0),Get(0) how to do that can you please explain?

[@sharmilar6856]

Is there any video that using Web element for selecting drop down from Xlsheet in selenium

[@testerstalk]

No as of now. i will cover it in the future.

[@abdelshafysoliman5031]

thanks alot in advance , i have a question , in your example in excel sheet if i need to delete any cell from any column like password or user ...etc how i can do it , in other mean how i can read blank cell in our coulmns ?

[@testerstalk]

Thanks for visiting my channel, before answering your question... Can you tell me what point of reading blank cell.?... without a text box or any other requirement we don't have to read data from external source...

[@abdelshafysoliman5031]

@@testerstalk thanks for your reply , i make some test cases to test login page and i read test data from excel sheet by DDT when i read negative test cases like let user name and password are empty i have error but if i entered them will work correctly , how can i read empty cells from excel sheet by DDT ?

[@satishchandra6623]

Hi. Just one doubt ? Why can't we create List(Hashmap )

[@testerstalk]

You can try it out!!

[@namburinagarjuna2718]

integers are not getting read with this method,do you have any updated lecture of the same code where the integers also read

[@satisht.v2182]

Hi, I have used this code. But I'm getting nullpointer exception. I dint use any return type in my code.. still facing this issue.

[@abdelshafysoliman5031]

check your test data in excel sheet not have a blank cell

[@testerstalk]

Hi Satish, May i know where exactly you are getting this error?

[@swathikurupalli9624]

Facing Nullpointerexception ,cannot invoke org.Apache.Poi.ss.Usermodel. Row.getCell(int) because row is null

[@purusottamdhall5559]

Can we use that yes no flag concept over here to read the corresponding data with yes flag and execute that, if its yes it will run, or else it won't.. gone through other videos of reading excel data with yes no flag but how to modify this with corresponding to yes or no flag.

[@22Shoyab]

Hi purusottam, Can you please help me the videos which you have found where you have used yes or no flag

[@i_am_reshad]

It is not right way to change every time test data from inside your code one by one in order to test with different data sets. it is not professional way of using data driven testing. you need to make more practice with test automation :)

[@anamikasrivastava3994]

can you provide the code or git hub link?

[@jonestako4721]

Thanks

[@testerstalk]

Thanks for visiting this video, keep visiting my channel for more interesting updates..