How to Read Excel File in Selenium Webdriver Using Apache POI

This video will talk about How to read excel file in Selenium using Apache POI.
In Automation, we have to take data from an external source like excel file, CSV file, database etc. In this tutorial, we will discuss How to read excel file in Selenium using Apache POI.
We will use the same approach in data-driven framework.
Articles link- learn-automatio...
Please Share, Support and Subscribe and let’s spread the knowledge
UA-cam - / mukeshotwani
Facebook Group- / 256655817858291
Facebook -
/ seleniumwebdrivermukesh
Google + - plus.google.co...
Twitter- / mukeshotwani
Instagram- / mukeshotwani
Checkout my another blog
mynewsyourviews...
~-~~-~~~-~~-~
Please watch: "How To Create Maven build For Selenium Framework"
• How To Create Maven bu...
~-~~-~~~-~~-~

[@Sudheerkreddy]

HI mukesh,Finally i understood how we need to read data from excel -crystal clean,Appreciate for your work.

[@Hima9806]

Amazing amazing and amazing..........The best tutorial ever....Really thank u so much

[@Mukeshotwani]

Thank you so much Hima 🙏🙏

[@shubhamtiwari-ts6wk]

One of the best way of Teaching and it helps to understand the concepts of Apache POI.

[@Mukeshotwani]

Thanks Shubham :)

[@swatcatz02]

Thanks for the wonderful tutorial sessions Mukesh. Every concept is explained by you with such simplicity and clarity. Kudos!

[@lucyjose5752]

Thank you so much for the program. I was looking for a program to read excel for months.Finally i found it. thanks for the simple and step by step execution.

[@Mukeshotwani]

Thanks Lucy Cheers :) I am glad you liked it. Keep visiting and let me know if any help from my side.

[@nikhilA098]

Thank you Mukesh , for all these videos. this is really helpful for all self learners like me..

[@akshaypalande3248]

I like the way you taught this...easy and effective...Keep doing it.

[@Mukeshotwani]

Thank you so much Akshay

[@asisharavind655]

Excellent explanation. Very neat understating of excel usage. I must say Genius at his best. Thanks Mukesh!!!

[@deepaklac]

Excellent Mukesh.
I have managed to complete my work with ease.
Searched so many sites but nobody had explained the concepts as clear as you have done !!! Awesome :)

[@Mukeshotwani]

Hey Deepak thanks glad to know it helped you. Check other tutorials too :)

[@subhash5722]

Thank you very much Mukesh...
You have explained it very clear and understandable...
Now it is just a cup of tea for me....

[@Mukeshotwani]

+Subhash Glad to know you liked it. Check write excel and then move to data driven framework.

[@roshanbhandure6096]

Explained in very simple and understandable language, thank you sir

[@sibanibehera4427]

Thank u so much Mukesh..clearly Explained..i m new learner..after watchng ur all videos nw i gained more idea ..thank u so much

[@panilkumar5563]

Thanks Mukesh, I grab both selenium and java by watching your videos

[@monicagoyal8225]

Hello Mukeshji, I have been a non technical person.Laid off from some HR job followed by Covid.Now learning Selenium for career change and really your videos are helping me alot. Such a precise and detailed explanation!!.
I followed up your code for making reusable library following your code and I got the results also but I want to learn how to write these methods on my own. Kindly advise me which videos of yours I can refer.Thanks again.

[@Mukeshotwani]

Hi Monica, did you refer my framework videos? Hybrid Framework Series?

[@monicagoyal8225]

@@Mukeshotwani Thanks.I will check and refer now.

[@buildleadinnovate24]

sirjee boht bhadiya ....what a way to explain amazing!!!

[@PradeepKumar-dz8nt]

I really liked your video and it cleared my concept... Thanks and keep posting such Automation video..

[@hanmant_1232]

Thank you so much Mukesh for wonderful tutorial series. I am learning so many concepts from u

[@Mukeshotwani]

So nice of you Thanks Keep learning.

[@dineshbelsare]

excellent tutorial... i had lots of confusion in reading and writing Excel...This tutorial clears all my doubts... Thanks and keep the gr8 work u r doing for community... Thanks a lot

[@Mukeshotwani]

