Read and Process password protected excel file

[vidya821]

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

[Anonymous]

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

[vidya821]

Thanks Xdshi,

will check the same 🙂

[Anonymous · Accepted solution]

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

[Anonymous]

---

@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/