Load many xlsx from sharepoint "document library" to "Qlik Sense" !

[srini]

Hi There, 

Very good Day!

I have scenario that I need to load many xlsx files from SharePoint document library, I have tried creating webconnection and load the data... but it is not working. If anyone came across the same and know the work around for this, please help me, I need this in the Desktop version.

thanks and cheers!

[akhi9219]

Dear Srini,

It is possible just create data connection for location where all the files named ABC*.xlsx are placed.

Load *
FROM [lib://ABC*.xlsx]

Regards,
Akhilesh

[srini]

Hi Friend, I have tried the same way but it says 'Bad Zip File'. LOAD * FROM [lib://share/Jan 2019 - All Data.xlsx] (ooxml, embedded labels, table is Data); The web connection I have created is

Share=https://team.global.hsbc/sites/self-service/SSDReports