Data transfer - "Microsoft Excel" data source
Here you will find the instructions for configuring a data transfer if you selected "Microsoft Excel" as the type of the data source in the first step when creating the connection.
Source - Microsoft Excel
Clicking on 
"Search" opens a dialog in which the source file can be selected. In both cases, the file must be stored in a directory released for the server. If the file contains date values, the time zone can also be modified here.
Excel spreadsheet settings
Page
Select the table here.
File contains headers
With this option, the first line is not imported but is used as the column title for the field assignment.
Ignore blank lines
Prevents blank lines from being imported.
Cell area
No range
Uses the entire table.
Range specified by coordinates
Enter the number of the first and last column and row, respectively.
Click "Next" to complete the configuration of the connection.
Email us