Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Not applicable

Password protection Excel, qvd

Hi,

is there an option to load password protected excel files or can i set passwords to a qvd file?
Thanks in advance

Aloah

Tags (3)
6 Replies
martinpohl
Valued Contributor II

AW:Password protection Excel, qvd

Looking for different fees in this forum it looks like:

you can't do this.

No ideas why not, in my opinion this should be possible.

Regards

MVP
MVP

Password protection Excel, qvd

Hi there,

This can be achieved using an ODBC connection, see my post here:

http://community.qlik.com/forums/p/36844/166731.aspx

Regards,
Steve

prieper
Honored Contributor II

Password protection Excel, qvd

You may load one .qvd into a .qvw, which then can be protected by password. The table can be accessed via "binary load".
Actually not very elegant, but works

HTH
Peter

Not applicable

Password protection Excel, qvd

Here is some work around.. but the excel file needs to be opened in  MS Excel first during the below steps..

1. The excel file should be opened first in the system where QlikView is extracting that excel data (with supplying the password)

2. Create ODBC connection for the encrypted (password protected) excel file. Provide DSN Name ,Choose the Excel file and proper excel version (latest is version12)

3. In the QlikView script, choose "ODBC" and connect,choose the DSN you created in step2 and provide password and leave the userid blank.

4.Test the connection

5.Click OK

6.Click "select" and "tick" the "system Fields" check box. You should be able to see the sheets.

NOTE

Whenever there is data extraction needed from the protected excel into QlikView, you should open the protected excel file in excel first otherwise you will get error. "SQL##f-SqlStateSmiley Frustrated1000,ErrorCode:4294962281,ErrorMsg:[Microsoft]ODBC Excel Driver]External table is not in the expected format".

SO KEEP the Excel file Open !!!!??? in the QlikView Server (where the data extraction happens )

Seems the the EXCEL ODBC driver needs the excel file to be opened in MS Excel..

If any other better way, pls update..

Not applicable

Re: Password protection Excel, qvd

Here is some work around.. but the excel file needs to be opened in  MS Excel first during the below steps..

1. The excel file should be opened first in the system where QlikView is extracting that excel data (with supplying the password)

2. Create ODBC connection for the encrypted (password protected) excel file. Provide DSN Name ,Choose the Excel file and proper excel version (latest is version12)

3. In the QlikView script, choose "ODBC" and connect,choose the DSN you created in step2 and provide password and leave the userid blank.

4.Test the connection

5.Click OK

6.Click "select" and "tick" the "system Fields" check box. You should be able to see the sheets.

NOTE

Whenever there is data extraction needed from the protected excel into QlikView, you should open the protected excel file in excel first otherwise you will get error. "SQL##f-SqlStateSmiley Frustrated1000,ErrorCode:4294962281,ErrorMsg:[Microsoft]ODBC Excel Driver]External table is not in the expected format".

SO KEEP the Excel file Open !!!!??? in the QlikView Server (where the data extraction happens )

Seems the the EXCEL ODBC driver needs the excel file to be opened in MS Excel..

If any other better way, pls update..

shubham_kumar
Contributor III

Password protection Excel, qvd

Hi Silvia,

Thank you so much for the above Information. I tried but the unexpected error hitted be back. The pop-up error says External table is not in the expected format.Could you please explain.

Best,

Shubham

Community Browser