Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

rutitr14
Contributor

Load xls file from SharePoint in Qliksense

Hello,

I want to load xls file directly from the sharepoint.

I tried to create new web file connection and put  the path of SP in the URL - but the QS didn't recognize the xls file.

Do you have any idea how to load the file?

Thank's!!

1 Solution

Accepted Solutions
balabhaskarqlik
Honored Contributor

Re: Load xls file from SharePoint in Qliksense

Can you try this, We have to turn our URL into a path.

Sample:

Original URL = http://wssemea.sample.com/ws/MTPlanManagement/QlikView Folders/GLOP/*.xls'

Path used = \\wssemea.sample.com\ws\MTPlanManagement\QlikView Folders\GLOP\*.xls'

2 Replies
balabhaskarqlik
Honored Contributor

Re: Load xls file from SharePoint in Qliksense

Can you try this, We have to turn our URL into a path.

Sample:

Original URL = http://wssemea.sample.com/ws/MTPlanManagement/QlikView Folders/GLOP/*.xls'

Path used = \\wssemea.sample.com\ws\MTPlanManagement\QlikView Folders\GLOP\*.xls'

whp
New Contributor

Re: Load xls file from SharePoint in Qliksense

If you launch the file from Sharepoint into Excel and examine the connection string information - you will see how it is connecting to its source data.

Here is a blog post I did some time ago (prior to joining Qlik) that may be useful.

Getting SharePoint data into QlikView | Walter Shpuntoff on QlikSense and QlikView

Note: even though that was written for QlikView, it will work equally well with Sense.

HTH

ws