Excel
The Excel connector is an object that is used to get data from Microsoft Excel (*.xls or *.xlsx) file.
NOTE. Data import from large Excel files may require more virtual memory use. To avoid it, save data from the Excel file to the CSV file and use the Text connector.
After adding the connector to the ETL task working area, set import options, edit connector output.
Import Options
The properties panel is used to specify a file with imported data and parameters that are used to determine a data range.
To display the properties panel
The following settings are available on the properties panel:
File Import Method. Select method for getting file:
Specified Path. The radio button is selected by default, and the file path box is active. After the path is entered, the file is imported, and one can continue set up using file structure. When executing ETL task, the file is also searched at the specified path.
Request File on Task Execution. Select this checkbox if it is required to select file on each ETL task execution. To execute primary setup of the data provider, click the
Add button in the Setup File box:
The local file selection dialog box opens. Working with the dialog box order depends on the browser in use. After the file is selected, it is saved to the folder with user operating system. The file will be used only during the current wok with the ETL task instance. After the task is closed, the file is deleted from the temporary folder.
When executing ETL task, the file selection dialog box opens. If structure of the selected file does not correspond to the file used during the setup, an exception is thrown.
Object Name. If required, change connector name.
Identifier. If required, change object identifier. Identifier should be unique with the ETL task. Usage of Latin letters, numbers and the "_" character is allowed. The identifier should start with a letter.
NOTE. If required, add a note to an object. The note can contain any information.
Data Sheet. Select the sheet, from which data is imported, in the Data Sheet drop-down list.
Import Options. To set up import, specify parameters:
Skip First N Rows. The default value is 0, that is, data is imported from the sheet beginning. If required, specify the number of rows to be skipped on import.
Header Row. The default value is 0, that is, it is assumed that there are no headers in the file. Header names will be generated automatically. To use the other row, set the appropriate row number, from which header names will be obtained.
All Data are of String Type. The radio button is deselected by default. To convert all data to string type and import data to string fields, select the radio button.
Detect Automatically by First Lines. The radio button is selected by default. A data type will be determined automatically by first 100 lines. If required, change the number of lines, by which a data type will be determined.
Decimal Separator. To detect real numbers, specify a decimal separator. The point is used by default.
Settings. The button is used to edit connector output.
To save the changes, click the Apply button.
To close the connector properties panel without saving, click the 
Close button.
Settings button.
Create button and select an object input. If the list of provider and consumer fields fully matches, all fields will be linked automatically. A link between fields can also be set up in the 
Actions button and select the Fill from Provider item.