topic Re: How to load data from SharePoint? in QlikView

How to load data from SharePoint?

jsingh71 — Fri, 04 Jul 2014 10:21:32 GMT

Hello Everyone,

In my application I am pulling data from Sharepoint URL. There are 5 excel files available in this url.

All files having the different name but same structure means same tab name and column name.

When I am loading single excel file then data loaded sucessfully,

for example:

LOAD

Field1,

Field2

FROM

[https: // sharepoint. mydomain.com/ files /abc. xlsm]

(ooxml, no labels, table is [sheet_name];

This is working fine without any issue. but when I try to load all the excel file using below code:

LOAD

Field1,

Field2

FROM

[https: // sharepoint. mydomain.com / files / abc. xlsm]https://sharepoint.mydomain.com/files/*.xlsm

(ooxml, no labels, table is [sheet_name];

Then its showing error message "bad zip file", Can any one please share the solution to avoid this error.

Thanks in Advance.

Re: How to load data from SharePoint?

jsingh71 — Mon, 07 Jul 2014 07:36:58 GMT

I got the solution so I am closing this.

Re: How to load data from SharePoint?

shane_spencer — Mon, 07 Jul 2014 07:37:44 GMT

Do you by any chance work with soha1902 ? See this thread:

http://community.qlik.com/message/562097

Have you tried as a test putting the files on a normal share and uploading from there? This will tell you if the problem is with sharepoint.

Re: How to load data from SharePoint?

Wed, 18 Feb 2015 19:16:55 GMT

How are you doing? I was hoping you could share how you fixed the zip file error from the .xlsm file from sharepoint. I receive the zip file error when I have a filename entered with the xlsm extension. Your assistance is greatly appreciated.

Thanks

How to load data from SharePoint?

https://sharepoint.mydomain.com/files/*.xlsm

https://sharepoint.mydomain.com/files /abc.xlsm

Re: How to load data from SharePoint?

Fri, 22 Jan 2016 07:34:07 GMT

Hi, Could please share how did you solve your problem ?