I want a report in Excel to be generated on the Fly through ASP.NET


One Dataset Contains 2 DataTable

first Datatable will have all employees name with few columns which will
have some integer value and for each value there will be colors e.g
1-red,2-blue..till 4. each colors will be represented by a color code

Second Datatable will have complete details of Employee -name , biodata,etc

From First DataTable I want to make first Worksheet each employee name will
acts as Hyperlink to respective Employee Detail Worksheet

From Second DataTable for each Row I have to write separate worksheet and
all it's information .


And I have to generate this Report on the Fly the no. of employee can go to
300 on an average and Max 500.

Thanks in Advance
Please reply to me in