Selenium How to do Data Driven Testing with Excel

00:00 *TOPICS* How to Read data from excel/csv files How to Use data for testing How to run Test with multiple sets of data and show in Reports How to get data from a data provider method and testng.xml How to Implement Data-Driven Testing (Excel/CSV) 01:17 STEP 1 - Add Apache POI Dependency to pom.xml Update maven project mvn clean install 03:44 STEP 2 - Create an Excel File TestData.xlsx Add test data 08:19 STEP 3 - Create ExcelUtils.java to Read Data 22:23 STEP 4 - Modify LoginTest.java to Use Data from Excel 36:05 STEP 5 - Run tests and check reports Refer Read Write Excel video - https://www.youtube.com/watch?v=B4G2tMDYjRQ - 40:55 How to get data from a data provider method 41:32 STEP 1 - Create a data provider method and annotate with @DataProvider(name = "LoginData") 44:48 STEP 2 - Annotate the test function to use this data provider 45:50 How to get data from testng.xml 47:21 STEP 1 - Modify testng.xml to Pass Parameters 49:58 STEP 2 - Use @Parameters in LoginTest.java 52:57 Ending My Project - https://github.com/Raghav-Pal/SeleniumAutomationFramework2025 Full Playlist - https://www.youtube.com/playlist?list=PLhW3qG5bs-L_zQUmcXPs0F_e159DZ8OrP ▬▬▬▬▬▬▬ Share with all who may need this If my work has helped you, consider helping any animal near you, in any way you can Never Stop Learning Raghav Pal ▬▬▬▬ USEFUL LINKS ▬▬▬▬ ✅ ALL TUTORIALS - https://AutomationStepByStep.com/ ✅ CI | CD | DEVOPS Jenkins Beginner - https://bit.ly/2MIn8EC Jenkins Tips & Trick - https://bit.ly/2LRt6xC Docker - https://bit.ly/2MInnzx Jenkinsfile - https://bit.ly/3JSMSZ7 Kubernetes - http://bit.ly/2MJIlMK Vagrant - https://bit.ly/3MVKdBt Ansible - https://bit.ly/3MUsY3h Terraform - https://bit.ly/4hMh3l6 ✅ WEB TESTING Selenium Beginners - https://bit.ly/2MGRS8K Selenium Java Framework from Scratch - https://bit.ly/2N9xvR6 Selenium Python - https://bit.ly/2oyMp5x Selenium 4 - https://bit.ly/3AiJOlP Selenium Tips - https://bit.ly/2owxc50 Selenium Builder - https://bit.ly/2MKNtlq Katalon Studio - https://bit.ly/2wARFdi Robot Framework with RIDE- https://bit.ly/2Px6Ue9 Robot Framework with Eclipse - http://bit.ly/2N8DZxb Testim - https://bit.ly/3VbnNQb TestCafe - https://bit.ly/3O6eYmK AccelQ - https://bit.ly/3PlsAsh Cucumber BDD - https://bit.ly/3Cnno4z Cypress - https://bit.ly/3PpEukM Playwright - https://bit.ly/3iuPByJ WebdriverIO - https://bit.ly/3IJyofA XPath & Web Locators - https://bit.ly/3PpEvoQ ✅ API TESTING Web Services (API) - https://bit.ly/2MGafL7 SoapUI - https://bit.ly/2MGahmd Postman - https://bit.ly/2wz8LrW Postman 2022 - https://bit.ly/3JWm4qX Postman 2024 - https://bit.ly/3AE2wr6 Rest Assured - https://bit.ly/3zUdhRD Karate API Testing - https://bit.ly/3w3H5Ku General - https://bit.ly/2PYdwmV JMeter API Testing - https://bit.ly/3AgVPar Katalon Studio API Testing - https://bit.ly/2BwuCTN API Mocking - https://bit.ly/3bYPsjS ✅ MOBILE TESTING Appium - https://bit.ly/2ZHFSGX Appium 2 - https://bit.ly/3UJujNJ Mobile Playlist - https://bit.ly/2PxpeUv ✅ PERFORMANCE TESTING JMeter Beginner - https://bit.ly/2oBbtIU JMeter Intermediate - https://bit.ly/2oziNVB JMeter Advanced - https://bit.ly/2Q22Y6a JMeter Tips & Tricks - https://bit.ly/2NOfWD2 Gatling - https://bit.ly/3QrWfkV Performance Testing - https://bit.ly/2wEXbLS ✅ SOURCE CODE MANAGEMENT Git & GitHub - https://bit.ly/2Q1pagY GITLAB - http://bit.ly/2kQPGyQ ✅ IDE Eclipse - https://bit.ly/3AnRhQP IntelliJ IDEA - https://bit.ly/3AnyDZ8 Visual Studio Code - https://bit.ly/2V15yvt ✅ PROGRAMMING Java Beginners - https://bit.ly/2PVUcXs Java Tips & Tricks - https://bit.ly/2CdcDnJ Groovy - https://bit.ly/2FvWV5C JavaScript - http://bit.ly/2KJDZ8o TypeScript - https://bit.ly/3dvJBmz Python - http://bit.ly/2Z4iRye Ruby - https://bit.ly/3JRRmzf ✅ BUILD TOOLS Maven - https://bit.ly/2NJdDRS Gradle - http://bit.ly/30l3h1B ✅ CLOUD SERVICES Browserstack - https://bit.ly/3w7kxZn Saucelabs - https://bit.ly/3w7kAo1 LambdaTest - https://bit.ly/3C6TBwM ✅ PROJECT MANAGEMENT Jira - https://bit.ly/3AFzE1L ✅ DATA FORMATS JSON - https://bit.ly/3w450tq XML - https://bit.ly/3PqRneH ✅ OTHERS Virtualization on Windows - http://bit.ly/2SItIL9 Mock Interviews - https://bit.ly/3QGwwVJ Redis - https://bit.ly/2N9jyCG Misc - https://bit.ly/2Q2q5xQ Tools & Tips - https://bit.ly/2oBfwoR QnA Friday - https://bit.ly/2NgwGpw Sunday Special - https://bit.ly/2wB23BO 🙌 Connect with Raghav: * Ask Raghav: https://bit.ly/2CoJGWf * GitHub: https://github.com/Raghav-Pal * Udemy: https://www.udemy.com/user/raghav-pal-3/ Shorts Eng - https://bit.ly/3H9bifV Shorts Hindi - https://bit.ly/3XY7XqN ➡️ Subscribe for more videos: https://www.youtube.com/@RaghavPal —