topic Re: Password Protected Excel (xlsx) in QlikView

Password Protected Excel (xlsx)

ciaran_mcgowan — Mon, 20 Mar 2017 23:02:07 GMT

Hi all,

Can anyone tell me if there is a way to connect to a password protected XLSX file?

I have the latest ODBC drivers (v12) installed on my machine, tried creating a connection in the both the User DNS and the System DNS tabs of my ODBC Data Source.

I'm able to read from a password protected xlsx but only if it's already open at the time of reading. Unfortunately, this isn't a practical approach as I need to read from 10+ encrypted XLSX files in one load and can't leave all them open. Has anyone cracked a workaround for this issue?

Thanks.

Re: Password Protected Excel (xlsx)

Anil_Babu_Samineni — Tue, 21 Mar 2017 02:43:49 GMT

I would high priority remove password from Excel if you have all admin permission

Or else look into this load a Password protected Excel File to QlikView

Re: Password Protected Excel (xlsx)

Anonymous — Tue, 06 Feb 2018 08:13:04 GMT

I would high priority remove password from Excel if you have all admin permission

Or else look into this recover a Password protected Excel File

if the password is any longer than 4 characters and more than just a dictionary word, good luck, I hope you have a patient attitude, because it can take weeks of brute force dictionary attacking, even utilising some dodgy software that can use a high end GPU for raw number crunching.

Re: Password Protected Excel (xlsx)

Anonymous — Tue, 06 Mar 2018 01:40:44 GMT

Anil Babu <span class="icon-status-icon icon-mvp" title="Mvp"></span> wrote:

I would high priority remove password from Excel if you have all admin permission

Or else look into this recover a Password protected Excel File

Absolutely agree! The encryption algorithm for Excel is not really strong and I also don't suggest apply a password to protect the worksheet.

Re: Password Protected Excel (xlsx)

SeanMoss — Thu, 07 Mar 2019 03:19:30 GMT

If you are using an older version, you can use VBA code. Manually deleting the encrypted password may be helpful in removing password from Excel.
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".