Groups | Blog | Home
all groups > asp.net > february 2006 >

asp.net : how to export query data to excel


importantEmail NO[at]SPAM gmail.com
2/14/2006 11:31:50 PM
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
Steve C. Orr
2/15/2006 11:08:29 AM
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

--
I hope this helps,
Steve C. Orr
MCSD, MVP
http://Steve.Orr.net



[quoted text, click to view]
sloan
2/15/2006 11:10:12 AM
http://weblogs.asp.net/dneimke/archive/2004/01/27/63348.aspx

That should get you started.





[quoted text, click to view]

AddThis Social Bookmark Button