topic Re: passsword protected Excel in Talend Studio

passsword protected Excel

_AnonymousUser — Sat, 16 Nov 2024 13:52:14 GMT

can I connect to a password protected excel file?

Re: passsword protected Excel

Anonymous — Fri, 17 Jul 2009 04:31:23 GMT

Hello
No, it is impossible to extract data from a password protected excel file with tFileInputComponent now.
Best regards
shong

Re: passsword protected Excel

_AnonymousUser — Fri, 17 Jul 2009 14:24:52 GMT

that is a bummer.

Re: passsword protected Excel

_AnonymousUser — Mon, 29 Apr 2013 14:15:56 GMT

Has there been any change to this? I have a file thats password protected for editing but can be opened read-only but I can't seem to get Talend to read it...
Exception in component tFileInputExcel_1
java.io.FileNotFoundException: Site Metrics - Copy.xlsb (The system cannot find the file specified)
at java.io.FileInputStream.open(Native Method)
at java.io.FileInputStream.<init>(FileInputStream.java:120)
at java.io.FileInputStream.<init>(FileInputStream.java:79)
at ciu.md_readecomdata_0_1.MD_ReadEcomData.tFileInputExcel_1Process(MD_ReadEcomData.java:720)
at ciu.md_readecomdata_0_1.MD_ReadEcomData.tFileCopy_1Process(MD_ReadEcomData.java:365)
at ciu.md_readecomdata_0_1.MD_ReadEcomData.runJobInTOS(MD_ReadEcomData.java:1286)
at ciu.md_readecomdata_0_1.MD_ReadEcomData.main(MD_ReadEcomData.java:1154)

cheers
Talend Enterprise DI 5.2.2

Re: passsword protected Excel

Anonymous — Mon, 29 Apr 2013 17:12:53 GMT

We don't handle passwords in the Excel components, so it's still impossible to read a file protected which can only be accessed with a password but I would say it should be possible to read the data using tFileInputExcel if you can open the file and read the data in read-only.
Could you try to copy and paste a sample of the content you can read into a non-protected excel file and see if this time the job works?
Check the path you entered to browse to the file as the error seems to say it is unable to find the file (not to open it or read it).
Feel free to email our support (support@talend.com) for a more specific help.

Re: passsword protected Excel

Anonymous — Mon, 29 Apr 2013 22:53:26 GMT

Hi, I have found, the Apache POI library supports the password encryption in various manner.
I have added support for password protected files in the component tFileExcelWorkbookOpen (current version 3.1 in Talend Exchange).

Re: passsword protected Excel

Anonymous — Tue, 30 Apr 2013 11:50:43 GMT

Thanks esabot and jlolling - we have a consultant in tomorrow and will see what he thinks.
cheers
Malcolm.

Re: passsword protected Excel

_AnonymousUser — Tue, 25 Feb 2014 04:54:20 GMT

Of course you can connect password protected Excel file but firstly you can break its password which you lost. You can use Excel password recovery software to recover your lost Excel file password and after that you can easily access your Excel file.
Excel Password Recovery

Re: passsword protected Excel

Anonymous — Tue, 25 Feb 2014 07:22:24 GMT

The problem was not a lost password, the problem was the lack of this functionality in the current build-in components. Password support is available with the tFileExceWorkbookOpen compoenent.
I should probably consider to add the encryption feature.

Re: passsword protected Excel

Anonymous — Wed, 04 Nov 2015 11:21:54 GMT

I guess this is supported only for 2007 or later versions.

Re: passsword protected Excel

_AnonymousUser — Tue, 13 Dec 2016 14:56:18 GMT

The problem was not a lost password, the problem was the lack of this functionality in the current build-in components. Password support is available with the tFileExceWorkbookOpen compoenent.
I should probably consider to add the encryption feature.

Is this component still available?

Re: passsword protected Excel

talendtester — Tue, 13 Dec 2016 16:59:40 GMT

The problem was not a lost password, the problem was the lack of this functionality in the current build-in components. Password support is available with the tFileExceWorkbookOpen compoenent.
I should probably consider to add the encryption feature.

Is this component still available?
There was a typo, the name is: tFileExcelWorkbookOpen
Get it here: https://exchange.talend.com

Re: passsword protected Excel

Anonymous — Thu, 07 Mar 2019 02:52:26 GMT

The first thing to consider is unlocking Excel, isn't it? On Older Versions, you can solve the problem of unlocking password protected Excel by using File Extension, VBA Code, and VBA Project. Here are the steps for the VBA code:
1. Open the protected Excel > shortcut "Alt + F11" to open the VBA editor > right click on the Excel file > Insert > Module option in the Project-VBAProject pane.
2. Enter the following VBA code into the General window.

3. Click the Run button to run it > Pop up the password consisting of the letters A and B.