Data Transfer - "Microsoft Excel" Data Source
Here you will find instructions for configuring a data transfer if you selected "Microsoft Excel" as the data source type in the first step of creating the connection.
Source - Microsoft Excel
Clicking "Search" on 
opens a dialog box where you can select the source file. The file must be located in a directory that has been shared with the server. You can also change the time zone here if the file contains date values.
Excel Spreadsheet Settings
Page
Select the table here.
File contains a header
In this case, the first row is not imported, but is used as a column header during field mapping.
Ignore blank lines
Suppresses the import of empty lines.
Cell area
Do not restrict the range
Uses the entire table.
Specify a cell range using coordinates
Enter the numbers of the first and last columns or rows here.
Click "Next" to complete the connection setup.