How do I read an Excel sheet in Python Selenium? For example, I have one website which contains a name, number and email. I want to read data from Excel using "column name" and "row number".

Asked by Last Modified  

1 Answer

Learn Python

Follow 1
Answer

Please enter your answer

Mukul Pratap

Project Manager , Experienced in Testing , Programming languages like Python, Java , Selenium Automation framework , Carrer Guidance

There is no support in Selenium for Reading Excel sheet but you can use other modules like pandas to read/write data from excel sheet
Comments
Dislike Bookmark

Related Questions

Can anyone help me with the below programs: A) which returns orger summary as a list with 2- tuples. Each tuple consists of the order number and the product of the price per items and the quantity. OUTPUT: [ ('34587',163.8),('98762',284.0),('77226',98.85),('88112',74.97) ]. 10 INR should be increased in the product if the value of the order is smaller than 100.00 INR. OUTPUT: [ ('34587',163.8),('98762',284.0),(77226',108.85),('88112',84.97) ]
Can't solve because product price is a part of the tuple. Since LIST IS MUTABLE so we can change its elements. We can change the whole tuple because it is an element of the list. As WKT TUPLE IS IMMUTABLE so we can't change its elements.
Anurag
Should I learn a Python course online or offline? What are some good Python training classes?
Online with TechyBees Educon Pvt Ltd
Neha
0 0
8
Hi, can anyone tell me where I can learn more and be professionally guided on 1-1 basis , on Machine Learning and Deep learning using Python? I already have statistics and programming background
I would first recommend taking some good Linear Algebra course, you would need some intuitive understanding about concepts like linear leas squares, singular value decomposition, normal equations,etc....
Ravi
0 0
5
Which is better, PHP or Python? Why?
Python . Simple syntax,More readable,General purpose programming language
Kartheek
0 0
5

Main problem statement : import a .xlsx file in python with a dataset value then after import we need to ensure that every time I enter a value in a row ; row must be added by 1 and automatically value changes to a row using python script without manually intervention . 
Use read_csv in a loop, there's no other way for this.
Joshua Charles
0 0
5

Now ask question in any of the 1000+ Categories, and get Answers from Tutors and Trainers on UrbanPro.com

Ask a Question

Related Lessons

Writing Simple Programs in Python
Writing a program, especially for a beginner, is a challenging and daunting task! He/She knows the language but is not able to start. To make things simple, it is advisable to follow a process that is...

Ashish K Sharma

0 0
0
A Python Program to calculate Variance and Standard Deviation
Finding the variance and the standard deviation. Variance and Standard Deviation are related measures of dispersion that tell us more about a list of numbers,like are they...

Ashish K Sharma

0 0
0
Python- Basic Concepts part 1
1. What is Python? Python is a high-level programming language, with applications in numerous areas, including web programming, scripting, scientific computing, and artificial intelligence. It is...

Divya S.

1 0
0
Python Introduction
Python is an object-oriented programming language created by Rossum in 1989. It is ideally designed for rapid prototyping of complex applications. It has interfaces to many OS system calls and libraries...
I

Imran

0 0
0
5 Reason to learn Python
Dynamically Typed You don’t have to declare a type when declaring a variable. It skips headaches of type casting JAVA:- int x = 1; x = (int)...

Aatray Kumar Singh

0 0
0

Recommended Articles

Top 5 reasons why you should learn Python

Python is one of the most popular programming languages in the world. It is general-purpose, object oriented, high-level programming language used in a number of programming fields. Python is a great programming language to learn as it will introduce you to the world of programming. If you are from the technical background...

Read full article >

What is Applications Engineering all about?

Applications engineering is a hot trend in the current IT market.  An applications engineer is responsible for designing and application of technology products relating to various aspects of computing. To accomplish this, he/she has to work collaboratively with the company’s manufacturing, marketing, sales, and customer...

Read full article >

Why Should you Become an IT Consultant

Information technology consultancy or Information technology consulting is a specialized field in which one can set their focus on providing advisory services to business firms on finding ways to use innovations in information technology to further their business and meet the objectives of the business. Not only does...

Read full article >

Learn Hadoop and Big Data

Hadoop is a framework which has been developed for organizing and analysing big chunks of data for a business. Suppose you have a file larger than your system’s storage capacity and you can’t store it. Hadoop helps in storing bigger files than what could be stored on one particular server. You can therefore store very,...

Read full article >

Find Python Training classes near you
Python Training classes in Bangalore
Python Training classes in Hyderabad
Python Training classes in Chennai
Python Training classes in Delhi
Python Training classes in Pune
Python Training classes in Mumbai
Python Training classes in Noida
Python Training classes in Kolkata
Python Training classes in Gurgaon
Python Training classes in Ghaziabad
Online Python Training

Looking for Python Training classes?

Learn from the Best Tutors on UrbanPro

Are you a Tutor or Training Institute?

Join UrbanPro Today to find students near you