tFileInputExcel
expressions and then sends the fields as defined in the schema to the next
component.
tFileInputExcel Standard properties
These properties are used to configure tFileInputExcel running in the Standard Job
framework.
The Standard
tFileInputExcel component belongs to the File family.
The component in this framework is available in all Talend
products.
Basic settings
Property type |
Either Built-in or Repository. |
 |
Built-in: No property data stored centrally. |
 |
Repository: Select the repository file where the properties are |
![]() |
Click this icon to open a connection wizard and For more information about setting up and |
Read |
Select this check box to read the .xlsx or |
File |
File
Stream: Data flow to be For further information about how to define and Warning: Use absolute path (instead of relative path) for
this field to avoid possible errors. |
Password |
Provide the password set for the Excel file in double This field is for Excel 2007 (and higher versions) files This component supports standard encryption and agile |
All |
Select this check box to process all sheets of |
Sheet list |
Click the plus button to add as many lines as
Sheet (name or
Use Regex: select this |
Header |
Enter the number of rows to be skipped in the beginning of file. Note that when dynamic schema is used, the first row of the input |
Footer |
Number of records to be skipped at the end of |
Limit |
Maximum number of lines to be processed. |
Affect each sheet(header&footer) |
Select this check box if you want to apply the
parameters set in the Header and Footer fields to all excel sheets to be processed. Note: This option is only available when you select Memory-consuming (User mode) from the
Generation mode drop-down list in the Advanced settings view. |
Die |
Select this check box to stop the execution of |
First column and Last column |
Define the range of the columns to be |
Schema and Edit |
A schema is a row description, it defines the This This Click Edit
|
 |
Built-in: The schema will be created and stored locally for |
 |
Repository: The schema already exists and is stored in the |
Advanced settings
Advanced separator |
Select this check box to change the used data |
Trim all columns |
Select this check box to remove the leading and trailing whitespaces from all |
Check column to trim |
This table is filled automatically with the schema being used. Select the check |
Convert date column to string |
Available when Read excel2007 file format (xlsx) is selected Select this check box to show the table
Column: all the columns Convert: select this check box to choose all the columns for
Date pattern: set the |
Encoding |
Select the encoding from the list or select |
Read real values for numbers |
Select this check box to read numbers in real |
Stop reading on encountering empty rows |
Select this check box to ignore the empty line |
Generation mode |
Available when Read excel2007 file format (xlsx) is selected
|
Don’t validate the cells |
Select this check box to in order not to |
Ignore the warning |
Select this check box to ignore all warnings |
tStatCatcher Statistics |
Select this check box to gather the Job |
Global Variables
Global Variables |
NB_LINE: the number of rows processed. This is an After
CURRENT_SHEET: the name of the sheet being processed.
ERROR_MESSAGE: the error message generated by the A Flow variable functions during the execution of a component while an After variable To fill up a field or expression with a variable, press Ctrl + For further information about variables, see |
Usage
Usage rule |
Use this component to read an Excel file and |
Limitation |
Due to license incompatibility, one or more JARs required to use |
Related scenarios
No scenario is available for the Standard version of this component yet.