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 wrongYou 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();