ExcelBDD Guideline By Java Example_excelbdd guideline by java example,实现excel bdd的三部曲-CSDN博客

本文链接：https://blog.csdn.net/zhangmike/article/details/118197580

这篇博客介绍了一种使用ExcelBDD方法从Excel文件获取BDD测试数据的工具，强调了Excel在支持BDD方面的优势。内容包括简单的表格格式、带有角色列的格式、GUI原型以及Given-When-Then验收标准的添加。通过Java单元测试案例展示了如何使用这些格式进行测试。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

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:

ExcelFileName, required, which excel file is used.
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.
HeaderMatcher, filter the header row by this matcher, if matched, this set will be collected in.
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 format is characterized