+Dinesh Belsare thanks Dinesh bhai

[@RanjitSingh-wp2sn]

Really helpful. I have been reading many websites but the way you explained is awesome and very easy :)

[@Mukeshotwani]

+Ranjeet Singh thanks Ranjeet good to hear that.
Keep visiting and share with your colleagues

[@sonusagartiwari]

nice video mukesh...u explained very good and easy to understand...thank you so much...

[@prakashvish3988]

One of the best tutorial I have ever learnt ❤️ thank you mukesh for this wonderful explanation 💥

[@Mukeshotwani]

Thank you so much 😀 Prakash ji

[@mahadalikhan8028]

Thank you mukesh for providing such a dedicated awesome training videos.

[@hrishikeshkashyap8485]

browsed many websites but i couldn't understand the logic. Thank you very much sir. It was really well explained from basic.

[@Mukeshotwani]

Great Hrishikesh good to read your comment. Keep learning.

[@st.michaelangloindianschoo5900]

Very nice video Mukesh.....I watched couple of video, the way how you explained is really good.

[@Mukeshotwani]

Thanks Satyandra :) Have a nice weekend.

[@nimmyranjeeth5267]

Well explained in a simple way .. Thank you so much Mukesh !

[@reazuddinahmed1080]

Simply outstanding!!! Hats off Guru!!!

[@Mukeshotwani]

Thank you so much Ahmed for such a nice comment. 😀☺

[@bikramdhimal9285]

Hi Mukesh it could read in mine eclipse as i followed your all step carefully. Can you suggest? I must salute you for your wonderful presentation. It is really worth to go through all your videos. Keep posting and keep doing justice for readers thr your tutorials. Hats off

[@Mukeshotwani]

Hey Bikram,
Thank you so much for such a nice comment..What issue you are getting while reading excel?
Please send code to [e-mail]

[@Sandarshantv]

its really very helpfull to me........thank u sooo much mukesh ji......................

[@Mukeshotwani]

+satish narayana Thanks Satish

[@chaithanyan3863]

Wow superb sir...u explained in a good manner,Any one can understatnd.

[@ArpithaGirish]

Hi Mukesh ,
Its is very easy to understand even the POI concepts.Thank You
Great Work !!!!!

[@Mukeshotwani]

+Arpitha G thanks Arpitha

[@udaybenake206]

Good job Mukesh..... i have cleared my many doubts from Your videos..

[@Mukeshotwani]

Glad it helped ":) Keep watching

[@niyatisoni8312]

Hi Mukesh,
Thanks for sharing such a informative video. It's really helpful.
Keep Sharing more........!

[@Mukeshotwani]

+Niyati Soni Thank you Niyati keep visiting :) Have a nice weekend

[@mayannkstester9437]

thank you mukesh for explaining in simple term.

[@Mukeshotwani]

So nice of you Thanks Mayank

[@shilpawadhwa8364]

keep up the good work..very easy to understand!!

[@madhupkumar5892]

Very helpful tutorial. So clearly explained. Thanks a lot for creating such helpful videos.

[@sahinparwin6398]

Thank you so much Mukesh... I learnt so many things from your video..

[@Mukeshotwani]

Thanks Sahin :) I am glad you liked it.

[@sujithag4252]

hi mukesh your videos really helps me in understanding the concepts in clear and easy way, thanks a lot

[@Mukeshotwani]

Welcome Sujitha :) long way to go

[@vive121]

Hi Mukesh, thanks for the tutorials. I have two scenarios which are very useful, if you can make tutorials
Scenario - 1 :
1) Consider LOGIN details are common and needs to be loaded / run everytime. So I will have this details under LOGIN.xlsx
2) Now whenever I run TC1.xlsx this will be called from inside the TC1.xlsx
Scenario - 2:
1) Have test cases placed in User Dir. Sequentially launch the xlsx.
2) Ex: When TC1.xlsx is completed it should load TC2.xlsx and so on.

[@Mukeshotwani]

Sure Vikrant I will try my best for this.

[@balakrishnayerasingu2987]

Hi Mukesh your explanation is just awsome...

[@89abdulhadi]

Neatly explained... Thank you for your work Mukesh :)

