Hi,

If your data is in SQL Server, have you considered using Reporting Services?
This can export to Excel and PDF (plus others) and is FREE (if installed on
the SQL Server box itself or any box licensed for SQL Server).

"Jyoti Prakash Deka" wrote:



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