topic Re: Load excel data placed in a public folder through a link in QlikView

Load excel data placed in a public folder through a link

gizzel123 — Mon, 06 Oct 2014 08:41:10 GMT

Hi All,

I have to load excel data , which are placed in a public folder , and a link to folder has been provided.

Please guide me how should i do that.

Thanks.

Re: Load excel data placed in a public folder through a link

anbu1984 — Mon, 06 Oct 2014 08:52:41 GMT

Edit Script --> Table Files --> Open Local files Dialog -- Here paste your Public folder path and select Excel file from it

Re: Load excel data placed in a public folder through a link

ashfaq_haseeb — Mon, 06 Oct 2014 09:05:55 GMT

Please use complete UNC path.

Regards

ASHFAQ

Re: Load excel data placed in a public folder through a link

gizzel123 — Mon, 06 Oct 2014 09:25:10 GMT

when I select the "XLS" format from File wizard window- it throws an error

" cannot read BIFF file"

Re: Load excel data placed in a public folder through a link

mjayachandran — Mon, 06 Oct 2014 09:31:34 GMT

Maybe its not really a BIFF file. It could be a csv file named as xls . Just try to open the file in Excel, Save it in a different name and try

Re: Load excel data placed in a public folder through a link

gizzel123 — Mon, 06 Oct 2014 09:40:47 GMT

yes...they are the excels . I have been working with them previously when they were in my D drive.

I also tried using XLSX format , its showing BAD ZIP FILE.

Re: Load excel data placed in a public folder through a link

ashfaq_haseeb — Mon, 06 Oct 2014 09:42:48 GMT

May be files are corrupted.

Try by copying the same file to local server to make sure they are not corrupted

Regards

ASHFAQ

Re: Load excel data placed in a public folder through a link

gizzel123 — Mon, 06 Oct 2014 12:25:41 GMT

I had been working with the files on local server, it was working fine then.

Re: Load excel data placed in a public folder through a link

mjayachandran — Mon, 06 Oct 2014 12:38:10 GMT

Hope you have seen this post

http://community.qlik.com/thread/125208

Cant really think as to why you might be getting the error.

Can you download a fresh copy of the file and try again ? and hope there are no restriction set on the files.

How are these excel files generated?

Re: Load excel data placed in a public folder through a link

gizzel123 — Fri, 10 Oct 2014 09:58:17 GMT

Thanks Guys for your support.

Got the solution.

Actually Qlikview needed the SSO login prior to llogin .

I entered the URL in File<open URL.

and tried to reload again.

It worked.

Thanks a lott!!

Re: Load excel data placed in a public folder through a link

gizzel123 — Fri, 10 Oct 2014 10:24:11 GMT

But again is there any way , we can do in script to open the URL for SSO login in QV.