ExcelBDD Guideline By Java Example

01- Excel BDD Tool Specification By ExcelBDD Method

This tool is to get BDD test data from excel file, its requirent specification is below

The Essential of this approach is obtaining multiple sets of test data, so when combined with Excel's Sheet, the key parameters are:

1. ExcelFileName, required, which excel file is used.
2. SheetName,optional, which Sheet the requirement writer writes in,if not specified, 1st sheet is chosen. An Excel file supports multiple Sheets, so an Excel is sufficient to support a wide range, such as Epic, Release, or a module.
3. HeaderMatcher, filter the header row by this matcher, if matched, this set will be collected in.
4. HeaderUnmatcher, filter the header row by this matcher, if matched, this set will be excluded.

Once the header row and parameter name column are determined by 'Parameter Name' grid automaticlly, the data area is determined, such as the green area in the table above. The gray area of the table above is the story step description, which is the general requirements step.

ExcelBDD Java editin is released, below is maven importing code, current version is 0.3.2.

<dependency>
  <groupId>com.excelbdd</groupId>
  <artifactId>excelbdd-java</artifactId>
  <version>0.3.2</version>
</dependency>

There are some typical cases, as described below

02 - Simple Sheet Format

This for