Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
shannoypaul
Contributor

Reading from Sharepoint Document Library

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!

Tags (1)
1 Solution

Accepted Solutions
amit_saini
Honored Contributor III

Re: Reading from Sharepoint Document Library

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

3 Replies

Re: Reading from Sharepoint Document Library

Hi,

Have a look at the post below

Need Help on qlikview integration with sharepoint

Regards,

Kaushik Solanki

shannoypaul
Contributor

Re: Reading from Sharepoint Document Library

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
Honored Contributor III

Re: Reading from Sharepoint Document Library

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

Community Browser