topic Re: Load excel from sharepoint in QlikView

Load excel from sharepoint

Wed, 25 Nov 2020 16:16:04 GMT

Hi All,

I am trying to load a excel file which is stored in a share point site to my qlik dashboard. I have tried 'Web Files' and use the http link from file properties but get a blank file back.

Any help on how to do this is appreciated.

Thanks in advance

Neda

Re: Load excel from sharepoint

Anil_Babu_Samineni — Wed, 08 Mar 2017 16:43:43 GMT

Open that excel file from Sharepoint link then call directly that URL on web file. Then check whether data coming up or not or else you may share the header image for excel

Re: Load excel from sharepoint

Wed, 08 Mar 2017 17:19:33 GMT

I have tried this one as well and get nothing back:

Re: Load excel from sharepoint

Anil_Babu_Samineni — Thu, 09 Mar 2017 06:09:38 GMT

I meant to say you may check whether the Excel file is situated with open or Encrypt. If encrypt, You may contact to the Admin to enable the RWX process. Then only you will fetch. And try to share screen of URL which is Excel data

Re: Load excel from sharepoint

ramasaisaksoft — Thu, 09 Mar 2017 06:23:37 GMT

I faced the approximate issue fetching data from SharePoint list, May be the below attachment will help to you.

else

ask the SharePoint team save the excel sheet at some where (D:,E drive..etc)with the help of batch script reload every hour/Day as per your convenience and try to fetch the data from that location.

if you feel you got solution for your issue ,please close the thread by clicking "Correct Answer"