I am designing a reporting web site using ASP.NET and need to be able to pass the data from an SQL Query to Microsoft Excel. I don't want Excel to look as if it is a seperate application, but to use it within the page and talk to it using ASP.NET.

I am pretty sure I have seen web sites put Excel into their pages (provided it is on the client machine).

So far I can't even find the correct library to use to reference Excel. Any help people can give would be fantastic.