How to load data from SharePoint?

[jsingh71]

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.

[jsingh71 · Accepted solution]

I got the solution so I am closing this.

[shane_spencer]

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.

[#4]

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

[#5]

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