load sharepoint excel into qlikview

[vijetas42]

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!

[PrashantSangle]

Is it working while running manually??

Regards,

[vijetas42]

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.

[PrashantSangle]

Is there active network connection on server?

Also try to run manually same file on server.

Regards,

[vijetas42]

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