[@Mukeshotwani]

Thanks Abdul Glad you liked it. Keep visiting.

[@kiran10634]

Hi Mukesh,the complex topic you explained us in easiest way.Thanks a lot :)

[@Mukeshotwani]

Thank you Kiran for such a nice comment. Kindly explore more topics from here learn-automation.com/

[@kiran10634]

Mukesh im getting page not found error,when i try to access it.

[@shivaprasad8804]

Thank you so much for the clear explanation..Awesome Mukesh

[@Mukeshotwani]

Thanks and welcome Shiva

[@fredy1229]

Mukesh, thank you for clear and detail explanation.

[@Mukeshotwani]

Most welcome Fredy I am glad you liked all videos.

[@prashanthiskvl1885]

Easily Understandable. Thanks Mukesh

[@Mukeshotwani]

Hi Prashanthi,
Most welcome.. Keep visiting..

[@leviremmick]

You are the man! Been looking for this solution for days. Very well explained.

[@Mukeshotwani]

Thank you Levi 😊 let me know if you find any issues while implementing the same

[@maddyrao8996]

@@Mukeshotwani yea I have found... classnotfoundexception even though I close warning of memory resources leak ...let me know what to doo

[@koteswararaoyarra2215]

i understood easily. Thanks so much Mukesh........

[@gautam91]

Thanks Man, your video contains fine details... Keep it up !!!

[@Mukeshotwani]

+Milan Gautam Hey Milan thank you so much. Keep visting

[@NPRBEST]

Best explanation ever...… thank you sir for uploading such a good content.

[@Mukeshotwani]

Thanks Nayan bhai

[@saianupamachalamchala5665]

Great way of Explanation Mukesh ! Thankyou :)

[@nitingupta82]

Hi Mukesh, I found it quite interesting but it will not be reading multiple rows simultaneously. Like username1 password1 at the same time. Hope you have covered this scenario in further videos. Thank you!

[@videoboy11111]

Very useful video!! Simple, fast and clear!

[@Mukeshotwani]

Thanks Mate

[@nidhiwaliarao4479]

excellent video, you are very talented. keep sharing information!

[@Mukeshotwani]

Thanks Nidhi :) I am glad you liked it. Keep visiting.

[@RuchiSingh-jo7dc]

Thank you so much Mukesh finally I understood how to read data from Excel file.

[@reenataneaj2006]

Thanks Mukesh. This video has helped me. The reusable part is awesome.

[@Mukeshotwani]

Great Reena :) keep learning and let me know if any help.

[@vishr1652]

Thanks for the videos on real time aspects of Selenium.

[@mohammadrahman9361]

What a wonderful lecture? Many thanks.

[@Mukeshotwani]

You're most welcome! Thanks Rahman

[@kenjalgundecha5870]

Very Nice Video Mukesh!!! It really helps us to learn automation from scratch. and cleared the concepts. Thank you so Much -:)

[@narendrar9940]

Great Mukesh! It is very helpful. Thanks for sharing.

[@Mukeshotwani]

Thanks Narendra 😇

[@VinayKumar-jo4ch]

Thank you so much for sharing such a informative video. It's really helpful.

[@abhijitpatra5909]

Its actually nice. Good work.

[@Mukeshotwani]

Thanks ABhi

[@shreer2637]

Hi Mukesh
Ty nd ur tutorial is very much clear an its very helpful on data driven in reading excel file
but it explains only to read rows, how to read entire xl sheet i.e rows nd columns using testng

[@Mukeshotwani]

+shree R Hi Shree thank you. You can run for loop for rows and columns to get the complete data over sheet.

[@jyshaikh1]

Thanks Mukesh. It really helps. I am struck what should be the flow of videos to cover each topic one by one in sequence. Currently I am trying with upload date time.

[@kavyasri5324]

Excellent i loved data encapsulation and polymorphism it keeps code clean.

[@Mukeshotwani]

Thank you Kavya 🙏😊

[@mohitpm6281]

Great work Well explained 👍

[@mbabajan]

Thanks Mr.Mukesh I get solved my problem.

[@Mukeshotwani]

Cheers Babajan

[@baluzen]

I really like your teachings yar. Very good explanation

