how to export query data to excel

[importantEmail]

hi..

i have a query whereby i am currently putting the results in a
datagrid.now the requirements have changed, and i need to have a
separate button on clicking to which, I can put all the data of the
query into an excel file.

this page is a part of the website which is running locally in my
company ...its an intranet website not on the web or internet.

the data is being fetched from the database.

can anyone help me on this?

thanks a lot

 

[sloan]

http://weblogs.asp.net/dneimke/archive/2004/01/27/63348.aspx

That should get you started.

 

[Guest]

Yes, I've detailed the steps necessary for exporting to Excel here:
http://SteveOrr.net/articles/excelexport.aspx

You may also find this free ExportPanel control to be useful:
http://SteveOrr.net/articles/ExportPanel.aspx