topic Re: Load many xlsx from sharepoint "document library" to "Qlik Sense" ! in Connectivity & Data Prep

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

srini — Mon, 13 Dec 2021 17:29:55 GMT

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!

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

akhi9219 — Wed, 20 Feb 2019 11:19:08 GMT

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

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

srini — Fri, 22 Feb 2019 07:20:32 GMT

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