REST Assured API testing Beginner Tutorial | Part 5 - How to read data from Excel

FREE Tutorials - https://automationstepbystep.com/
Hi, I am Raghav and today we will learn -
How to add excel maven libraries
How to create functions to read data from excel
How to read data from xlsx and xls workbooks

Step 1 : Add maven dependency for excel reading and writing
Step 2 : Create a folder and add excel file and create data in the file
Step 3 : Create a class and create functions to get row count
Step 4 : Create a function to get data from excel
Step 5 : Create a constructor to get excelPath and sheetName
Step 6 : Create a new class and call the excel functions


My Project - https://github.com/Raghav-Pal/REST-as...
Rest Assured QUIZ - https://forms.gle/G3CD2mCNokdJL8xU6

_______ ONLINE COURSES TO LEARN _______

Udemy Discounts - https://automationstepbystep.com/udem...
GitHub - https://github.com/Raghav-Pal/
Udemy - https://www.udemy.com/user/raghav-pal-3/
Training by Raghav at your venue - [email protected]
Training schedule - https://automationstepbystep.com/trai...

----------- UI TESTING -----------
Selenium Beginners - https://bit.ly/2MGRS8K
Selenium Java Framework from Scratch - https://bit.ly/2N9xvR6
Selenium Python - https://bit.ly/2oyMp5x
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
Protractor - http://bit.ly/2KtqVkU
TestProject - http://bit.ly/2DRNJYE

----------- API TESTING -----------
Web Services (API) - https://bit.ly/2MGafL7
SoapUI - https://bit.ly/2MGahmd
Postman - https://bit.ly/2wz8LrW
General - https://bit.ly/2PYdwmV
Katalon Studio API Testing - https://bit.ly/2BwuCTN

----------- MOBILE TESTING -----------
Appium - https://bit.ly/2ZHFSGX
Mobile Playlist - https://bit.ly/2PxpeUv

----------- CI | CD | DEVOPS -----------
Jenkins Beginner - https://bit.ly/2MIn8EC
Jenkins Tips & Trick - https://bit.ly/2LRt6xC
Docker - https://bit.ly/2MInnzx
Kubernetes - http://bit.ly/2MJIlMK

------------VIRTUALISATION------------
Virtualization on windows - http://bit.ly/2SItIL9
----------- VERSION CONTROL SYSTEM -----------
Git & GitHub - https://bit.ly/2Q1pagY
GitLab - http://bit.ly/2kQPGyQ

----------- 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
Performance Testing - https://bit.ly/2wEXbLS

----------- PROGRAMMING -----------
Java Beginners - https://bit.ly/2PVUcXs
Java Tips & Tricks - https://bit.ly/2CdcDnJ
GROOVY - https://bit.ly/2FvWV5C
JAVASCRIPT - http://bit.ly/2KJDZ8o
PYTHON - http://bit.ly/2Z4iRye

----------- IDE -----------
Visual Studio Code - https://bit.ly/2V15yvt

----------- BUILD TOOLS -----------
Maven - https://bit.ly/2NJdDRS
Gradle - http://bit.ly/30l3h1B

----------- OTHERS -----------
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

Ask Raghav - https://bit.ly/2CoJGWf
Interviews - https://bit.ly/2NIPPxk
All Playlists - https://bit.ly/2LSiezA

Keep Learning,
Raghav

---------- Connect with Raghav -----------
Website - https://automationstepbystep.com/
LifeCharger -
Udemy Courses - https://www.udemy.com/user/raghav-pal-3/
Facebook -   / automationstepbystep  
Twitter -   / automationsbs  
Youtube -    / automationstepbystep  

Like, Subscribe & Share
You can support my mission for education by sharing this knowledge and helping as many people as you can

If my work has helped you, consider helping https://animalaidunlimited.org/ or any animal welfare group near you.