Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

datanibbler
Esteemed Contributor

LOAD a protected Excel (file protected as a whole) - pass password?

Hi,

I need to load an Excel_file from a department which is protected with a password.

I know that if the password_protection, instead of being applied to the file as a whole, is applied to individual sheets, then QlikView can still read the data.

<=> Unfortunately in that dpt., that is not an option.

=> Do I have another possibility, that of passing the password to the QlikView_LOAD?

Thanks a lot!

Best regards,

DataNibbler

Tags (2)
3 Replies
MVP
MVP

Re: LOAD a protected Excel (file protected as a whole) - pass password?

Did you try with ODBC connection like suggested here: load a Password protected Excel File to QlikView ?

datanibbler
Esteemed Contributor

Re: LOAD a protected Excel (file protected as a whole) - pass password?

Hi tresesco,

I'm not sure how that translation happened - the text looks a lot like one made by Google_translator ;-)

I will try.

Thanks!

Re: LOAD a protected Excel (file protected as a whole) - pass password?

Maybe this is an alternatively:

Re: Load excel files from web

- Marcus

Community Browser