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

321 Views Asked by At

Instead of passing data from Examples: I want to pass the data from excel. as in that step I just want to compare expected and actual results for batch automation. I have 100s of test data to be tested for the same scenario. I could pass the test data from excel in Behave. But with PyTest BDD,I am not able to do it. I got the data from excel in a list. But in scenario, it is sending the whole list in first run itself. How can I iterate through the list and run the same scenario multiple times?

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      |
0

There are 0 best solutions below