The Definitive Guide to Data Quality
So far, it is impossible to extract data from a password protected excel file with tFileInputComponent in talend.
Here is a custom component tFileExcelWorkbookOpen written by talend community user and shared on talend exchange portal, which supports the password encryption in various manner.
Could you please take a look at it?
Feel free to let us know if it is OK with you.