[@Mukeshotwani]

+Balaji Singh .Y Hey Bala thank you so much :) keep visiting.

[@RS-dr1kl]

It was nice & very simple to understand the base concept of Excel read file....
I tried a lot on various blogs & excel read videos but really dont work.... it is really helpfull to get understand from base..

[@Mukeshotwani]

Thanks a Ton Rakesh for nice feedback

[@abhisheknimbalkar8509]

Thank you for this detailed video series...Keep Posting :-) God Bless !

[@Mukeshotwani]

+Abhishek Nimbalkar thnx bro..

[@karthikj9095]

Very well explained and easy to understand

[@mash21pro]

Nice Video Mukesh!! Can you please make a video how to read excel data sequentially when no. of columns are atleast 5 or greater and store in hashmap or any collection so that we can use the data directly in driver class in page object model framework.

[@Mukeshotwani]

Sure Mahesh I will do that soon

[@arpitkumar7576]

Thankyou sir for video.

[@arpitkumar7576]

sir, please describe How to match to excel sheet data by selenium and where is data changed in a file show a under line which is change data.

[@sushmasingh2437]

mahesh thuma

[@eForty6]

very well explained, keep up the good job

[@Mukeshotwani]

Thank you Keep visiting :)

[@prajwalapattanshetti9363]

You teach really well!! i just wanted one more thing, i have created two classes in a same package, one for operations in the website (basic.java), one for fetching data from excel sheet(ReadExcel.java). How can i use variable from ReadExcel in basic?

[@Mukeshotwani]

Hey Prajwala, you can either use inheritance or you can access the variables from other classes using getter setter as well.

[@DiptiJoshi2415rjdj]

hi Mukesh much appreciated the way u explained please could u tell me if i am using intellj how I am gonna implement it.

[@Mukeshotwani]

Hi Deepti, Thanks for such a nice comment.
You can use any Editor like Eclipse, NetBeans or intellj it does not matter.Process will be same.

[@DiptiJoshi2415rjdj]

Mukesh otwani I haven't expected this quick reply again thanks alot and Mukesh I am new to automation and I got a project to work on is international payments where I need to validate different IBAN no please please help me I have created excel sheet with two coloum called country and iban now I want to take this to validate my iban feild using intelj selenium

[@Mukeshotwani]

Hi Deepti,
I have done the same thing in Eclipse and It is called Data Driven Framework.
Please watch to get clear understanding
ua-cam.com/video/_7XJenTvR34/v-deo.html
Is there any restriction to use IntelliJ.
You can use eclipse as well, Process will be same for any editor.

[@DiptiJoshi2415rjdj]

Thanks alot Mukesh I became your fan now u r so quick in your planned schedule u r answering first thanks ,,
Now my test manager told me to use intelj and I am not familiar with that and iban is my first task I don't know how to implement but I will watch you video is it for iban right ,do u take classes please tell I would like to join u☺️

[@amoldhamurde9798]

Hi Mukesh ,
your Doing Great.. please help me ..
1. How to perform Database Testing
2. How fetching value from database
3. How to verify Expected result and actual result
it's humble request to you

[@jsasir]

Thank you very much Mukesh. This video was very helpful to me and I tried separate program and read the data from excel.

[@Mukeshotwani]

+Asir Jasonraj Cheers Asir glad to know it worked for you.

[@Mukeshotwani]

+Asir Jasonraj Cheers Asir glad to know it worked for you.

[@vikrantsingh2804]

Nice explanation mukesh bhai...keep up the social work that you are doing for us especially software test engineers haha....jokes apart ..your explanation is very short , clear and pin point..keep up the good work. god bless bro :)

[@narendranbalasundaram4510]

Thanks a lot for the detailed info Mukesh :)

[@Mukeshotwani]

Thank you Narendra 🙏

[@jankikakadia]

you are awsome.. very well explained.

[@Mukeshotwani]

Thanks Janki :) Keep learning..

[@RajaSekhar-pl7pn]

HI Mukesh, it's really a nice video. Helping a lot for new beginners. can you please advise, on how can we enter the excel file location which is in MacOS ? Thank you in advance.

[@AthenaTolga]

Thank you for sharing your knowledge with us.

