Generate Report in Excel from ASP Website using Database Data

[Fas]

Hi I'm a newbie - would like to know if there is a good off-the-shelf
component or library that will allow me to use my ASP Website to
generate an Excel report.

More specifically, I have a load of data in a database, someone comes
to my website, decides what type of data they wish to see, I can then
easily write SQL queries to extract the data I require. However, I now
wish to "nicely" present that data within an Excel spreadsheet for the
user to see - this is something I can do but it is painful formating
and presenting the data nicely in Excel; I know that I can write a set
of flexible libraries to handle most data forms and create an adequate
Excel report but this will be very timeconsuming.

What I would like to know is whether there is already something out
there that I can use?

Grateful for any help you can provide.

Rgds
Fas

[Rupi]

Read this article to generate excel reports using xml and dataset.

http://support.microsoft.com/kb/307021

[Amol Dhavare]