Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Not applicable

Loading Data from Password Protected Excel Documents

I'm trying to find a tidy way of loading Data from an Excel protected workbook. I've seen the solution in the link below but cannot get this to work?

load a Password protected Excel File to QlikView

Ive checked command line options and had a play with vba code, opening a documentand trying to save a temp unprotected version but

a) I cannot get it to work

b) want to avoid any vba as it causes difficulties for support?

I am using QV 11.2 SR4   and Excel 2013 on windows 8 (IE 10)

Any ideas?

Thank You?

Tags (2)
1 Solution

Accepted Solutions
datanibbler
Esteemed Contributor

Re: Loading Data from Password Protected Excel Documents

Hi,

if you can get the dpt. to go along with this, just

- unprotect the workbook as a whole

- protect the individual sheets instead

=> QlikView will then read the file without problems.

Best regards,

DataNibbler

6 Replies
datanibbler
Esteemed Contributor

Re: Loading Data from Password Protected Excel Documents

Hi,

if you can get the dpt. to go along with this, just

- unprotect the workbook as a whole

- protect the individual sheets instead

=> QlikView will then read the file without problems.

Best regards,

DataNibbler

Not applicable

Re: Loading Data from Password Protected Excel Documents

Thanks DataNibbler (Love the name!)

Will give this a spin and let you know.

Many Thanks

Not applicable

Re: Loading Data from Password Protected Excel Documents

DataNibbler - This works a treat.  Need to do this in conjunction with DataNibblers Answer. (Note there may be a security issue linking to a hidden workbook sheet from another workbook)

Here is what you do in Excel 2003: (variations also work for 2007,10,13)

  1. In your sheet of interest, go to Format->Sheet->Hide and hide your sheet.
  2. Go to Tools->Protection->Protect Workbook, make sure Structure is selected, and enter your password of choice.

Once this is done, the sheet is hidden and cannot be unhidden without the password. Make sense?

(Given Excel's backward compatibility, I'm sure you can do this in 2007)

datanibbler
Esteemed Contributor

Re: Loading Data from Password Protected Excel Documents

Hi John,

hiding a sheet was not an option in my instance (the dpt. needs the Excel file themselves), but it sure is a good option.

Thanks for sharing this one!

Maybe, if you have time, you could make this last post into a small document and upload that?

Best regards,

DataNibbler

Not applicable

Re: Loading Data from Password Protected Excel Documents

Hello DataNibbler

Not too sure what you would like? Let me have a bit more info and I will do it. Also is there anyway i can mark you as correct answer as opposed to helpful?

datanibbler
Esteemed Contributor

Re: Loading Data from Password Protected Excel Documents

Hi John,

I have done it already, don't bother ;-)

To mark my answer as correct, you have to unmark it first - and unmark your own answer ;-)

Best regards,

DataNibbler

Community Browser