Need help in reading the all columns dynamically from xls files

[#1]

The requirement is like this.

1. Team has set of excel files stored at a particular location from where Qlikview can able to read the files.

2. Each excel file has multiple worksheets

3. Each worksheet has set of test cases as categorized.

4. These Test cases may vary in count or change in test case name.

5. QlikView will have read from only one categorized testcases.

Test cases will have values in the columns. A new column is created for values tested on that day.

Do let me for more information.

Thanks & Regards

Srinivas Reddy

[biester]

Hi,

part of this can be done as described here:

http://community.qlik.com/wikis/qlikview-wiki/loading-data-from-multiple-xls-files-from-folder-with-...

Have a look at it.

Rgds,
Joachim