Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Not applicable

Load multiple sheets and excel files

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.

1 Solution

Accepted Solutions
Highlighted
Not applicable

Re: Load multiple sheets and excel files

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

View solution in original post

1 Reply
Highlighted
Not applicable

Re: Load multiple sheets and excel files

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

View solution in original post