passsword protected Excel

[_AnonymousUser]

can I connect to a password protected excel file?

[_AnonymousUser]

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?

[talendtester]

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

[Anonymous]

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.