Read and Process password protected excel file

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


Accepted Solutions
Four Stars

Re: Read and Process password protected excel file

For Excel that wants to read password protection, the first thing you should do is to remove protection password from Excel. If you are using an older version, VBA code is a workable solution. In addition to this, there is an effective way to manually delete encrypted passwords:
Open Excel > click on File > Information and Permissions Options > click the "Encrypt with password" option and clear the password box > "OK" to delete the password > "Save".


All 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 :-)

Four Stars

Re: Read and Process password protected excel file

For Excel that wants to read password protection, the first thing you should do is to remove protection password from Excel. If you are using an older version, VBA code is a workable solution. In addition to this, there is an effective way to manually delete encrypted passwords:
Open Excel > click on File > Information and Permissions Options > click the "Encrypt with password" option and clear the password box > "OK" to delete the password > "Save".

What’s New for Talend Spring ’19

Join us live for a sneak peek!

Sign up now

Definitive Guide to Data Quality

Create systems and workflow to manage clean data ingestion and data transformation.

Download

Tutorial

Introduction to Talend Open Studio for Data Integration.

Watch

Downloads and Trials

Test drive Talend's enterprise products.

Downloads