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, 2020 in Software Testing by anonymous
• 130 points
3,311 views

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 http://www.lib4dev.in/info/Snooz82/robotframework-datadriver/166381769

answered May 7, 2020 by Sirajul
• 59,050 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

0 votes
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,870 points
168 views
+1 vote
1 answer

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

https://github.com/facebookarchive/WebDriverAgent/wiki/Class-Chain- ...READ MORE

answered Dec 2, 2019 in Software Testing by anonymous
1,755 views
+3 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
• 150 points
1,670 views
0 votes
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
• 160 points
384 views
+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, 2020 in Software Testing by Kunal
• 130 points
1,861 views
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, 2020 in Software Testing by anonymous
• 120 points

edited Jun 10, 2020 by Gitika 175 views
0 votes
1 answer

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

Check this out https://www.browserstack.com/docs/automate/sele ...READ MORE

answered Aug 11, 2020 in Software Testing by Karan
• 19,590 points
280 views
0 votes
1 answer

Selenium webdriver in java how to automate email verification ?

Hey @Manali, check this out https://blog.mailtrap.io/selenium-email-ve ...READ MORE

answered Oct 19, 2020 in Software Testing by Karan
• 19,590 points
373 views
0 votes
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,870 points
128 views