How to Export Grind View data to excel?

Question

How to Export Grind View data to excel. pls send me With Examples.

Hermes Condez · Answer

try this one. I use this in our project. Exporting grid view to Excel. protected void ExportToXls_Click(object sender, EventArgs e) //On click Event of a control (button/link button/hyperlink) { this.DataGridView1.AllowPaging = false; ExportGridViewToExcel(Response, this.DataGridView1, "Exported.xls"); } public void ExportGridViewToExcel(HttpResponse response, GridView gvControl, string fileName) { string attachment = ""; System.IO.StringWriter sw = new System.IO.StringWriter(); HtmlTextWriter htw = new HtmlTextWriter(sw); response.AddHeader("content-disposition", "attachment; filename=" + fileName); response.ClearContent(); response.AddHeader("content-disposition", attachment); gvControl.AllowPaging = false; gvControl.DataBind(); gvControl.RenderControl(htw); response.Write(sw.ToString()); response.Flush(); response.End(); gvControl.AllowPaging = true; } public override void VerifyRenderingInServerForm(Control control) // I just got this in forum just // add this. I don't why but it will work if this is added { }

Satyapriya Nayak · Answer

Hi Magesh, Please refer the below link http://www.c-sharpcorner.com/UploadFile/DipalChoksi/exportxl_asp2_dc11032006003657AM/exportxl_asp2_dc.aspx Thanks

How to Export Grind View data to excel?

Answers (2)