Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
I got the solution so I am closing this.
I got the solution so I am closing this.
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.
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
Hi, Could please share how did you solve your problem ?