[@harshinikondapalli6873]

Good explanation... Thank u for the video and keep fighting! 😁

[@Mukeshotwani]

Thank you! 😃 Harshini

[@pareshnmahapatra]

very well explained brother.

[@Mukeshotwani]

Thanks and welcome Paresh bhai.

[@skycreations8318]

Really helpfull...excelent video...

[@Mukeshotwani]

Thanks Akash

[@kshipra4504]

Is it possible to work with online excel data sheet in my selenium framework? I don't have ms office in my system.

[@venubabukatari1903]

Hai mukesh sir very usefull in your videos thak you very much Sir

[@Mukeshotwani]

+venu babu katari ur most welcome Venu

[@alfamusic2052]

Hi bro, this is Benny
This is an amazing video. I just learnt it in perfectly. Very clear and concise video. Keep upload more videos bro..
Can you please provide a video of how to control a program using Excel?

[@Mukeshotwani]

Glad you liked it Beryl, you can map specific function with excel. This is called keyword driven framework where you will keep all keywords in excel like click, type and map these function accordingly.

[@alfamusic2052]

@@Mukeshotwani ok brother :)

[@ashwinik479]

Hi Mukesh... Your selenium videos really helped me to understand the selenium advance concept. Now am trying data driven approach. In Windows 10 am getting filenorfoundexception. In Windows 8 am getting proper output. How to resolve this. Please help me

[@amj7573]

How to put the excel data into a website? For example there is IP address of a system and a excel file in a location. SO if we give IP address then it should display excel data. By the way your video is really very helpful. Thank you very much.

[@aneeshahamed2490]

Thanks bro. It was very use full video

[@Mukeshotwani]

Thanks Aneesh bhai

[@Saba556]

Hi Mukesh,
Such an useful video i really like it thanks allot 😚😘

[@Mukeshotwani]

Thank you! Subi 🤗
I am glad it helped you.
Feel free to contact me for any issue

[@sloefloe]

I downloaded the latest poi 5.0 it contains an additional folder containing jars "auxiliary", I have added those as well, hope it works !

[@Mukeshotwani]

Thanks Mate.

[@stanu1159]

Tq so much u r teaching way is so good

[@Mukeshotwani]

Thank you so much Tanu :) Keep learning

[@stanu1159]

Thank u for reply if I have doubt can I ask u sir

[@Mukeshotwani]

Sure anytime you can also mail me if u wish [e-mail]

[@yogilondhe1]

very helpful...Looking frwd for hashmap with excel reading

[@dhvaniljariwala9293]

Thank you very much..! it's really useful.
Please provide further videos link to get ahead.

[@Mukeshotwani]

Hi Dhvanil, you can find more videos from below URL learn-automation.com/selenium-webdriver-tutorial-for-beginners/
learn-automation.com/advance-selenium-webdriver-tutorials/

[@dezidueyex]

Very long tutorial! LOL but it's so good. Thanks

[@Mukeshotwani]

Hahaha Dennis I will break this into 2 parts soon

[@hudakhaled8353]

Thanks for the video.
I don't understand what does fileInputStream class do? and what is the difference between fileInputStream class and XSSfWorkbook, you said that they both load the excel file?

[@Mukeshotwani]

Hi Huda, FileInputStream is meant for reading streams of raw bytes such as image data. XSSfWorkbook is for Apache POI which help you to read excel data.

[@sofianeaida7533]

thanks a lot Mukesh, hope you put a video on how to write in an excel file

[@MMB7410]

Hi Mukesh, Thanks to you ... honestly its really helpful for me :)

[@Mukeshotwani]

+mayuri biradar Hey Mayuri most welcome. Keep visiting and let me know if any help from my side.

[@deepika5137]

Mukesh can you help how we can read data from excel in Framework and this is really helpful

[@Mukeshotwani]

Hi Deepika,
Here is the basic framework link ua-cam.com/play/PL6flErFppaj0WwNOMFeXPVlNCDuJyPYFi.html
Part 2 of framework series will upload soon.

[@grvlal]

Thanks Mukesh for the nice video.

[@Mukeshotwani]

+Gaurav nagpal Thanks Gaurav Please let me know if any help from my side