Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
RutiTaumanRubin
Creator
Creator

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

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'

View solution in original post

2 Replies
balabhaskarqlik

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

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