Excel Examples File Format¶
General Rules¶
We recommend that you take a look at this sample feature file and its related Excel file, which includes additional examples for the feature file, before studying rules in detail.
- Values (in particular non-string values) entered in cells are converted according to the general cell conversion rules.
- You can use Excel formulas in the Excel file. The plugin uses the result of the formula result to execute your tests.
- Empty Excel rows are ignored.
- Merged cells: Gherkin tables do not support merged cells, so merged cells are converted so that the first cell contains the value and the other cells are empty.
- The first row in the sheet is the examples header row, and must match to the header row specified in the feature file (same columns, same order).
Excel examples matching to the Gherkin scenario outline examples¶
| Excel | Gherkin |
|---|---|
| Workbook (Excel file) | Container for multiple example sets |
| Worksheet | Scenario Outline examples |
| Worksheet first row | Examples header. The header row in the feature file and the Excel file must match (same columns, same order). |
| Worksheet further rows | Examples table |