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
112 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 by Sirajul
• 53,110 points
0 votes
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

Related Questions In Software Testing

+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
610 views
+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
229 views
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
104 views
0 votes
0 answers
0 votes
2 answers

What is Functional Testing in Software Testing?

Functional testing is software testing aimed to check ...READ MORE

answered Jan 6 in Software Testing by Robert
• 140 points
126 views
0 votes
0 answers

who creates blocks in JIRA product owner, client or tester

who creates blocks in JIRA product owner, ...READ MORE

Jul 3, 2019 in Software Testing by anonymous
65 views
0 votes
1 answer