Thanks a lot for the video. Very useful.. I have a question. If we have multiple test cases in single robot file, how can we call the test data with respect to each test case from excel or csv?
Hi Pavan, do u probably know, if is it possible the DataDriver Library in Robot Framework to have more than 1 sheet_names?. I have 1 xlsx file, but i separate the input for different screen into 2 sheets within the same excel file. Do u have any idea how to retrieved data from 2 different sheet within 1 excel file? Or can use other Library? Thanks in advance.
Hi, how to read the excel file using single robotfile itself ,here u used loginresouce.robot as a login and DDT2 file used to call the loginresouce using RESOURCE key word instead of that how to used in single robot file itself
hi Sir, is it possible to make one video to call the keywords and test data from excel and update the results(Pass/Fail) the same in Excel as part of the DDT Testing in Robot Framework.
Can we run the specific data from Excel? Means I have multiple rows in Excel each row represent as different test case and I have similar column names in Excel so how can we differenciate the rows??
@@sdetpavan Sure, I'll do it defiantly. And you are doing great work for those peoples who have less knowledge in coding. Kindly keep it up. And if possible kindly put vedio of appium with selenium 🙏🙏🙏
im getting [ ERROR ] Calling method '_start_suite' of listener 'DataDriver' failed: BadZipFile: File is not a zip file when following these steps. Am I missing something?
hye sir, I cant print the statement after ' using ' keyword in this line. But the test working fine: LoginTestWithCSV using ${username} and ${password} Btw, im getting warning said : "Undefined keyword" options Is there any settings i need to apply? Can u help me here TQ.
For variable ${username} not found.. the syntax should be "TestCaseName[space]using[space]{username}[space]and [space]${password}" e.g : LoginTestWithExcel using ${username} and ${password}
Hello guys I’m implementing a data driven framework using excel file but I’m gettin error ‘variable ${username} not found. I did add data driver package and ran pip install robotframework-excellib . I did proper spacing. Can one someone please help ? Spending whole day but still couldn’t make this work
Hi Sir, I have installed Robotframework, using Python2.7 on a linux machine. I have try to re-execute the failed test cases using this command 'robot --prerunmodifier DataDriver.rerunfailed:output.xml --output rerun.xml'. I am getting the following error, Importing model modifier 'DataDriver.rerunfailed' failed: Module 'DataDriver' does not contain 'rerunfailed'.
Hi please help me ! i'm just a beginner i'm just finished cours "python selenium" i did my first script "enter my information in web site" but i use send.key for one person so i want to use this script for a multplie data more than person with doc.txt !! just give me how i can do that(use Pandas or Robot Framework or ......) and i will find it
Hello Sir Calling method '_start_suite' of listener 'DataDriver' failed: ImportError: Requirements (pandas, numpy) for XLS support are not installed. can you please help
@@riadhabid605 I am getting issues installing pandas V 0.25.1 error: Microsoft Visual C++ 14.0 is required. Get it with "Microsoft Visual C++ Build Tools": visualstudio.microsoft.com/downloads/
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 Both this is working with me.
Hi, I am using eclipse and followed the same steps but I am getting error in test case section as "Test case 'loginwithexcel' contains no keywords to execute". Can you please help with this
After some RnD finally got the solution for Eclipse. Below is the syntax for Test cases tag for excel driven testing - *** Test Cases *** LoginTestWithExcel using ${username} and ${password} Default UserData
I am getting error : [ ERROR ] Calling method '_start_suite' of listener 'DataDriver' failed: XLRDError: Unsupported format, or corrupt file: Expected BOF record; found b'${userna' Along with Variable '${username}' not found.
For variable ${username} not found.. the syntax should be "TestCaseName[space]using[space]{username}[space]and [space]${password}" e.g : LoginTestWithExcel using ${username} and ${password}
@@kajaltumma9302 Could be issue with "robotframework-datadriver" , for xls and xlsx file support try installing --> "pip install --upgrade robotframework-datadriver[XLS]"
@@mohamednaveedh1160 No issue with data driver, pip install --upgrade robotframework-datadriver[XLS]... getting the same issue --> Test case contains no keywords. Thanks for reply
"[ ERROR ] Calling method '_start_suite' of listener 'DataDriver' failed: ValueError: Unknown engine: openpyxl" getting this error nowhere to find how to resolve this
For variable ${username} not found.. the syntax should be "TestCaseName[space]using[space]{username}[space]and [space]${password}" e.g : LoginTestWithExcel using ${username} and ${password}
"Calling method 'start_suite' of listener 'ExcelDataDriver' failed: FileNotFoundError: "can any1 help with this error , my excel script is failing due to it
Hi Pranav, Just right side of the project, you'd see your project's file location. Go to that location and open the directory where you want this xlsx file. In this tutorial the directory name is TestData. Now, open the Pycharm and click the TestData directory and you'd see the XLSX file in PyCharm. Let me know if it's successful? Thanks!
Hi am geetting this error,[ WARN ] Multiple tests with name ' LoginTestWithExcel using ${username} and ${password}' executed in suite 'DDTcsv'. LoginTestWithExcel using ${username} and ${password} | FAIL | Variable '${username}' not found.
Thanks a lot really helpful lectures
Most welcome!
Thanks for your videos on ROBOT FRAMEWORK, i reallyAppreciate your work, keep up the same.
How do place the excel file in python? Like how to put that logindata file under Testdata? Please Reply
Thank you
Very useful I was looking for this from some many days
Very well explained .. It helps me alot !!
Just one query .. how to prioritize test cases ? Like - we always do in TestNG or Junit.
Where did you get the TestData file from please help me
Thanks a lot for the video. Very useful.. I have a question. If we have multiple test cases in single robot file, how can we call the test data with respect to each test case from excel or csv?
Same question i have. No one is explaining that real scenario :(
This is quite impressive. And I have a question though, how can you run this having a test case -t as a parameter?
Hi Pavan, do u probably know, if is it possible the DataDriver Library in Robot Framework to have more than 1 sheet_names?. I have 1 xlsx file, but i separate the input for different screen into 2 sheets within the same excel file. Do u have any idea how to retrieved data from 2 different sheet within 1 excel file? Or can use other Library?
Thanks in advance.
did you receive an answer?
Thanks Pavan. Lots of useful information.
Can we use the data in different worksheets in the same excel within the same test case / script
you can do that by the way change the sheet_name as below:
*** Settings ***
Library DataDriver file=my_data_source.xlsx sheet_name=2nd Sheet
Hi Sir,
after using datadriver, do we able to use tagging as well?
filtering test case with tag
thanks
Hi,
how to read the excel file using single robotfile itself ,here u used loginresouce.robot as a login and DDT2 file used to call the loginresouce using RESOURCE key word instead of that how to used in single robot file itself
this is interesting!!! I hope you have a tutorial on how to web scraping using robot framework.
hi Sir, is it possible to make one video to call the keywords and test data from excel and update the results(Pass/Fail) the same in Excel as part of the DDT Testing in Robot Framework.
Hello Sir your tutorial is really helpful. Can you please upload a video about windows application automation using the Robot framework in Pycharm
How can we save dropdown element data into CSV/excel and call it in our testcase?
Can we run the specific data from Excel?
Means I have multiple rows in Excel each row represent as different test case and I have similar column names in Excel so how can we differenciate the rows??
Hi sir, could you please explain how to run testes with different keyword using data driven with excel
Can i call multiple sheets from one single xlsx?
You are doing great work man 👍
Thank you. Please share my videos to your friends and colleagues.
@@sdetpavan Sure, I'll do it defiantly. And you are doing great work for those peoples who have less knowledge in coding. Kindly keep it up.
And if possible kindly put vedio of appium with selenium 🙏🙏🙏
@@sdetpavan done
Hi Mr Pavan Maher
how we use datadriver on VS Code..??
Thanks 😁
Welcome
im getting [ ERROR ] Calling method '_start_suite' of listener 'DataDriver' failed: BadZipFile: File is not a zip file when following these steps. Am I missing something?
Same issue
hye sir, I cant print the statement after ' using ' keyword in this line. But the test working fine:
LoginTestWithCSV using ${username} and ${password}
Btw, im getting warning said : "Undefined keyword" options
Is there any settings i need to apply? Can u help me here TQ.
For variable ${username} not found.. the syntax should be "TestCaseName[space]using[space]{username}[space]and [space]${password}" e.g : LoginTestWithExcel using ${username} and ${password}
Now it ask pip install -U robotframework-datadriver[XLS]
it will install pandas and opeyxl
then Excel will support
Hello guys I’m implementing a data driven framework using excel file but I’m gettin error ‘variable ${username} not found. I did add data driver package and ran pip install robotframework-excellib . I did proper spacing. Can one someone please help ? Spending whole day but still couldn’t make this work
Hi Sir,
How to get excel sheet row count?
Thank you in advanced. :-)
Pls tell me Where can we find the scripts?
Hi Sir,
I have installed Robotframework, using Python2.7 on a linux machine. I have try to re-execute the failed test cases using this command 'robot --prerunmodifier DataDriver.rerunfailed:output.xml --output rerun.xml'. I am getting the following error,
Importing model modifier 'DataDriver.rerunfailed' failed: Module 'DataDriver' does not contain 'rerunfailed'.
If we want work with second sheet how to declare?
How to write data to excel file post running the script?
How to create .robot files from excel for each testcase?
How it is run a test case without having any keywords?
Hi please help me ! i'm just a beginner i'm just finished cours "python selenium" i did my first script "enter my information in web site" but i use send.key for one person
so i want to use this script for a multplie data more than person with doc.txt !! just give me how i can do that(use Pandas or Robot Framework or ......) and i will find it
Hello Sir
Calling method '_start_suite' of listener 'DataDriver' failed: ImportError: Requirements (pandas, numpy) for XLS support are not installed.
can you please help
Any solution for this issue @Ishang Baniya? Even i am also seeing the same
@@jaawahar Not yet.
I had the same problem, I uninstalled pandas and installed the version 0.25.1 and my issue is fixed :
pip uninstall pandas
pip install pandas==0.25.1
@@riadhabid605 I am getting issues installing pandas V 0.25.1
error: Microsoft Visual C++ 14.0 is required. Get it with "Microsoft Visual C++ Build Tools": visualstudio.microsoft.com/downloads/
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
Both this is working with me.
How to import these excel files in folder
Hi,
I am using eclipse and followed the same steps but I am getting error in test case section as "Test case 'loginwithexcel' contains no keywords to execute". Can you please help with this
pip install -U robotframework-datadriver[XLS]
After some RnD finally got the solution for Eclipse. Below is the syntax for Test cases tag for excel driven testing -
*** Test Cases ***
LoginTestWithExcel using ${username} and ${password} Default UserData
Could you please share me series of reboot frame work in your videos link sir?
Getting this error 'ModuleNotFoundError: No module named 'DataDriver '. Can anyone please help?
I am getting error :
[ ERROR ] Calling method '_start_suite' of listener 'DataDriver' failed: XLRDError: Unsupported format, or corrupt file: Expected BOF
record; found b'${userna'
Along with Variable '${username}' not found.
For variable ${username} not found.. the syntax should be "TestCaseName[space]using[space]{username}[space]and [space]${password}" e.g : LoginTestWithExcel using ${username} and ${password}
@@mohamednaveedh1160 issue soled but now it showing --> Test case contains no keywords.
@@kajaltumma9302 Could be issue with "robotframework-datadriver" , for xls and xlsx file support try installing --> "pip install --upgrade robotframework-datadriver[XLS]"
@@mohamednaveedh1160 No issue with data driver, pip install --upgrade robotframework-datadriver[XLS]... getting the same issue --> Test case contains no keywords.
Thanks for reply
@@kajaltumma9302 Hi did you resolve your error... I am also getting same error?
import this with 'pip install -U robotframework-datadriver[XLS]' if you are getting import error
thank you, it worked and I think it removes the one that is installed using python interpreter in this tutorial.
Doing Test Credentials for ${username} and ${password} | FAIL |
Variable '${username}' not found.
Any solution found ?
same problem :/
@@anasmamlouk hey, have you resolved that? I have the same
"[ ERROR ] Calling method '_start_suite' of listener 'DataDriver' failed: ValueError: Unknown engine: openpyxl" getting this error nowhere to find how to resolve this
pandas, openpyxl install these packages using pip and also install them in pycharm
Guys, I am getting error as Variable '${username}' not found. (Along with '_start_suite' of listener 'DataDriver' failed: ). Can anyone help here
Try this: Library DataDriver file=TestData/Mappe1.xlsx with "file:".
For variable ${username} not found.. the syntax should be "TestCaseName[space]using[space]{username}[space]and [space]${password}" e.g : LoginTestWithExcel using ${username} and ${password}
"Calling method 'start_suite' of listener 'ExcelDataDriver' failed: FileNotFoundError: "can any1 help with this error , my excel script is failing due to it
in video 0.43 check screen and install all libraries and try .
how to add xlsx file
Hi Pranav,
Just right side of the project, you'd see your project's file location.
Go to that location and open the directory where you want this xlsx file. In this tutorial the directory name is TestData.
Now, open the Pycharm and click the TestData directory and you'd see the XLSX file in PyCharm.
Let me know if it's successful? Thanks!
Hi am geetting this error,[ WARN ] Multiple tests with name ' LoginTestWithExcel using ${username} and ${password}' executed in suite 'DDTcsv'.
LoginTestWithExcel using ${username} and ${password} | FAIL |
Variable '${username}' not found.
Have you resolved that?
how to create excel login data file
and csv file