topic Re: How to read Excel files from Sharepoint in QlikView

How to read Excel files from Sharepoint

Fri, 16 Oct 2015 10:03:15 GMT

Hi All,

I am trying to load files put in sharepoint folder in Qlikview. But I am getting "Bad Zip File" error.

I had opened the folder in sharepoint using "Open with Explorer" option and copied the link of it and used it to load in Qlikview Table.

I tried removing the https from the link but then it throws "Network not found error".

I tried many options mentioned in this community. But still am failing.

Please provide a solution...

Re: How to read Excel files from Sharepoint

john_s_w_wood — Fri, 16 Oct 2015 11:30:21 GMT

I had a similar issue. Fine from Desktop but wouldnt work from AccessPoint. The solution was to look at something like QVSource who have a Sharepoint connector (OData).

Re: How to read Excel files from Sharepoint

john_s_w_wood — Fri, 16 Oct 2015 11:31:13 GMT

Actually this may have been more to do with sharepoint lists. May be worth a chat to QVSource though.

Re: How to read Excel files from Sharepoint

linusblomberg — Fri, 16 Oct 2015 12:04:26 GMT

I was trying to accomplish this at my old firm. unfortunately I no longer have the files (or sharepoint to test) but mybe I can be of help anyway.

There are several issues connected to this.

First you need to find the real URL to where the files are located. this differs on the version of SP. I got this working using my desktop version since me as a user was logged in to sharepoint. When you find out the URL just connect as any webfile.

Second and this is what I didn't manage to solve before I left. Sharepoint has some sort of authentication method which qlikview has support for (at least Sense). But it is tricky. I was told that this would be manageble using a manual reload button in the qlikview app. You need to be logged in on sharepoint on the server OS running as your own user. There is support this this as I said. Anyway I can barely remember. Basically this is a Sharepoint problem not a qlikview problem.

hope I could at least point you in the right direction