Discussion Board for collaboration on QlikView Scripting.
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.
Go to Solution.
1) To loop on files
a) For each file in FileList('*.xlsx')
Load .... FROM $(file) ....
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: