Excel Upload

[#1]

Hello,

I have to load data from excel with a specific format. i need help. am attaching the sample excel and expected output below:

Expected Output:

SheetName	Dim2	Date	Data
AAA	ABC1	1/1/2013	100
AAA	ABC1	1/2/2013	200
AAA	ABC2	1/1/2013	300
AAA	ABC2	1/2/2013	400
AAA	ABC3	1/3/2013	500
AAA	ABC3	1/4/2013	600
BBB	BCD1		1
BBB	BCD1	..	2
BBB	BCD1		3
BBB	BCD2		4
...	...

.

Note: The number of sheets and number of columns are not fixed. so i would require a dynamic solution.

Any help is much appreciated.

Regards,

Amit

[#2]

Could anybody help?

[#3]

Hope, somebody can help.