topic Re: XLSX : Protected Document in QlikView

XLSX : Protected Document

Anonymous — Mon, 06 Jan 2014 14:15:51 GMT

Hi,

I'm trying to load a data from an excel file, that have a password. I trid different tips to load the data, but the only way that works for the moment is if I load the data with ODBC when the Excel file is already open in Excel. If the excel file isn't open in Excel, I'have the following errors.

Did anyone know a way to load Excel file with password?

Thanks

Re: XLSX : Protected Document

mjm — Mon, 06 Jan 2014 14:18:09 GMT

Hello Lucas,

Does this problem happen with all other excel files, meaning files which do not have a password?

What is the contents of the file? Is it possible for you to upload a sample of the file for me to try with?

Thanks,

Mark

Re: XLSX : Protected Document

ashwanin — Mon, 06 Jan 2014 14:34:00 GMT

Try to link excel file from Relative path, does it work?

If not then please provide the sample of .xlsx file.

Re: XLSX : Protected Document

Anonymous — Mon, 06 Jan 2014 14:42:37 GMT

There's no problem with file that don't been protected by a password.
If the document is already open in local, the loading work corretly but we don't want to have to open this document before loading.
For the document, i'have to make some modification in the file before send it because it's a file that come from a client.
I will update it when i can.
Thanks for the answer