topic Loading data from Excel folders in QlikView

Loading data from Excel folders

Thu, 16 Dec 2010 17:53:41 GMT

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.

Loading data from Excel folders

hector — Thu, 16 Dec 2010 18:51:40 GMT

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

Loading data from Excel folders

Fri, 17 Dec 2010 00:49:29 GMT

Check this blog entry by Mr. Rob Wunderlich:

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