Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I would like to load some folders from an Excel file.
In the Excel file, the folders are named JAN, FEB, ... OCT.
In fact the number of folders in my Excel file depends on the current date, for exemple :
I want to create a script that loads data from the Excel file whatever the number of folders in it , That's to say JAN and FEB if the Excel file contains only these 2 folders.
Could you help me ? Thanks.
Hi, I don't understand when you say "Excel Folder".... 1 folder = 1 sheet?? or there are folders with Excel files in them??
by the way, you can refer the sheets by position changing the load syntax with table is @1 instead of table is Sheet1$ (Sheet1 has the 1st position in the file)
So maybe you can construct a For/loop structure that converts JAN into 1, and then read the files and its sheets
Rgds
Check this blog entry by Mr. Rob Wunderlich:
http://qlikviewnotes.blogspot.com/2008/09/loading-multiple-excel-sheets.html