READ PASSWORD PROTECTED EXCEL FILE WITHOUT OPENING EXCEL FILE

[#1]

Hi

Any one know how to  load  password protected excel file with out opening the password protected excel file .

Thanks in Advance.

[jonathandienst]

Search this site using 'password excel' as the search text. There are numerous articles on this topic.

[#3]

could you please explain and share the test file.

[vardhancse]

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-SqlState:S1000,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..

Pasted from <https://community.qlik.com/thread/46567>

[#5]

Hai Sasi

Thank you for your solution. But i cant able to open that excel every time . Any other alternate solution is there Instead of opening that excel every time .

[marcus_sommer]

What do you mean with you can't open the excel every time? How often do you want to read the data, how often changed the data, how many people write (at the same time ?) in this file? A bit more background to the topic will be helpful.

- Marcus