Read Excel Sheet - Data Driven Approach in Selenium Python - Part 15

In this video, I have explained how to read excel sheet using python xlrd package and how to use data driven approach in Selenium - Python.

To install xlrd - excel reader package, use this command:
pip install xlrd

~~~Subscribe to this channel, and press bell icon to get some interesting videos on Selenium and Automation:

Follow me on my Facebook Page:

Let's join our Automation community for some amazing knowledge sharing and group discussion on Telegram:

Paid courses (Recorded) videos:

[deeptimishra]

Hi Naveen, I was eagerly wait for you to upload python selenium videos. Please upload POM and framework videos also, it would be of great help. Thanks for sharing your knowledge and helping many like me.

[ashuiet]

I was waiting from last 4-5 days.... more.... Finally just Will see and practice tomorrow

[Aditya_Valluru]

Hi Naveen, Latest version of XLRD no more supporting xlsx format.

[MDHOSSAIN-gjve]

Awesome video and want more videos like that

[panditnandlalpatherwali]

Hi Naveen, expecting video on working with json...please consider.
Thanks in advance

[arpi]

Hi Navin, Thank you so much for spreading the knowledge in so much detail with so much clarity... Respect !! I have one question about cloud testing when it comes to interview... Can you please elaborate in one video what should be the approach or what is cloud automation what tools to use and how to go for it I am clueless when it comes to cloud testing and i would like to know about it, If you have any of your paid course on cloud then i wanted to buy that course as well ... please guide

[sabataranum]

Hi Naveen, , Thank you soo much this was the exact thing I was looking for ....

[royalwinautomatedsoftware]

Hai sir, ur video super. I learn so much ur channel. I have one doubt I'm using excel data python. Excel sheet cells I have created formula. Excel read data python program only copy formula not value. Please help me I need excel rows read values only. Please advise sir.

[PraveenYadav-pblq]

Hi Naveen, The video is really good and understandable but Can u please add Some error validations and how to capture that error also.

[karthikrao]

Super useful please post a video like this with a real time examples 👍

[manikandanv]

Hi naveen, Can you please tell, How to pass a empty values through excel in python DDT testing

[aasthasharma]

Hi Naveen, i can not see workbook that contains method sheet_by_name().
Any idea?

[asmitakumari]

Hi Naveen,

Just wanted to know the difference between openpyxl and xlrd used for excel files.

[nileshgadekar]

Sir can we have videos on how to send email with body and attachment in selenium python please 🙏...that would be great coz this question is asked like in evry second interview.

[shaiksuleman]

We can use Pandas with less Line code for excel operations with dataframes

[ayyajjamadar]

I am waiting for your POM python pytest-bdd video

[rahatilashikinniloy]

hlw Naveen, why don't I find sheet.nrow? Is there any package I need to install?

[prasadbhagwat]

Hi Naveen

Code file is blank for ReadExcel.py in Selenium-Python-TutorialsCode codebase.
Can you please check once

[RahulPawarpwrahul]

Hi Naveen..
How to read/write the online excel file

[amolnawale]

Thanks Naveen. That was the much awaited video of the Selenium Python series. By the way, is there any way we can read data of a single column from the excel sheet that you have shown in the video. For e.g. some function like getData(sheetName, colName)