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".

2019 GARNER MAGIC QUADRANT FOR DATA INTEGRATION TOOL

Talend named a Leader.

Get your copy

OPEN STUDIO FOR DATA INTEGRATION

Kickstart your first data integration and ETL projects.

Download now

What’s New for Talend Summer ’19

Watch the recorded webinar!

Watch Now

Best Practices for Using Context Variables with Talend – Part 4

Pick up some tips and tricks with Context Variables

Blog

How Media Organizations Achieved Success with Data Integration

Learn how media organizations have achieved success with Data Integration

Read

Agile Data lakes & Analytics

Accelerate your data lake projects with an agile approach

Watch