Reading from Sharepoint Document Library

[shannoypaul]

Hello everybody,

I need to read an excel file from the SharePoint document library.

Please help me with the same, preferably with syntax.

Thanks in advance!

[kaushiknsolanki]

Hi,

Have a look at the post below

Need Help on qlikview integration with sharepoint

Regards,

Kaushik Solanki

[shannoypaul]

Thank You , Kaushik.

But the example specified by you is to read data from SharePoint List.

My requirement is to read an excel file uploaded in the document library.

Thanks!

[amit_saini · Accepted solution]

Shannoy,

Please follow below steps:

1. Go to Share point where your excel is available.
2. right click on Excel sheet --> go to properties  and copy Address .
3. Go to QlikView back end like below and  select Data from Files as Web File option .
4. Paste that Address inside Internet File box.

5. Rest will work the same as during uploading sheet from local system.

Thanks,

AS