Reading Excel data for testing not working

Robot Framework
1

I understand that Python 3.11.1 and Robotframework 6.0.2 version will not go with Datadriver library

I am using pandas for the same
i did a
pip install -U pandas
but I am not seeing the library recognized in the pycharm.

(AUTO) PS D:\AUTO> pip install -U  pandas      
Requirement already satisfied: pandas in c:\users\feast-1\.virtualenvs\auto\lib\site-packages (1.5.3)
Requirement already satisfied: python-dateutil>=2.8.1 in c:\users\feast-1\.virtualenvs\auto\lib\site-packages (from pandas) (2.8.2)
Requirement already satisfied: pytz>=2020.1 in c:\users\feast-1\.virtualenvs\auto\lib\site-packages (from pandas) (2022.7.1)
Requirement already satisfied: numpy>=1.21.0 in c:\users\feast-1\.virtualenvs\auto\lib\site-packages (from pandas) (1.24.2)
Requirement already satisfied: six>=1.5 in c:\users\feast-1\.virtualenvs\auto\lib\site-packages (from python-dateutil>=2.8.1->pandas) (1.16.0)
(AUTO) PS D:\AUTO> pip install pandas --user
Requirement already satisfied: pandas in c:\users\feast-1\.virtualenvs\auto\lib\site-packages (1.5.3)
Requirement already satisfied: python-dateutil>=2.8.1 in c:\users\feast-1\.virtualenvs\auto\lib\site-packages (from pandas) (2.8.2)
Requirement already satisfied: pytz>=2020.1 in c:\users\feast-1\.virtualenvs\auto\lib\site-packages (from pandas) (2022.7.1)
Requirement already satisfied: numpy>=1.21.0 in c:\users\feast-1\.virtualenvs\auto\lib\site-packages (from pandas) (1.24.2)
Requirement already satisfied: six>=1.5 in c:\users\feast-1\.virtualenvs\auto\lib\site-packages (from python-dateutil>=2.8.1->pandas) (1.16.0)
(AUTO) PS D:\AUTO> pip --version
pip 23.0 from C:\Users\FEAST-1\.virtualenvs\AUTO\Lib\site-packages\pip (python 3.11)
(AUTO) PS D:\AUTO>

what am i missing?

2

What error do you get, when you execute your test?

Please give more information.
Or is it just PyCharm not recognizing it?

3

*** settings ***
Library SeleniumLibrary
Library OperatingSystem
Library Pandas

*** Variables ***
${searchbox} xpath://input[@class=‘gLFyf’]
*** test cases ***
Read Excel Data
${data} = Read Excel MyExcelFile.xlsx Sheet1
Log ${data}

ERROR
[ ERROR ] Error in file ‘D:\AUTO\wsrfr\Testscripts\specs\test.robot’ on line 4: Importing library ‘Pandas’ failed: ModuleNotFoundError: No module named ‘Pandas’
Traceback (most recent call last):
None
PYTHONPATH:
C:\Users\FEAST-1\AppData\Local\Programs\Python\Python311\Scripts\robot.exe
C:\Users\FEAST-1\AppData\Local\Programs\Python\Python311\python311.zip
C:\Users\FEAST-1\AppData\Local\Programs\Python\Python311\Lib
C:\Users\FEAST-1\AppData\Local\Programs\Python\Python311\DLLs
C:\Users\FEAST-1\AppData\Roaming\Python\Python311\site-packages
C:\Users\FEAST-1\AppData\Local\Programs\Python\Python311
C:\Users\FEAST-1\AppData\Local\Programs\Python\Python311\Lib\site-packages

Test

Read Excel Data | FAIL |
No keyword with name ‘Read Excel’ found.

Test | FAIL |
1 test, 0 passed, 1 failed

Output: D:\AUTO\output.xml
Log: D:\AUTO\log.html
Report: D:\AUTO\report.html

4

Hi Bala,

That’s a python Module not a robotframework Library, so the error you got is not surprising.

i did a quick search and found robotframework-PandasLibrary, I’ve never used it, so you’ll have to refer to their example for how to use it.

It can be installed via pip (robotframework-pandaslibrary · PyPI)

Dave.