Additional output fields tab

Microsoft Excel Input step Additional output fields tab

The Additional output fields tab contains the following options to specify additional information about the file to process:

Option	Description
Full filename field	Specify the field that contains the full file name plus the extension.
Sheetname field	Specify the field that contains the name of worksheet you want to use.
Sheet row nr field	Specify the field that contains the current sheet row number you want to use.
Row nr written field	Specify the field that contains the number of rows written.
Short filename field	Specify the field that contains the filename without path information but with an extension.
Extension field	Specify the field that contains the extension of the filename.
Path field	Specify the field that contains the path in operating system format.
Size field	Specify the field that contains the size of the data.
Is hidden field	Specify the field indicating if the file is hidden or not (Boolean).
Uri field	Specify the field that contains the URI.
Root uri field	Specify the field that contains only the root part of the URI.