export datagrid's data to Excel sheet (windows application)

[Walaza]

Hi,, I have a C#.net windows application with a datagridview.I need to export datagrid's data to Excel sheet. How to export from DatagridView to Excel Sheet in C# Windows Forms? Anybody has sample code in C#? Please Help!!!!!!

Mvelo Walaza Developer Telkom SA

[Giorgi Dalakishvili]

Google not working for you? a simple search with your post's title points to many useful resources.

Giorgi Dalakishvili #region signature my articles #endregion

[Not Active]

You don't export the DtaGridView, you export the data that is used to construct the Grid. A simple, though not 1005 reliable, method would be to write the data to an xml (DataSet.WriteXml)file and change the extension to xls, or transform the xml. http://www.codeproject.com/KB/office/Excel_Export.aspx[^] Otherwise, you will need to create a Workbook instance and add the columns and rows to it.

---

only two letters away from being an asset

[buchstaben]

http://www.codeproject.com/script/Forums/View.aspx?fid=1649&msg=2468882[^]

[Ravenet]

Hi Man Please check in this url www.csharp-corner.com thanks

Cheers,Earn and Enjoy RRave MCTS,MCPD http://ravesoft.blogspot.com

[dhans]

private void Exl_Click(object sender, System.Web.UI.ImageClickEventArgs e) { string strTitle = " any Name u give" + DateTime.Now; new DataGridExcelExporter(this.gridname , this.Page).Export(strTitle); }

dhans

[Walaza]

I am doing a Windows application. Is there code for a Windows application to do this?

Mvelo Walaza Developer Telkom SA