topic How to load data from SharePoint. in QlikView

How to load data from SharePoint.

jsingh71 — Fri, 04 Jul 2014 10:19:15 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/*.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.