Data-Driven Testing with Selenium Using Excel

This tutorial demonstrates how to implement data-driven testing in Selenium using Excel and CSV files. Learn to read data from spreadsheets, apply it to automated tests, and execute tests with multiple data sets while generating comprehensive reports. Follow a step-by-step process including adding Apache POI dependencies, creating test data files, building utility classes for data extraction, modifying test scripts, and running tests with different data sources. The video also covers alternative data provision methods through TestNG data providers and XML configuration files, providing a complete overview of data-driven testing approaches for Selenium automation frameworks.

Syllabus

00:00 *TOPICS*
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
40:55 How to get data from a data provider method
41:32 STEP 1 - Create a data provider method and annotate with @DataProvidername = "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