Just finished this video with practice. Naveen, Can you suggest how to handle dropDown list by reading ExcelSheet. Eg : In Registration page I have given Country = India.So how I can read ? May need to store those value in K,V format then later on performing Iteration or some other approach can you suggest? then later we can use Select Class.
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.
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
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.
As per this video, I am not able to open workbook after uploaded file in to the project Traceback (most recent call last): File "S:\PycharmProjects\pythonProject\temp.py", line 10, in workbook = xlrd.open_workbook("Excel_Worksheet.xls") ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^ File "S:\PycharmProjects\pythonProject\venv\Lib\site-packages\xlrd\__init__.py", line 166, in open_workbook file_format = inspect_format(filename, file_contents) ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^ File "S:\PycharmProjects\pythonProject\venv\Lib\site-packages\xlrd\__init__.py", line 60, in inspect_format with open(path, "rb") as f: ^^^^^^^^^^^^^^^^ FileNotFoundError: [Errno 2] No such file or directory: 'Excel_Worksheet.xls'
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.
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)
hello sir, i found this video very helpful. but i have a question, if anyone can answer: i have a file, it just has 1 row and with suppose 10 entries. now i want to paste each cell one by one on a website's textbox then press enter then grab the result from there and paste is adjacent to the copied cell. if anyone can help me. thanks a lot in advance
How is xlrd reading .xlsx file???..I am getting an exception.... Xlrd only uses .xls extension.... Using openpyxl to read .xlsx file....Any way we can use xlsx using xlrd
I was waiting from last 4-5 days.... more.... Finally just arrived..... Will see and practice tomorrow
Just finished this video with practice.
Naveen, Can you suggest how to handle dropDown list by reading ExcelSheet.
Eg :
In Registration page I have given Country = India.So how I can read ?
May need to store those value in K,V format then later on performing Iteration or some other approach can you suggest?
then later we can use Select Class.
Hi Naveen, Latest version of XLRD no more supporting xlsx format.
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.
@
deepti mishra
Are sing pytest -bdd
Awesome video and want more videos like that
Hi Naveen,,Thank you soo much this was the exact thing I was looking for ....
Hi Naveen, expecting video on working with json...please consider.
Thanks in advance
Very helpful
Super useful please post a video like this with a real time examples 👍
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
Thank you so much sir
Hi Naveen, i can not see workbook that contains method sheet_by_name().
Any idea?
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.
We can use Pandas with less Line code for excel operations with dataframes
Sure we will explore that. Thanks for your suggestions.
Hi Naveen, The video is really good and understandable but Can u please add Some error validations and how to capture that error also.
Hi naveen , Can you please tell ,How to pass a empty values through excel in python DDT testing
Hi Naveen,
Just wanted to know the difference between openpyxl and xlrd used for excel files.
If you find it, please let me know also
As per this video, I am not able to open workbook after uploaded file in to the project
Traceback (most recent call last):
File "S:\PycharmProjects\pythonProject\temp.py", line 10, in
workbook = xlrd.open_workbook("Excel_Worksheet.xls")
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
File "S:\PycharmProjects\pythonProject\venv\Lib\site-packages\xlrd\__init__.py", line 166, in open_workbook
file_format = inspect_format(filename, file_contents)
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
File "S:\PycharmProjects\pythonProject\venv\Lib\site-packages\xlrd\__init__.py", line 60, in inspect_format
with open(path, "rb") as f:
^^^^^^^^^^^^^^^^
FileNotFoundError: [Errno 2] No such file or directory: 'Excel_Worksheet.xls'
hlw Naveen, why don't I find sheet.nrow? Is there any package I need to install?
worked. My mistake
Hi Naveen
Code file is blank for ReadExcel.py in Selenium-Python-TutorialsCode codebase.
Can you please check once
I am waiting for your POM python pytest-bdd video
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.
Hi Naveen..
How to read/write the online excel file
Thank you
I can not join the telegram group, could you reshare the LINK in reply. Thank you in advance :)
is there a similar chapter for csv ?
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)
hello sir, i found this video very helpful.
but i have a question, if anyone can answer:
i have a file, it just has 1 row and with suppose 10 entries.
now i want to paste each cell one by one on a website's textbox then press enter then grab the result from there and paste is adjacent to the copied cell.
if anyone can help me.
thanks a lot in advance
where do i find the the code for this?
can i get the whole code
How is xlrd reading .xlsx file???..I am getting an exception.... Xlrd only uses .xls extension....
Using openpyxl to read .xlsx file....Any way we can use xlsx using xlrd
pip install xlrd==1.2.0 this version you can install and try i think can read your xlsx file