4 Replies Latest reply: Jan 7, 2014 12:39 AM by Jonathan Dienst RSS

    Loading multiple Excel files from SharePoint

    Mallikarjun G

      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