Loading Excel file from Sharepoint into Qlikview.

    I was able to load data from excel sheet which was in share point but was not able to do that in server.

    I try to find solution in community but i did not see anyone had a good documentation on how to do this. So here are some step that i did to read Data from SharePoint into Qlikview

     

     

    1 Add Qservice in Folder level in sharePoint ( Give read permission)

    2 Copy the URL from SharePoint file Property  and if the URL need authentication .pass your user name and password threw URL.

     

     

    for ex:

    Before

    [https://teamcentral.JOB.edu/Myreport.xlsx]




    After

    [https://yourUSerName:Yourpassword@teamcentral.JOB.edu/Myreport.xlsx]