How to export datagridview contents to excel

Question

I have to export the data present in the datagridview to Microsoft Excel. It is a window application using c#. Does anyone know how to do it. Please help. Thanks

shanmuganathan raju · Answer

This Datagrid to Excel: using System; using System.Data; using System.Configuration; using System.Collections; using System.Web; using System.Web.Security; using System.Web.UI; using System.Web.UI.WebControls; using System.Web.UI.WebControls.WebParts; using System.Web.UI.HtmlControls; using System.IO; public partial class ExcelSheet_ExportExcel : System.Web.UI.Page { GridView grdStudentMarks = new GridView(); Button btnExportToGrid = new Button(); protected void Page_Load(object sender, EventArgs e) { // SqlDataSource sds = new SqlDataSource(@"Data Source=Master\SQLEXPRESS; Initial Catalog=shan; User Id=shan; Password=Raju", "select * from MarkSheet"); grdStudentMarks.DataSource = sds; grdStudentMarks.DataBind(); // Form.Controls.Add(grdStudentMarks); Form.Controls.Add(btnExportToGrid); string path = Context.Server.MapPath("Download.aspx"); btnExportToGrid.Text = "Export To Grid "; btnExportToGrid.Click += new EventHandler(this.btnExportToGrid_Click); } void btnExportToGrid_Click(object sender, EventArgs e) { ExportGridToExcel(grdStudentMarks, "DynamicsDunction"); } private void ExportGridToExcel(GridView grdGridView, string fileName) { IList list = new ArrayList(); Response.Clear(); Response.AddHeader("content-disposition", string.Format("attachment;filename={0}.xls", fileName)); Response.Charset = ""; Response.ContentType = "application/vnd.xls"; StringWriter stringWrite = new StringWriter(); HtmlTextWriter htmlWrite = new HtmlTextWriter(stringWrite); grdGridView.RenderControl(htmlWrite); Response.Write(stringWrite.ToString()); Response.Flush(); Response.End(); } public override void VerifyRenderingInServerForm(Control control) { } }

How to export datagridview contents to excel

Answers (1)