Excel Plugin
The plugin provides the ability to work with Excel documents.
Installation
implementation(group: 'org.vividus', name: 'vividus-plugin-excel', version: '0.3.2-SNAPSHOT')
Table Transformers
FROM_EXCEL
FROM_EXCEL
transformer generates table from the given Excel file.
Parameter | Default | Description |
---|---|---|
|
the resulting column name in the generated table. If it’s missing in properties then the first row is used for the column headings. |
|
|
the relative path to the Excel file |
|
|
the sheet name from the excel file |
|
|
the range of cells from the specified excel sheet |
|
|
the comma-separated collection of the cell addresses from the specified excel sheet |
|
|
|
the increment used to traverse the specified |
|
|
defines whether cell values should be joined |
|
empty string |
value to substitute line breaks in cell values |
range and addresses are competing parameters and only one can be specified in the transformer declaration at the same time.
|
Examples: {transformer=FROM_EXCEL, path=/my-excel-file.xlsx, sheet=Data, range=A2:A7, lineBreakReplacement= , increment=2, column=test}
Examples: {transformer=FROM_EXCEL, path=/my-excel-file.xlsx, sheet=Data, addresses=A2;B4;A7, column=test, joinValues=true}
Examples: {transformer=FROM_EXCEL, path=/my-excel-file.xlsx, sheet=Data, range=A2:B4}
Steps
Create excel file with specified content
Create temporary excel file with specified content and save the path to the variable
When I create temporary excel file with content:$content and put path to $scopes variable `$variableName`
-
$content
- the data to be put to the excel file. Any valid ExamplesTable -
$variableName
- the variable name
When I create temporary excel file with content:
|key1 |key2 |
|value1|value2|
and put path to scenario variable `path`