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 - • How to read excel in Java
-
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/Seleniu...
Full Playlist - • Selenium Java 2025
▬▬▬▬▬▬▬
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: / @raghavpal
—
En esta página del sitio puede ver el video en línea Selenium How to do Data Driven Testing with Excel de Duración hora minuto segunda en buena calidad , que subió el usuario Automation Step by Step 18 marzo 2025, comparta el enlace con amigos y conocidos, en youtube este video ya ha sido visto 7,670 veces y le gustó 89 a los espectadores. Disfruta viendo!
