How to read data in Robot framework from excel file.

+1 vote
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 6 in Software Testing by anonymous
• 130 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 by Sirajul
• 57,940 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 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

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
+3 votes
0 answers

How to scroll up and down in Protractor?

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

Feb 3 in Software Testing by Ingridd
• 150 points
0 votes
0 answers
+1 vote
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 in Software Testing by Kunal
• 130 points
0 votes
0 answers

How to Communicate OTP from email to intelliJ using cucumber

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

Jun 10 in Software Testing by anonymous
• 120 points

edited Jun 10 by Gitika 72 views
0 votes
1 answer

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

Check this out ...READ MORE

answered Aug 11 in Software Testing by Karan
• 16,250 points
0 votes
0 answers
0 votes
1 answer