topic Reading from Sharepoint Document Library in QlikView

Reading from Sharepoint Document Library

shannoypaul — Thu, 07 Aug 2014 09:54:49 GMT

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 — Thu, 07 Aug 2014 09:56:35 GMT

Hi,

Have a look at the post below

Regards,

Kaushik Solanki

shannoypaul — Thu, 07 Aug 2014 10:02:33 GMT

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 — Thu, 07 Aug 2014 10:04:14 GMT

Shannoy,

Please follow below steps:

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

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

Thanks,