P20 - Integration of Excel with Dataprovider | TestNG | Testing Framework |
Вставка
- Опубліковано 7 лют 2025
- In this video, I have explained about "Integration of Excel with Dataprovider ".
I have discussed about these below points:
1. Libraries available for reading the data from Excel file
2. Downloading and Installation of Apache POI java library
3. How to read the data from excel file dynamically?
4. How to create the dataprovider by reading the data from excel file?
5. How to maintain the dataprovider in a separate class?
=======================================
▶️ Next Video Link: • P21 - Parallel executi...
◀️ Previous Video Link: • P19 - How to create th...
↔️ TestNG Playlist Link: bit.ly/3wXyuXB
🔗 Code used in this video: www.hyrtutoria...
✴ Checkout my other playlists: bit.ly/3gLIAVL
☕ Buy me a coffee: bit.ly/33ljBWc
👑 Join my youtube channel to get access to perks:👇
/ @hyrtutorials
========================================
========================================
Connect me @
🔗 Website - www.hyrtutoria...
🔗 Telegram - t.me/hyrtutorials
🔗 Facebook - / hyrtutorials
🔗 LinkedIn - / hyrtutorials
🔗 Twitter - / hyrtutorials
🔗 Instagram - / hyrtutorials
========================================
========================================
🙏 Please Subscribe🔔 to start learning for FREE now, Also help your friends in learning the best by suggesting this channel.
#hyrtutorials #selenium #testng
TestNG by Yadagiri Reddy
↔️ 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?
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
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
amazing way.....u have proper concept and very easy and understandable steps .heads of to u man.
Thanks 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 😊
Very much informtative......God bless u brother...Keep posting..
Thanks buddy 😊
Amazing explanation bro. Your playlist is enough to learn things in a easy way.
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 😊
Crystal clear explanation, thanks for making this useful video, thank you❤❤🙏🙏
Glad you liked it
very nice nyz class bro
Excellent Explanation!!
Thank you buddy! Great approach!
Top Class explanation, I love your all videos 😍
Happy to hear that buddy
Excellent explanation sir, thank you so much for covering this concept
Thanks buddy 😊
Amazing explanation bro. Thank you:)
excellent explanation bro
Thanks buddy 😊
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
Nice explanation
Thanks buddy 😊
Amazing videos Bro
Thank you so much!
Happy learning buddy 😊
Very Nice Explanation Bro..
Thanks buddy 😊
Excellent sir
You are just excellent sir ❤️
Thankyou buddy 😊
Awesome
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
super
excellent
Thanks 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
Good Work Sir
Thanks
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....
agile, cucumber,apitesting,jira tool .... please explain all these
@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.
@@HYRTutorials Thank you
Hi Bro Your teaching was very useful. Can you put one video for json integration with DataProvider?
Yeah will plan that buddy
Good work
Thank you so much 😀
@@HYRTutorials welcome
If we want to write data to excel cell dynamically how to do it pls explain...
great sir
Thanks buddy 😊
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
Can you please make it one video of how to read data from Json and yaml sir
yeah sure buddy
Please tell me how to read it for multiple sheets
Nice
Thankyou 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
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
How to call a particular only string from Excel sheet using dataprovider in Test by passing row and column from Test method
hii i am work in intellij when i run this file it goes to the another file but current file is not running
Thank u
Glad you liked it 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
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
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.
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.
can you make videos of maven with pom and log 4j ,jenkins,github please
Sure will plan buddy
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.
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
can You do a video on passing data from a Pojo class of java which returns from a json file ?
Sure buddy
How to provide test data from excel to testcase using testng and pom
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
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
Sir ,when i try to run its showing Data Provider Mismatch error
Did you provide the correct name buddy?
Sir if I gave invalid username and password also it's showing test case pass
Are you doing any assertion buddy?
Bro null pointer exception Ani vasthundi bro
Exception in thread "main" java.lang.NullPointerException: Cannot invoke "org.apache.poi.xssf.usermodel.XSSFRow.getLastCellNum()" because the return value of "org.apache.poi.xssf.usermodel.XSSFSheet.getRow(int)" is null
at selenium.XLdata.main(XLdata.java:18)
Help me bro
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
Can you share code in description?
Already the link is available in description buddy.
Can u check
How can we contact you sir?
You can check the about section in my youtube channel buddy
Hii
Hi
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
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