Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements
Coming your way, the Qlik Data Revolution Virtual Summit. October 27-29. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Not applicable

Loading multiple Excel files from SharePoint

Hi All,

I am trying to load multiple excel files from SharePoint using FileList but didn't get through could you please suggest how can i load all the excel files from sharepoint,or please suggest if any workaround for this.

Please find the below code which i am using to read the files

Ex:

for Each file in FileList('https:\\SharePointlink\*.xlsx');

LOAD

  FileName('$(file)') as DocName

FROM

[$(file)]

(ooxml, embedded labels, table is Raw);

NEXT file

Thanks & Regards

Mallikarjuna

6 Replies
Highlighted
Not applicable

what type of error you are getting?

Please check the user account have the read access on the share point site ?

Highlighted
Not applicable

Hi Dathu,

Thanks for the reply,

I didnt get any error and i have full access to Sharepoint but the above script fail load the files

Regards

Malli

Highlighted
Not applicable

Its look very wired. There is no data in thq qvw after reload ?

The work around is try to download all the files into Network drive or any folder and then initiate the reload from drive or folder.

Mean time I can test this use case from my share point site and let you know

Highlighted

Hi

As far as I know, the http and https protocols do not support file iteration using wildcard loads or FileList() loops. For loading data with ese protocols you will need to explicitly name the files.

Can you access these documents via a network shared drive instead? This is the only workaround I can suggest.

HTH

Jonathan

Logic will get you from a to b. Imagination will take you everywhere. - A Einstein
Highlighted
Creator II
Creator II

hi all,

 i have the same scenario- loading multiple files or most recent file from a folder in sharepoint...any one please

i followed the one mentioned by Jonathan but it is not working

Highlighted
Creator II
Creator II

hi all

anyone ..any help with the loading all .csv files from a sharepoint folder