Cucumber : How to read examples from external excel file for Scenarios Outline

Question

My requirement is to read examples from external excel file rather than hard code it into feature file. I have more than 100 examples which is difficult to maintain in feature file. Can you please help me on this.

Here is my scenario -

Scenario Outline: Browser Test

    When I visit the URL <base>/<page>/<ordNumber>/<custName>
    Then the browser contains test <custNumber>

    Examples: 
     | base                         | page   | ordNumber | custName |
     | http://www.stackoverflow.com | orders | 123       | John     |
     | http://www.stackoverflow.com | orders | 456       | Mike     |
     | http://www.stackoverflow.com | orders | 789       | Tom      |

I want to create an excel file with examples data and load it during runtime

examples.xls

 | base                         | page   | ordNumber | custName |
 | http://www.stackoverflow.com | orders | 123       | John     |
 | http://www.stackoverflow.com | orders | 456       | Mike     |
 | http://www.stackoverflow.com | orders | 789       | Tom      |

Thanks.

score 3 · Answer 1 · answered Jan 04 '19 at 22:09

3

What you are looking for is supported using gherkin with QAF. QAF support different external data providers including json, xml, csv, excel and DB. It also supports multiple bdd syntax.

Using Gherkin or BDD2 with QAF below is the example:

Scenario Outline: Browser Test

    When I visit the URL <base>/<page>/<ordNumber>/<custName>
    Then the browser contains test <custNumber>

    Examples: {'datafile': 'resources/testdata/examples.xls'}

There are lots of other features as well for resource management, execution configuration, driver management and parallel execution.

answered Jan 04 '19 at 22:09

user861594

5,733
3
29
45

any idea if we can use similar to this in Testcafe framework (Selenium JavaScript) – Karthikeya Jul 10 '22 at 13:07
not in my knowledge. – user861594 Jul 11 '22 at 19:28

Loïc Le Doyen · Answer 2 · 2019-01-09T19:33:48.943

0

In this case, I would opt for generating the feature files based on a template and the use of a template engine (like Velocity).

For integration with Excel, you can use the POI library the read properly your *.xls file(s).

Then run the generated feature file(s) like you would with "hard-coded" ones.

Hope this helps !

edited Jan 09 '19 at 19:33

answered Nov 07 '18 at 17:01

Loïc Le Doyen

975
7
16

What if the cells contain special characters e.g. "newline", how to put that inside the feature file? – Hendy Irawan Dec 25 '18 at 04:54
1

You can replace actual characters by there extended version (like `\n` for *new line*), but for long multiline text blocs, cells are not the best fit, but **DocString** may be. – Loïc Le Doyen Dec 26 '18 at 10:34

Cucumber : How to read examples from external excel file for Scenarios Outline

2 Answers2

Linked