Robot Framework Tutorial #42 - How to do Data Driven Testing using Excel File

In this Robot Framework Tutorial we will understand How to do Data Driven Testing using Excel File using Data Driver library of Robot Framework.

Help me in spreading the knowledge, please hit LIKE, SHARE and SUBSCRIBE for latest tutorials. More tutorial playlists below:

❖ TRAININGS ON RCV ACADEMY PORTAL ❖

❖ FOLLOW US ON TWITTER ❖

❖ LIKE US ON FACEBOOK ❖

❖ OUR TUTORIAL WEBSITES ❖

❖ GET MY TRAININGS ON UDEMY ❖
#RobotFrameworkTutorial #RobotFramework #TestAutomation #SeleniumTutorial #SeleniumWebDriver #SoftwareTesting #RcvAcademy #SoftwareTestingMentor

[vishalggupta]

Hello Sir, I tried csv test data driven approach.

My test template works fine but my testcase is not able to read variableName present in testdata.csv file . What I'm doing wrong here?

[Divesh-divija]

Hi Sir, if I want to read from more than one sheet how can I do it ??? It is not accepting one more library datadriver #path and sheet 2

[sonampandey]

Hi Sir, Thank you so much for the tutorial

[ranieltupas]

Hi Sir, Thank you for this tutorial. I have finish all the videos of Robot Framework Tutorial #1-#42, is there any more videos that is part of this tutorial?

[sunithach]

Can we store The extracted data from Excel into dictionary? If so pls explain

[durgeshgautam]

Sir, how are u adding the xlsx sheet their sir can you please guide me

[shraddhanachare]

Can you please show common.robot file?

[kiruthikasundararajan]

Hi,
Thanks for your tutorial.

I would like to know if I can put the keyword "Invalid login Scenerarios" in the resources file.
I tried it, but I have this error:
[ ERROR ] Calling method '_start_suite' of listener 'DataDriver' failed: AttributeError: No "Test Template" keyword found for first test case.



Please let me know whether we can call the keywords from other Resource file.

[durgeshgautam]

How are u adding that excel sheet in left hand side under Testcases

[rashmis]

Hi Sir,
Great videos.
I am stuck at one point. Please help me
I want to split the text and write the date in the excel file.
But I am not getting split function. It is throwing error as undefined function.
Please tell.me if I have to add any other library? And also want to know how to write the result to excel file.
Thanks in advance.

[sunitapyati]

Hi Sir, If I want to execute only few dataset rows, keeping rest of the dataset as it is, how to handle it?

[rishavsingh]

How to send generated report to my client as report only runs on my localhost ?

[justinegarma]

Hi Sir,
I would like to know if there is a way that I can use all columns into a single argument. I'm trying to execute a whole end to end scenario and there are multiple keywords and more than 10 fields/columns

Thank you so much!

[vivekgarg]

Thank you for such a detailed explanation. I have tried this and i got an error and to resolve that i need to install few more packages i.e. pip install -U

[vigneshwaran]

Hi Manish,
Could you please share your knowledge on winapp driver with robotframework.. If you put some vdo for that.. It would be helpful for us a lot.

[alimcheik]

Hi Sir, can you make a video to encrypt the password in robot framework if you need to share your work with the team

[maximpobihun]

how to add documentation for such test cases?

[saifulfahmi]

Hi Sir, How To Write Excel File with Library Data Driven?

[dummys]

Hi Manish,
I am trying to access 2nd sheet from my xlsx sheet but it showing me this Error: "Calling method '_start_suite' of listener 'DataDriver' failed: XLRDError: No sheet named <'Sheet2'> ".
Where I have entered this line in my code "Library DataDriver ../Test_Data/TestData.xlsx sheet_name=Sheet2"
Can you please help me on this.
How to access the different sheet from same excel sheet(Xlsx)

[JoseABohorquezAguilar]

Hi, thanks for your tutorial.

I would like to know if I can put the keyword "Invalid login Scenerarios" in the resources file.
I tried it, but I have this error:
[ ERROR ] Calling method '_start_suite' of listener 'DataDriver' failed: AttributeError: No "Test Template" keyword found for first test case.

DevTools listening on
LoginTestWithExcel using ${username} and ${password} error_msg ${e... | FAIL |
Test case contains no keywords.

I did the same with the example of the "Robot Framework Tutorial #40 - How to do Data Driven Testing" and it worked.