ASP.NET and Excel Report

[Guest]

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)

 

[Mr Newbie]

http://www.trainingon.net/Articles/ART0007.htm

 

[Guest]

Hi I can write Excel Object and create 5-6 worksheet but the problem is the
volume of data (300 worksheet )and using ASP.NET .

thanks

 

[Mr Newbie]

So why is that a problem ?, you should still be able to create the report
using those methods regardless of the number of sheets.

 

[Steve C. Orr [MVP, MCSD]]

Writing this code on your own likely wouldn't be feasible.

For this kind of advanced exporting capability I'd suggest one of these
products to help you out:
http://www.aspose.com/Products/Aspose.Excel/

http://officewriter.softartisans.com/officewriter-8.aspx