Excel and Asp.NET

J

Jyoti Prakash Deka

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 (e-mail address removed)
 
P

Paul Hasell

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).
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top