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

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

________ ONLINE COURSES TO LEARN ________

------------ UI TESTING ------------

------------ API TESTING ------------

------------ MOBILE TESTING ------------

------------ CI | CD | DEVOPS ------------

-------------VIRTUALISATION-------------
------------ VERSION CONTROL SYSTEM ------------

------------ PERFORMANCE TESTING ------------

------------ PROGRAMMING ------------

------------ IDE ------------

------------ BUILD TOOLS ------------

------------ OTHERS ------------

Keep Learning,
Raghav

----------- Connect with Raghav ------------

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

[shyamsunder]

Hi Raghav,
I have gone through all your 5 videos related to REST Assured API. I would say, it’s one best tutorial for learning Rest API from scratch level. I like the way you are explaining and giving some tips/ shortcuts during the session which would be useful a lot for freshers. I appreciate your videos and sharing your knowledge.

[abhisharma]

Thank you Raghav, this entire Rest Assured series is very useful and full of details to understand the basics for API automation. Thanks as lot and keep up the great work you are doing.

[Ronik]

Awesome tutorial Raghav. Your teaching skills is amazing. Easy to understand and also you covered tiny things 👍

[surajdate]

Thank a lot for making and sharing videos. Thank you Raghav!

[janziomek]

Thank you for providing this very usefull topic !!! I like your perfectionism and good teaching skills (talking what are you doing for instance saying "now I'm using ctrl+a to select all and then ctrl+i to make it look better" or something like this. I really appreciate it ! regards from Poland !

[AniketShinde]

It is very good to see that covering all the things including the basic commands and do it frequently in every session is phenomenal. Hatt's Off to your dedication and Humbleness, Thank U Raghav Sir🙂.

[luvdekabal]

Thanks alot Raghav. Your sessions are really excellent and i have been keep watching all the videos in rest assured and cucumber and it really helps me to recall my memories back.

[prashantarakeri]

Thanks a ton Raghav for coming up with Rest Assured Series, Very neatly composed & explained with ease !! It will be very helpful if you add about JSON parsing & OAuth for this series !! You are doing great job for the Testing Community, kudos to you Raghav !!

[thejaswinilokesh]

Best Tutorials I have ever watched. Very helpful. Thank you very much.

[ChandanDas-dnpj]

Nice video . Helped me a lot . you are doing a great job helping others with sharing your knowledge and experience.

[chandu]

Nice & cool presentation. Thanks Raghav

[raajijeeru]

Once again best session and explanation. Thanks you @Raghav

[ashwinikhanna]

Nice explanation!
I always like the way you explain complex things with simple easy steps.
XFFS is so easy and straight forward. HSSF has unnecessary steps and complications! :-)

[aruns]

Thanks Ragav, Nice Video.Please add more videos in data driven testing using Rest Assured with real time examples (Excel and DB).It would be more helpful

[maheshwarivachan]

eagerly waiting for the next videos of rest assured

[postakshrestha]

Thank you for your enormous works! Do you have a video to run the tests in suite with chained tests, pretty much like in Postman where you can grab the value from the response of a previous test and use that in the following test for update or delete?

[bharathlc]

Hi Raghav, Thank you so much for explaining it so neatly and effectively. I'm eagerly waiting for the next videos. When can we expect it ?

[I_Love_Youtube]

Hi Raghav, all sessions are excellent. Could you please make one video on how to pass response of one web service to input body for second service

[ayushdeepdwivedi]

Thanks a lot sir, it really gave me a solution to one of my high priority task in my project.

[laxmikanthluckylucky]

Hi Raghav,


Your tutorials are very clear and easy to understand. Can you please create some videos on the Rest-Assured framework level.


Thanks.