The name of the Excel worksheet in the file that should be read. If left blank, the first worksheet in the file will be read.
Tick to read row as columns.
The option of Excel data source in the stream that the Agent should be read.
Streaming - Get Excel file from Base64 binary string
File Path - Get Excel file from a file directory
Tick to upload an example Excel file to read property names from and use to fill in the Record Definition table; or enter the properties manually.
An example Excel file used to auto-populate the Record Definition's Field Names (applies if Use File Definition is ticked).
(Field Name, Field Type)
Define the field names and types to expect in the Excel files.
The number of rows from the top that the record headers will be found. For example, if the headers are located on row 3, this should be set to 2.
The number of columns from the left that the records' first property column will be found. For example, if the first property to read is located on column D, this should be set to 3.
The number of row will be read from the Excel file.