Data driven testing in Cucumber using Excel sheets

Question

We want to implement data driven testing in Cucumber using external files like excel sheets without using DataTable or Examples keyword provided by Cucumber.

here is my feature file

Feature : verify login page Scenario Outline: Data Driven with excel and data sets

When I am the Login Page Then I input username and passwords with excel row "<row_index>" dataset

Examples:
| row_index  |
| 1          |
| 2          |
| 3          |
| 4          |

in the above example we are reading data from excel based on the row index provided in file.

it is difficult to write those many records in the feature file as the data will be getting added dynamically (no of rows to test will be increasing) and we need to modify feature file each and every time.

is there any way to read the data from external files like excels so that we can keep test data separately from scenarios and do data driven testing.

Any guide or advise on it would be of great help

Thanks, anji

Not sure about mixing cucumber with large datasets. Still you should have a look at Apache POI to access excel from java. Use a before hook with the appropriate scenario tag as value to access excel files and store data in lists etc, then in the step code you will need to access the list. Should give you better performance. — Grasshopper
– Grasshopper, Commented Oct 10, 2017 at 7:49

diabolist · Accepted Answer · 2017-10-09 19:23:07Z

3

There is no point in using Cucumber if you are going to drive tests with Excel spreadsheets. Instead write a Unit test, then you will be writing code and be in a programming language so you can load spreadsheets into data structures and iterate through them to carry out your tests.

answered Oct 9, 2017 at 19:23

diabolist

4,1101 gold badge13 silver badges15 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Data driven testing in Cucumber using Excel sheets

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related