Question: how to import excel file in talend?
Answer: Double-click the tFileInputExcel component to open its Basic settings view.
In the File name/Stream field, browse to or enter the path to the Excel file that contains the Account ID data to be inserted. ... 
Select the All sheets check box to retrieve the data of the entire Excel file.