Seven Stars

Read and Process password protected excel file

Hi,

 

Is it possible to read and process password protected file via talend ?

I am using Open studio 6.4

*The password is available in another file.

 

Thanks

2 REPLIES
Moderator

Re: Read and Process password protected excel file

Hello,

Do you want to read xlsb file?

So far, it is impossible to extract data from a password protected excel file with tFileInputXXX component 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.

https://exchange.talend.com/#marketplaceproductoverview:marketplace=marketplace%252F1&p=marketplace%...
Could you please take a look at it?
Feel free to let us know if it is OK with you.

Best regards

Sabrina

--
Don't forget to give kudos when a reply is helpful and click Accept the solution when you think you're good with it.
Seven Stars

Re: Read and Process password protected excel file

Thanks Xdshi,

will check the same :-)