Load multiple sheets and excel files

[#1]

Hi all

Posted this question before but couldnt find a complete solution.

I have multiple excel sheets and workbooks. How do I loop them? Please see attached. Could do if it was one excel file but cannot with multiple excel files.

[#2 · Accepted solution]

Hi,

1) To loop on files

a) For each file in FileList('*.xlsx')

        Load .... FROM $(file) ....

Next

b) For each file in 'A.xlsx' 'B.xlsx'

same as previous

2) To loop on sheets

See the doc made by Jagan : http://community.qlik.com/docs/DOC-4452

or the following post:

http://qlikviewnotes.blogspot.fr/2008/09/loading-multiple-excel-sheets.html

Fabrice