Connecting to an Excel file in a SharePoint library

Anonymous — Fri, 17 Aug 2018 10:38:20 GMT

Hello,

We are trying to connect to one or more Excel files stored in a library on a SharePoint site. First is this I a web file as this has a URL or a direct Excel connection.

I note that that there is a connection to Excel, though this asks for a drive. I have mapped the SharePoint site to a drive, but I suspect some of the problems I mention below apply to both methods.

Connecting as a web file, is the URL the full URL including the file name itself, with Name field just to identify this subsequently in Qlik? Or do I separate the file name from the URL in the respective fields? Furthermore, do I include the SharePoint "forms" part of the URL?

I have experimented with both the Excel connection and the web file connection, and have had no success. Can anyone help please?

Thank you.

topic Connecting to an Excel file in a SharePoint library in Connectivity & Data Prep

Connecting to an Excel file in a SharePoint library