topic Re: load sharepoint excel into qlikview in QlikView

load sharepoint excel into qlikview

vijetas42 — Wed, 06 Sep 2017 09:57:46 GMT

Hi All,

I have one excel file on sharepoint so load that into qlikview I have right clicked on file and choose sent to email a link and that link i have used in web files

from that I have created script like this,

LOAD * from

[http://ab.cde.int/sites/testdoc/access/testfile.xlsx](ooxml,embededed labels,table is test);

and ran that script through qmc task but it failed and shows error bad zip file and general script error.

Please give your suggestions

Thanks!

Re: load sharepoint excel into qlikview

PrashantSangle — Wed, 06 Sep 2017 11:23:23 GMT

Is it working while running manually??

Regards,

Re: load sharepoint excel into qlikview

vijetas42 — Wed, 06 Sep 2017 12:22:49 GMT

no, when I load it on my local machine then it's working but, when I tried to run it on server it's not running.

Re: load sharepoint excel into qlikview

PrashantSangle — Wed, 06 Sep 2017 12:29:32 GMT

Is there active network connection on server?

Also try to run manually same file on server.

Regards,

Re: load sharepoint excel into qlikview

vijetas42 — Wed, 06 Sep 2017 12:37:41 GMT

manually it wont work do i need to mention credentials in link?