topic Re: Read and Process password protected excel file in Talend Studio

Read and Process password protected excel file

vidya821 — Tue, 23 Jan 2018 09:02:09 GMT

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

Re: Read and Process password protected excel file

Anonymous — Wed, 24 Jan 2018 02:51:16 GMT

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%252F1%252Fproducts%252F542&pi=marketplace%252F1%252Fproducts%252F542%252Fitems%252F2739
Could you please take a look at it?
Feel free to let us know if it is OK with you.

Best regards

Sabrina

Re: Read and Process password protected excel file

vidya821 — Thu, 25 Jan 2018 08:53:25 GMT

Thanks Xdshi,

will check the same 🙂

Re: Read and Process password protected excel file

Anonymous — Thu, 07 Mar 2019 03:25:30 GMT

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

Re: Read and Process password protected excel file

Anonymous — Mon, 02 Dec 2019 10:35:33 GMT

@lli wrote:

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

You can remove Excel password with zip compression software
1. Change the suffix of the excel file that has forgotten the password

2. Open with zip compression software, find "xl" → "worksheets"-"sheet1.xlm" in turn, copy "sheet1.xml" to the appropriate location and open it with Notepad, find "<sheetProtection password =" CF7A "sheet = "1" objects = "1" scenarios = "1" /> "

3. Put the modified "sheet1.xml" back in the compressed file to replace the original "sheet1.xml" and save it. Then change the file extension to the original extension and you're done.

source:

https://www.passcue.com/remove-password-protection-from-excel.html

https://yodalearning.com/tutorials/unprotect-excel/