P20 - Integration of Excel with Dataprovider | TestNG | Testing Framework |

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.hyrtutorials.com/2022/03/...
✴ 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.hyrtutorials.com
🔗 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

Пікірлер: 123

  • @HYRTutorials
    @HYRTutorials2 жыл бұрын

    ↔️ TestNG Playlist Link: bit.ly/3wXyuXB ✴ Checkout my other playlists: bit.ly/3gLIAVL ☕ Buy me a coffee: bit.ly/33ljBWc

  • @kishore2115

    @kishore2115

    2 жыл бұрын

    Bro report portal gurunchi explain chesthara?

  • @HYRTutorials

    @HYRTutorials

    2 жыл бұрын

    Em report portal buddy?

  • @ramanimoharil7991
    @ramanimoharil79912 жыл бұрын

    Just amazing explaination man... You told what is required ..long way to go..best luck for your career and lots of blessings

  • @HYRTutorials

    @HYRTutorials

    2 жыл бұрын

    Thankyou so much buddy

  • @prabasrini3099
    @prabasrini30995 ай бұрын

    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

  • @Nagasai-ri9wk
    @Nagasai-ri9wk8 ай бұрын

    Amazing explanation bro. Your playlist is enough to learn things in a easy way.

  • @marlynj7930
    @marlynj79302 жыл бұрын

    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.

  • @HYRTutorials

    @HYRTutorials

    2 жыл бұрын

    Thankyou buddy 😊

  • @ranapratap8480
    @ranapratap84802 жыл бұрын

    Crystal clear explanation, thanks for making this useful video, thank you❤❤🙏🙏

  • @HYRTutorials

    @HYRTutorials

    2 жыл бұрын

    Glad you liked it

  • @BN-bn9fk
    @BN-bn9fk8 ай бұрын

    Thank you buddy! Great approach!

  • @radhesaran1761
    @radhesaran1761 Жыл бұрын

    amazing way.....u have proper concept and very easy and understandable steps .heads of to u man.

  • @HYRTutorials

    @HYRTutorials

    Жыл бұрын

    Thanks buddy 😊

  • @Sumedha_N_Bandara
    @Sumedha_N_Bandara Жыл бұрын

    Very informative video. Learnt lot from this video. Thank you very much * wish you all the very best to make more leaning materials.

  • @HYRTutorials

    @HYRTutorials

    Жыл бұрын

    Thanks buddy 😊

  • @goutamnayak3685
    @goutamnayak3685 Жыл бұрын

    Excellent explanation sir, thank you so much for covering this concept

  • @HYRTutorials

    @HYRTutorials

    Жыл бұрын

    Thanks buddy 😊

  • @atulanand4164
    @atulanand41648 ай бұрын

    Excellent Explanation!!

  • @Aryan-fk5iy
    @Aryan-fk5iy Жыл бұрын

    Very much informtative......God bless u brother...Keep posting..

  • @HYRTutorials

    @HYRTutorials

    Жыл бұрын

    Thanks buddy 😊

  • @naveenmunnelli
    @naveenmunnelli2 жыл бұрын

    Top Class explanation, I love your all videos 😍

  • @HYRTutorials

    @HYRTutorials

    2 жыл бұрын

    Happy to hear that buddy

  • @nagasaimaddula56
    @nagasaimaddula563 ай бұрын

    Amazing explanation bro. Thank you:)

  • @poojajadhav9529
    @poojajadhav95292 жыл бұрын

    You are just excellent sir ❤️

  • @HYRTutorials

    @HYRTutorials

    2 жыл бұрын

    Thankyou buddy 😊

  • @bharathpybodi2842
    @bharathpybodi284229 күн бұрын

    Amazing videos Bro

  • @sridharr3924
    @sridharr3924 Жыл бұрын

    Very Nice Explanation Bro..

  • @HYRTutorials

    @HYRTutorials

    Жыл бұрын

    Thanks buddy 😊

  • @DebunkSensibly
    @DebunkSensibly10 ай бұрын

    Thank you so much!

  • @HYRTutorials

    @HYRTutorials

    10 ай бұрын

    Happy learning buddy 😊

  • @knjaswanthi9683
    @knjaswanthi96838 ай бұрын

    Excellent sir

  • @Bell4Fun
    @Bell4Fun2 жыл бұрын

    Bro ...you are doing great Job ...could you provide something on Design Patterns as this now trends during interview for SDET's 😉

  • @HYRTutorials

    @HYRTutorials

    2 жыл бұрын

    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.

  • @dileepvraj86

    @dileepvraj86

    Жыл бұрын

    @@HYRTutorials waiting sir....

  • @indiantourism975
    @indiantourism975 Жыл бұрын

    excellent explanation bro

  • @HYRTutorials

    @HYRTutorials

    Жыл бұрын

    Thanks buddy 😊

  • @SivaChaitanyaReddySanivarapu
    @SivaChaitanyaReddySanivarapu2 жыл бұрын

    Good Work Sir

  • @HYRTutorials

    @HYRTutorials

    2 жыл бұрын

    Thanks

  • @saurabhkumar5787
    @saurabhkumar578711 ай бұрын

    Nice explanation

  • @HYRTutorials

    @HYRTutorials

    10 ай бұрын

    Thanks buddy 😊

  • @munindharr1039
    @munindharr103911 ай бұрын

    super excellent

  • @HYRTutorials

    @HYRTutorials

    10 ай бұрын

    Thanks buddy 😊

  • @padminivenkataram524
    @padminivenkataram524 Жыл бұрын

    Hello, very nicely explained. Can we merge two data providers if we need to merge data from two excel files??

  • @HYRTutorials

    @HYRTutorials

    Жыл бұрын

    I don't think we can do that buddy

  • @user-lr5qx6lh2i
    @user-lr5qx6lh2i7 ай бұрын

    If we want to write data to excel cell dynamically how to do it pls explain...

  • @user-hc9lq7ui8h
    @user-hc9lq7ui8h9 ай бұрын

    agile, cucumber,apitesting,jira tool .... please explain all these

  • @mangeshpanchwagh9742
    @mangeshpanchwagh97422 жыл бұрын

    Sir can we add parallel= true in dataprovider so all will run simultaneously. It is very nice video.you explained nicely. Thank you sir

  • @HYRTutorials

    @HYRTutorials

    2 жыл бұрын

    Yes buddy. I have explained that in P21 video buddy

  • @chaitanyamutluri7580
    @chaitanyamutluri7580 Жыл бұрын

    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.

  • @HYRTutorials

    @HYRTutorials

    11 ай бұрын

    Which means you are trying to access the empty row or empty cell

  • @shubhamchinchalkar5010
    @shubhamchinchalkar50102 жыл бұрын

    great sir

  • @HYRTutorials

    @HYRTutorials

    2 жыл бұрын

    Thanks buddy 😊

  • @sonalishelar4242
    @sonalishelar4242 Жыл бұрын

    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 .

  • @HYRTutorials

    @HYRTutorials

    Жыл бұрын

    Try to increase the headspace of your eclipse buddy

  • @kishorebabu544
    @kishorebabu5444 ай бұрын

    hii i am work in intellij when i run this file it goes to the another file but current file is not running

  • @JeyasankarA
    @JeyasankarA Жыл бұрын

    Hi Bro Your teaching was very useful. Can you put one video for json integration with DataProvider?

  • @HYRTutorials

    @HYRTutorials

    Жыл бұрын

    Yeah will plan that buddy

  • @chintadakiranraj7893
    @chintadakiranraj78939 ай бұрын

    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

  • @amerkhan2934
    @amerkhan2934 Жыл бұрын

    @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

  • @HYRTutorials

    @HYRTutorials

    Жыл бұрын

    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

  • @kalaimohan5421
    @kalaimohan54212 жыл бұрын

    Thank u

  • @HYRTutorials

    @HYRTutorials

    2 жыл бұрын

    Glad you liked it buddy 😊

  • @srinivas4449
    @srinivas44492 жыл бұрын

    Good work

  • @HYRTutorials

    @HYRTutorials

    2 жыл бұрын

    Thank you so much 😀

  • @srinivas4449

    @srinivas4449

    2 жыл бұрын

    @@HYRTutorials welcome

  • @sairamchinnu3238
    @sairamchinnu32388 ай бұрын

    Please tell me how to read it for multiple sheets

  • @vanajachowdary3998
    @vanajachowdary399813 күн бұрын

    please make tutorials on page object model framework, i found no relevant clear tutorials for this

  • @foodie_monk_arya
    @foodie_monk_arya6 ай бұрын

    How to provide test data from excel to testcase using testng and pom

  • @chinni_channel.7587
    @chinni_channel.75872 жыл бұрын

    Nice

  • @HYRTutorials

    @HYRTutorials

    2 жыл бұрын

    Thankyou buddy 😊

  • @srikanthreddy6690
    @srikanthreddy66902 жыл бұрын

    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

  • @HYRTutorials

    @HYRTutorials

    2 жыл бұрын

    Did you mention the data provider to the test method?

  • @srikanthreddy6690

    @srikanthreddy6690

    2 жыл бұрын

    @@HYRTutorials yes mentioned sir can you provide your mail id I'll send the code which I wrote

  • @HYRTutorials

    @HYRTutorials

    2 жыл бұрын

    @@srikanthreddy6690 send the code on hyadagirireddytutorials@gmail.com

  • @sudhakarthangavelu7164
    @sudhakarthangavelu7164 Жыл бұрын

    How to pick data based on header name and store it in two dimensions array

  • @HYRTutorials

    @HYRTutorials

    Жыл бұрын

    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

  • @pandudamera7211
    @pandudamera72112 жыл бұрын

    Can you please make it one video of how to read data from Json and yaml sir

  • @HYRTutorials

    @HYRTutorials

    2 жыл бұрын

    yeah sure buddy

  • @ashishkumar-tm9cp
    @ashishkumar-tm9cp2 жыл бұрын

    can you make videos of maven with pom and log 4j ,jenkins,github please

  • @HYRTutorials

    @HYRTutorials

    2 жыл бұрын

    Sure will plan buddy

  • @mranjith6585
    @mranjith6585 Жыл бұрын

    can You do a video on passing data from a Pojo class of java which returns from a json file ?

  • @HYRTutorials

    @HYRTutorials

    Жыл бұрын

    Sure buddy

  • @NamRaj2021
    @NamRaj2021 Жыл бұрын

    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.

  • @HYRTutorials

    @HYRTutorials

    Жыл бұрын

    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

  • @sasikalachekuri7335
    @sasikalachekuri7335 Жыл бұрын

    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?

  • @HYRTutorials

    @HYRTutorials

    Жыл бұрын

    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.

  • @sasikalachekuri7335

    @sasikalachekuri7335

    Жыл бұрын

    @@HYRTutorials Thank you

  • @sajeerk5561
    @sajeerk5561 Жыл бұрын

    How to handle the browser closing after the test fails?

  • @HYRTutorials

    @HYRTutorials

    Жыл бұрын

    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

  • @PratikHood
    @PratikHood11 ай бұрын

    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.

  • @HYRTutorials

    @HYRTutorials

    10 ай бұрын

    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.

  • @rupaliranotkar8744
    @rupaliranotkar8744 Жыл бұрын

    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

  • @HYRTutorials

    @HYRTutorials

    Жыл бұрын

    Send me the screenshots on hyadagirireddytutorials@gmail.com

  • @AnilKumar-sf4em
    @AnilKumar-sf4em Жыл бұрын

    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

  • @HYRTutorials

    @HYRTutorials

    Жыл бұрын

    Thats not how you should be using the dataprovider buddy. But you can do that. Watch the indices concept in this playlist kzread.info/dash/bejne/lqNkpNOlj7S8mMo.html Apply this concept on your test methods and you are good to go.

  • @RamaKrishna-ng4of
    @RamaKrishna-ng4of Жыл бұрын

    Sir ,when i try to run its showing Data Provider Mismatch error

  • @HYRTutorials

    @HYRTutorials

    Жыл бұрын

    Did you provide the correct name buddy?

  • @pragyachauhan7377
    @pragyachauhan7377 Жыл бұрын

    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?

  • @dileepvraj86

    @dileepvraj86

    Жыл бұрын

    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.

  • @HYRTutorials

    @HYRTutorials

    Жыл бұрын

    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.

  • @nagasri3664
    @nagasri36642 жыл бұрын

    Giri... Do u have videos on POM

  • @HYRTutorials

    @HYRTutorials

    2 жыл бұрын

    No, I haven't created them yet

  • @nagasri3664

    @nagasri3664

    2 жыл бұрын

    @@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

  • @HYRTutorials

    @HYRTutorials

    2 жыл бұрын

    Sure buddy

  • @chaithramn6821
    @chaithramn68212 жыл бұрын

    Sir if I gave invalid username and password also it's showing test case pass

  • @HYRTutorials

    @HYRTutorials

    2 жыл бұрын

    Are you doing any assertion buddy?

  • @rajeshrao5099
    @rajeshrao50992 жыл бұрын

    Can you share code in description?

  • @HYRTutorials

    @HYRTutorials

    2 жыл бұрын

    Already the link is available in description buddy. Can u check

  • @sayyadimam434
    @sayyadimam4342 жыл бұрын

    How can we contact you sir?

  • @HYRTutorials

    @HYRTutorials

    2 жыл бұрын

    You can check the about section in my youtube channel buddy

  • @yay4meluigi
    @yay4meluigi7 ай бұрын

    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. 😢

  • @VishalSingh-we6zx

    @VishalSingh-we6zx

    9 күн бұрын

    Please try with CSV

  • @shareefnagoor4401
    @shareefnagoor44012 жыл бұрын

    Hii

  • @HYRTutorials

    @HYRTutorials

    2 жыл бұрын

    Hi

  • @sowjanyachattu5625
    @sowjanyachattu56252 жыл бұрын

    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

  • @HYRTutorials

    @HYRTutorials

    2 жыл бұрын

    U might have missed some library, check once

  • @sowjanyachattu5625

    @sowjanyachattu5625

    2 жыл бұрын

    @@HYRTutorials ok sir, thanks for ur reply

  • @kanaktandon1573
    @kanaktandon1573 Жыл бұрын

    System.out.print(sheet.getPhysicalNumberOfRows()); while executing this , i am getting ACCES IS DENIED Error

  • @HYRTutorials

    @HYRTutorials

    Жыл бұрын

    Did you set any password or special permissions to your excel file buddy? Or close the excel file and try again

  • @kishoripatil2302
    @kishoripatil2302 Жыл бұрын

    Getting exception as java.lang.NoClassDefFoundError

  • @HYRTutorials

    @HYRTutorials

    Жыл бұрын

    Change the jre system library and restart the eclipse buddy