how to export datagrid data into excel ??

Question

Hi, I m developing WINDOWS application. In this I m using XML to fill DATAGRID. Now I want to export this datagrid data into Excel sheet. But I have no idea how to do it? Can one guide me ??? send me code please. Thank you, bhavin

sunil · Answer

Find the article here which describes you to how to export it from windows application http://www.dotnetspider.com/technology/kbpages/950.aspx You many need Microsoft Excel 10.0 Object library, which can be downloaded from microsoft website.

onlybhavin · Answer

Hi, thank you but, If i m not wrong,You have given code but it is for web. I need code that work on windows application. OR guide me how to get Response. ? thank you, bhavin

sunil · Answer

Here is the code for exporting data to excel. Response.ContentType="application/vnd.ms-excel"; Response.ContentEncoding=System.Text.Encoding.Default; Response.Charset = ""; this.EnableViewState=false; // dg is the name of the datagird dg.HeaderStyle.CssClass = "subhead"; dg.DataSource=ds.Tables[0].DefaultView; dg.DataBind(); System.IO.StringWriter tw = new System.IO.StringWriter(); System.Web.UI.HtmlTextWriter hw = new HtmlTextWriter(tw); dg.RenderControl(hw); Response.Write(tw.ToString()); Response.End();

how to export datagrid data into excel ??

Answers (3)