How can I take data from a datagrid and display it in an Excel Spreadsheet?

[Walaza]

Hi, How does one take data from a datagrid and display it in an Excel spreadsheet? I have got data in a datagrid and would like to import it to a spreadsheet. Please help.

Mvelo Walaza Developer Telkom SA

[buchstaben]

what about this? http://www.codeproject.com/KB/webforms/DAtaGridExportToExcel.aspx[^]

[Walaza]

Hi, Thanks for the reply, but I am doing a Windows application. So how different is the code from this article to the one of a Windows application? Or is there an article that demonstrates how to import from a (Windows application) to an Excel spreadsheet?

Mvelo Walaza Developer Telkom SA

[buchstaben]

Walaza wrote:

So how different is the code from this article to the one of a Windows application

since the control is the same, the code shouldnt differ a lot. try out and ask again, if you get stuck.

[Walaza]

What do I replace the ff with: Response.Clear(); Response.AddHeader("content-disposition", "attachment;filename=FileName.txt"); etc because 'Response.' is not known in a Windows application.

Mvelo Walaza Developer Telkom SA