Name |
Type |
Required |
Description |
---|---|---|---|
Id |
String |
No |
Step identification string. |
File Name |
String |
Yes |
Name of the input file. |
Sheet |
Integer |
No |
Number of the sheet in the file from which data will be read (numbering is zero-based, so the first sheet is numbered 0). Ignored if sheetName is specified. Default value: 0. |
Sheet Name |
String |
No |
Name of sheet in the file from which data will be read. Default value: the parameter sheet is used. |
Start Cell |
String |
Yes |
Specification of the first row and column of the input portion of the sheet. Use the traditional cell reference form [column letter][row number]. Default value: 'A1'. |
Columns |
List of Column Def |
Yes |
Contains definitions of the columns that will be read from the input file. |
Shadow Columns |
List of Shadow Column Def |
No |
Contains a set of columns that are not present in the input data, but should be created in the output (so that they are then available for further use as any other "real" column read from a file). |
Skip Empty Rows |
Boolean |
Yes |
Indicates whether rows which contain no data should be ignored. Default value: false (all rows including empty will be send to output). |
iWay Software |