Data-Driven Testing (via spreadsheet) with Selenium & TestNG

Offered By
Coursera Project Network
In this Guided Project, you will:

Understanding data-driven testing approach

Creating reusable and structured code/components

Writing utilities to read test data from Excel sheet

Writing utilities to derive test cases through test data

Clock2 hours
IntermediateIntermediate
CloudNo download needed
VideoSplit-screen video
Comment DotsEnglish
LaptopDesktop only

Selenium is one of the most famous UI test automation tool which works well with the TestNG testing framework. Data-Driven testing is test design and execution strategy where test data is external to your functional tests. One of the ways is to keep the test data in external files like Excel sheets. The library used to read data from the excel sheet is POI from Apache In this two hours guided project, through hands-on, practical experience, you will go through concepts writing reusable and structure code, writing utilities to read test data from an external source like Excel sheets, and derive test cases through these test data.

Skills you will develop

Data-Driven TestingSoftware TestingTestNGApache PoiSelenium

Learn step-by-step

In a video that plays in a split-screen with your work area, your instructor will walk you through these steps:

  1. Understanding Data-Driven testing approach and project walk-through

  2. Data-Driven testing via @DataProvider annotation

  3. Writing utility to work with Excel sheet

  4. Writing utility to read test data from Excel sheet

  5. Writing utility to pass test data from Excel sheet

How Guided Projects work

Your workspace is a cloud desktop right in your browser, no download required

In a split-screen video, your instructor guides you step-by-step

Frequently asked questions

Frequently Asked Questions

More questions? Visit the Learner Help Center.