Hi, 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. Best regards Sabrina
Hi, 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. Best regards Sabrina
Hi Sabrina, I have tested tFileExcelWorkbookOpen component and look sok. My issue is that these components do not support excel binary (xlsb) file. Any idea?
Hi, We don't handle passwords in the Excel components, so it's still impossible to read a file protected which can only be accessed with a password. Can you open the file and read the data in read-only? If so, it should be possible to read the data using tFileInputExcel. Have you tried to try to copy and paste a sample of the content you can read into a non-protected excel file and see if the job works? Best regards Sabrina
