How to read data in Robot framework from excel file

+2 votes
I am using DataDriver library to read the data from excel but its showing the below error.

Calling method '_start_suite' of listener 'DataDriver' failed: ImportError: Requirements (pandas, numpy) for XLS support are not installed.
    Use 'pip install -U robotframework-datadriver[XLS]' to install XLS support.3

I have already installed the library..Please let me know how to do.
May 7, 2020 in Software Testing by anonymous
• 140 points

2 answers to this question.

0 votes

DataDriver is used/imported as Library but does not provide keywords which can be used in a test. DataDriver uses the Listener Interface Version 3 to manipulate the test cases and creates new test cases based on a Data-File that contains the data for Data-Driven Testing. These data file may be .csv , .xls or .xlsx files.

If you already have Python >= 3.6 with pip installed, you can simply run:

pip install --upgrade robotframework-datadriver

For more information on custom data driver refer to

answered May 7, 2020 by Sirajul
• 59,230 points
+1 vote
You can try run "py –m pip install -U robotframework-datadriver[XLS]"
Or go to Setting/Project Interpreter and install some library:

- Panda, Pandas, Numpy, xlrd

- robotframework datadriver

- robotframework exceldatadriver

Both this is working with me
answered May 19, 2020 by anonymous
Run : pip3 install Pandas and pip3 install xlrd , it work for me.

Thank you

Related Questions In Software Testing

+1 vote
1 answer

Data driven test through Ms Excel is not entering the values properly in to the app only 1 is entering

Hi, @Faha, Chromedriver version should be shown in ...READ MORE

answered Oct 28, 2020 in Software Testing by Gitika
• 65,910 points
+2 votes
1 answer

How to find Predicate String and IOS Class chain through Xpath in Appium IOS Platform. ? ...READ MORE

answered Dec 2, 2019 in Software Testing by anonymous
+4 votes
0 answers

How to scroll up and down in Protractor?

I have a scroll bar inside Window. ...READ MORE

Feb 3, 2020 in Software Testing by Ingridd
• 160 points
+1 vote
0 answers

Write Assert fail differences to Excel or text file, Selenium C#

I am using selenium  with C# I have ...READ MORE

Feb 27, 2020 in Software Testing by Etl
• 170 points
+2 votes
0 answers

Comparing data with the data in excel sheet using Selenium Webdriver

Hello, I have written a code for registration ...READ MORE

Apr 9, 2020 in Software Testing by Kunal
• 140 points
+1 vote
0 answers

How to Communicate OTP from email to intelliJ using cucumber

Hi, I want to communicate OTP from gmail ...READ MORE

Jun 10, 2020 in Software Testing by anonymous
• 130 points

edited Jun 10, 2020 by Gitika 707 views
+1 vote
1 answer

How can we connect Selenium to Existing browser in Ruby Programming language?

Check this out ...READ MORE

answered Aug 11, 2020 in Software Testing by Karan
• 19,610 points
+1 vote
1 answer

Selenium webdriver in java how to automate email verification ?

Hey @Manali, check this out Hope this ...READ MORE

answered Oct 19, 2020 in Software Testing by Karan
• 19,610 points

edited Jun 23, 2023 by Khan Sarfaraz 2,734 views
+1 vote
1 answer

How to do stress testing in Apache flink? Kindly suggest the tool which is used to do stress testing.

Hey, @Savitha, Loadrunner from HP is the widely used ...READ MORE

answered Dec 9, 2020 in Software Testing by Gitika
• 65,910 points

edited Jun 23, 2023 by Khan Sarfaraz 1,233 views
webinar_success Thank you for registering Join Edureka Meetup community for 100+ Free Webinars each month JOIN MEETUP GROUP