Load xls file from SharePoint in Qliksense

[RutiTaumanRubin]

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!!

[balabhaskarqlik · Accepted solution]

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]

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