Importing specific named tables from excel and then cross table

[#1]

Hi,

im going to start using weather data, and it comes in this format per month in the same file. Lets call it weather.xls.

Element	1	2	3	4	5	6	7	8	9	10	11	12	13	14	15	16	17	18	19	20	21	22	23	24	25	26	27	28	29	30
Normal TAM	12,4	12,5	12,6	12,7	12,8	12,8	12,9	13	13	13,1	13,1	13,2	13,3	13,3	13,4	13,4	13,4	13,5	13,5	13,6	13,6	13,6	13,7	13,7	13,7	13,8	13,8	13,8	13,9	13,9
TAM	13,4	16,9	20,4	18,7	18,1	19,3	14,4	14,6	12	12,2	13,5	14,7	15,7	17,6	19	17,6	16,6	14,5	12	12,3	14,5	16	16,5	15,6	14,8	15,3
RR	1,5	2	0	0	0	0	0	0	0	0	1	2,8	0	0	0	0	0,3	0,3	0	0	11,8	0,4	0	0,2	10,3	0,3	7,8

I've made named fields inside the excel file:

January2016

February2016

March2016

April2016

May2016

June2016

....

What i want to do:

1. Read only the tablenames in the list above.

2. Cross table the day of the month (1-30/31).

3. End result cross table: get a vertical list of normal TAM, TAM, RR with the corresponding day of the month. (1,2,3,4,5,6,7).

Element	Normal TAM	TAM	RR
1	12,4	13,4	1,5
2	12,5	16,9	2
3	12,6	20,4	0

4. Add for each filelist [lib://desktop/weather*.xls] including the specific table names and cross table function.

I've only done cross table with two rows before and i don't know how to use import a named list of table names from excel file.

Hope you can help me out on this one.

Thanks,

[vikasmahajan]

hope this helps you The Generic Load

Vikas