Excel File Reader Properties

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