Thankyou buddy. Yes now a days it's being asked in many interviews even though some of them are not really used in the projects. I will make the videos on those.
@HYR Tutorials . Hi Reddy sir , It is very helpful video for me , can you tell me if we are using standalone Mobile apk and we are passing the credentials from the xl sheet , how we can implement quit method() , Because after running one time its not going for second iteration , I think you have missed this in this video
usually every test should start the browser freshly and thats whyi have shown like this buddy. but if we wanted to keep the instance then we can call the quit method in aftersuite annotation
Hello Mr. Reddy , I have been watching testNG series from past two days the way you are explaining is too good, I have a question on excel data provider, In this video you have hard coded the excel file name in excelDataSuplier class as static , but I want to pass the excel file name from the main test, Is it possible if yes ? How?
That is little difficult, but you can identify which test method is calling that dataprovider and based on that you can decide which excel file you want to use. To achieve this you need to add one parameter called Method m to the data provider. this m variable will give you the information about the test method.
hi bro,thanks for all of your viedos. Naku 1st set data print avtundhi, After that [ java.lang.NullPointerException: Cannot invoke "org.apache.poi.xssf.usermodel.XSSFCell.getStringCellValue()" because the return value of "org.apache.poi.xssf.usermodel.XSSFRow.getCell(int)" is null ] error vastundhi.
I have small doubt ...bro you manually run the three test cases or they automatically done ???? Can we run 3 test cases by creating three methods and giving test method priority.
Yes we can do that buddy. When u execute the TestNG class, it executes all the test methods present in it. But if you want to execute only few methods as part of one test and few other as part of another test then you can use TestNG xml file buddy
Hi sir have one query, suppose if you have two test cases one is login and one is log out before test I have initialized the url after test i have used driver.quit method iam running these cases through testng xml file ihave applied the data provider concept like you said how it will execute it's not going to second user
Hi Yadagiri, My requirement is, dataprovider having {1}{2}{3} data and I have 3 methods in a class, I want to pass {1} to first method and {2} to second method and {3} to third method, Is it possible, Plz provide the solution. Thanks kumar
Thats not how you should be using the dataprovider buddy. But you can do that. Watch the indices concept in this playlist ua-cam.com/video/do0Bql_QVhg/v-deo.html Apply this concept on your test methods and you are good to go.
@@HYRTutorials please do it, when you have time.. that will be helpful to many people.. why I am asking you mean your way of explanation is clear to understand
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.
You can't find the videos as it is custom requirement buddy. But if you understand the excel reading concept, designing this requirement won't be that difficult.
We need to implement that logic buddy. First you should know how to read data from excel then you can iterate the rows and store it into the object array
I have one doubt, this video is based upon 2-d array having multiple username and password only in Excel sheet. But can you tell me, what IF in Excel there are more than 5-10 columns...what will be the dimension of array object in data provider? Do I have to create object array with 5-10 [][][] brackets in data provider ? What is the approach we should use in this case?
No even if we have 10 0r 20 columns in sheet, two-dimensional array will do the job for us, All we have to do is change the parameters type in method which is using data provider to array and use those variables in array in test method.
You can handle it in after test annotated method buddy. Just like how we capture screenshots on test failure. There is one video I have created on the screenshots capturing thing. That gives you the idea
Hi sir Can you tell me plz I have the pivot table If I enter the values in the one column cell the some columns in same row was filling automatically because of formule. But while entering values into column through Java code it is not reflecting the formule just it is filling the particular column only. But manually formule is apply but for the same sheet .it is not working through Java code how can we do that can you plz any hint or any suggestions plz
DON’T DO IT! It is an absolute nightmare because Git cannot see XLSX files or handle merge conflicts. I’m forced to use a repo with this setup and we can’t see the xlsx updates in Pull Requests and data is always getting mistakenly deleted from the excel sheets when PRs are merged. 😢
Hi sir, I'm getting this exception(Exception in thread "main" java.lang.NoClassDefFoundError: org/apache/commons/io/output/UnsynchronizedByteArrayOutputStream). could u please tell me the solution
↔️ TestNG Playlist Link: bit.ly/3wXyuXB
✴ Checkout my other playlists: bit.ly/3gLIAVL
☕ Buy me a coffee: bit.ly/33ljBWc
Bro report portal gurunchi explain chesthara?
Em report portal buddy?
Very much informtative......God bless u brother...Keep posting..
Thanks buddy 😊
Your explanation is really awesome and we can compare it with real time scenario that not found in many other videos.. thank you so much
amazing way.....u have proper concept and very easy and understandable steps .heads of to u man.
Thanks buddy 😊
Just amazing explaination man... You told what is required ..long way to go..best luck for your career and lots of blessings
Thankyou so much buddy
I watch all your videos helps me a lot thank you sir....
Your videos are so informative----Your videos should have more views from aspirants like me!Thank You!I will share this video as much as I can.
Thankyou buddy 😊
Crystal clear explanation, thanks for making this useful video, thank you❤❤🙏🙏
Glad you liked it
Amazing explanation bro. Your playlist is enough to learn things in a easy way.
Top Class explanation, I love your all videos 😍
Happy to hear that buddy
Excellent Explanation!!
thanx dude ...i got it now also clear my java concepts ......
Very informative video. Learnt lot from this video. Thank you very much * wish you all the very best to make more leaning materials.
Thanks buddy 😊
Thank you buddy! Great approach!
Excellent explanation sir, thank you so much for covering this concept
Thanks buddy 😊
Amazing explanation bro. Thank you:)
excellent explanation bro
Thanks buddy 😊
Very Nice Explanation Bro..
Thanks buddy 😊
Nice explanation
Thanks buddy 😊
Amazing videos Bro
Hello, very nicely explained. Can we merge two data providers if we need to merge data from two excel files??
I don't think we can do that buddy
You are just excellent sir ❤️
Thankyou buddy 😊
Thank you so much!
Happy learning buddy 😊
super
excellent
Thanks buddy 😊
Good Work Sir
Thanks
Excellent sir
Sir can we add parallel= true in dataprovider so all will run simultaneously.
It is very nice video.you explained nicely. Thank you sir
Yes buddy. I have explained that in P21 video buddy
Bro ...you are doing great Job ...could you provide something on Design Patterns as this now trends during interview for SDET's 😉
Thankyou buddy.
Yes now a days it's being asked in many interviews even though some of them are not really used in the projects.
I will make the videos on those.
@@HYRTutorials waiting sir....
@HYR Tutorials .
Hi Reddy sir , It is very helpful video for me , can you tell me if we are using standalone Mobile apk and we are passing the credentials from the xl sheet , how we can implement quit method() , Because after running one time its not going for second iteration , I think you have missed this in this video
usually every test should start the browser freshly and thats whyi have shown like this buddy. but if we wanted to keep the instance then we can call the quit method in aftersuite annotation
Good work
Thank you so much 😀
@@HYRTutorials welcome
Hello Mr. Reddy , I have been watching testNG series from past two days the way you are explaining is too good, I have a question on excel data provider, In this video you have hard coded the excel file name in excelDataSuplier class as static , but I want to pass the excel file name from the main test, Is it possible if yes ? How?
That is little difficult, but you can identify which test method is calling that dataprovider and based on that you can decide which excel file you want to use.
To achieve this you need to add one parameter called Method m to the data provider. this m variable will give you the information about the test method.
@@HYRTutorials Thank you
hi bro,thanks for all of your viedos. Naku 1st set data print avtundhi, After that [ java.lang.NullPointerException: Cannot invoke "org.apache.poi.xssf.usermodel.XSSFCell.getStringCellValue()" because the return value of "org.apache.poi.xssf.usermodel.XSSFRow.getCell(int)" is null ] error vastundhi.
Which means you are trying to access the empty row or empty cell
Hi Bro Your teaching was very useful. Can you put one video for json integration with DataProvider?
Yeah will plan that buddy
I have small doubt ...bro you manually run the three test cases or they automatically done ???? Can we run 3 test cases by creating three methods and giving test method priority.
Yes we can do that buddy.
When u execute the TestNG class, it executes all the test methods present in it. But if you want to execute only few methods as part of one test and few other as part of another test then you can use TestNG xml file buddy
agile, cucumber,apitesting,jira tool .... please explain all these
Awesome
Hi sir have one query, suppose if you have two test cases one is login and one is log out before test I have initialized the url after test i have used driver.quit method iam running these cases through testng xml file ihave applied the data provider concept like you said how it will execute it's not going to second user
Did you mention the data provider to the test method?
@@HYRTutorials yes mentioned sir can you provide your mail id I'll send the code which I wrote
@@srikanthreddy6690 send the code on hyadagirireddytutorials@gmail.com
Can you please make it one video of how to read data from Json and yaml sir
yeah sure buddy
Sir i am getting an error : java.lang.OutOfMemoryError: Java heap space. So can you please suggest me what i am doing wrong. the code is same .
Try to increase the headspace of your eclipse buddy
great sir
Thanks buddy 😊
can you make videos of maven with pom and log 4j ,jenkins,github please
Sure will plan buddy
Hi Yadagiri,
My requirement is, dataprovider having {1}{2}{3} data and I have 3 methods in a class, I want to pass {1} to first method and {2} to second method and {3} to third method,
Is it possible, Plz provide the solution.
Thanks
kumar
Thats not how you should be using the dataprovider buddy.
But you can do that.
Watch the indices concept in this playlist
ua-cam.com/video/do0Bql_QVhg/v-deo.html
Apply this concept on your test methods and you are good to go.
Giri... Do u have videos on POM
No, I haven't created them yet
@@HYRTutorials please do it, when you have time.. that will be helpful to many people.. why I am asking you mean your way of explanation is clear to understand
Sure buddy
I followed the same steps but getting an error that can't invoke the method due to class mismatch
Can you reply it's very urgent
Send me the screenshots on hyadagirireddytutorials@gmail.com
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.
You can't find the videos as it is custom requirement buddy. But if you understand the excel reading concept, designing this requirement won't be that difficult.
If we want to write data to excel cell dynamically how to do it pls explain...
can You do a video on passing data from a Pojo class of java which returns from a json file ?
Sure buddy
How to pick data based on header name and store it in two dimensions array
We need to implement that logic buddy.
First you should know how to read data from excel then you can iterate the rows and store it into the object array
Nice
Thankyou buddy 😊
I have one doubt, this video is based upon 2-d array having multiple username and password only in Excel sheet. But can you tell me, what IF in Excel there are more than 5-10 columns...what will be the dimension of array object in data provider? Do I have to create object array with 5-10 [][][] brackets in data provider ? What is the approach we should use in this case?
No even if we have 10 0r 20 columns in sheet, two-dimensional array will do the job for us, All we have to do is change the parameters type in method which is using data provider to array and use those variables in array in test method.
Here it doesnt matter about the number of columns in the excel sheet buddy. Even if you have 1000 columns it is going be a two dimensional array only.
How to call a particular only string from Excel sheet using dataprovider in Test by passing row and column from Test method
How to handle the browser closing after the test fails?
You can handle it in after test annotated method buddy. Just like how we capture screenshots on test failure.
There is one video I have created on the screenshots capturing thing. That gives you the idea
hii i am work in intellij when i run this file it goes to the another file but current file is not running
please make tutorials on page object model framework, i found no relevant clear tutorials for this
Hi sir
Can you tell me plz
I have the pivot table
If I enter the values in the one column cell the some columns in same row was filling automatically because of formule.
But while entering values into column through Java code it is not reflecting the formule just it is filling the particular column only.
But manually formule is apply but for the same sheet .it is not working through Java code how can we do that can you plz any hint or any suggestions plz
Sir ,when i try to run its showing Data Provider Mismatch error
Did you provide the correct name buddy?
Please tell me how to read it for multiple sheets
How to provide test data from excel to testcase using testng and pom
Can you share code in description?
Already the link is available in description buddy.
Can u check
Thank u
Glad you liked it buddy 😊
Sir if I gave invalid username and password also it's showing test case pass
Are you doing any assertion buddy?
DON’T DO IT! It is an absolute nightmare because Git cannot see XLSX files or handle merge conflicts. I’m forced to use a repo with this setup and we can’t see the xlsx updates in Pull Requests and data is always getting mistakenly deleted from the excel sheets when PRs are merged. 😢
Please try with CSV
Hi sir, I'm getting this exception(Exception in thread "main" java.lang.NoClassDefFoundError: org/apache/commons/io/output/UnsynchronizedByteArrayOutputStream). could u please tell me the solution
U might have missed some library, check once
@@HYRTutorials ok sir, thanks for ur reply
How can we contact you sir?
You can check the about section in my youtube channel buddy
Hii
Hi
Getting exception as java.lang.NoClassDefFoundError
Change the jre system library and restart the eclipse buddy
System.out.print(sheet.getPhysicalNumberOfRows());
while executing this , i am getting ACCES IS DENIED Error
Did you set any password or special permissions to your excel file buddy?
Or close the excel file and try again