REST Assured API Testing - How to Read Data From Excel

Overview

Save Big on Coursera Plus. 7,000+ courses at $160 off. Limited Time Only!

Grab it

Learn how to read data from Excel files in REST Assured API testing through this beginner tutorial. Discover techniques for adding Excel Maven libraries, creating functions to read data, and working with both xlsx and xls workbooks. Follow step-by-step instructions to set up Maven dependencies, create and populate Excel files, implement functions for row counting and data retrieval, and utilize constructors for efficient file path and sheet name handling. Gain practical knowledge on accessing cell data, handling numeric values, and adapting to different Excel formats.

Syllabus

Introduction
Add maven dependencies
Create folder and add Excel file
Create class and create functions
Provide path of Excel file
Get project path
Get workbook and sheet
Get cell data
Get numeric data
Data format
Object data type
Constructor function
Static class variables
Hard coding
Changing Excel format