Loading data from Excel folders

[#1]

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 :

• At the end of February, it will only contain one folder JAN and anaother folder FEB
• At the end of June, il will contain different folders for JAN, FEB, MAR, APR, MAY and JUNE
• ...

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.

[hector]

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

[#3]

Check this blog entry by Mr. Rob Wunderlich:

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