How to import the gridview data in to excel. i want to see the record in excel format how to do?

Question

How to import the grid view data in to excel. i want to see the record in excel format how to do?

Satyapriya Nayak · Answer

Hi narasiman Try this... Untitled Page Text=Import to Excel /> using System; using System.Collections; using System.Configuration; using System.Data; using System.Linq; using System.Web; using System.Web.Security; using System.Web.UI; using System.Web.UI.HtmlControls; using System.Web.UI.WebControls; using System.Web.UI.WebControls.WebParts; using System.Xml.Linq; using System.Data.SqlClient; using System.Text; namespace import_the_gridview_data_in_excel { public partial class _Default : System.Web.UI.Page { string connStr = ConfigurationManager.ConnectionStrings[ConnectionString].ConnectionString; protected void Page_Load(object sender EventArgs e) { SqlConnection conn = new SqlConnection(connStr); SqlDataAdapter sqlda = new SqlDataAdapter(SELECT * from employee conn); DataSet ds = new DataSet(); sqlda.Fill(ds employee); GridView1.DataSource = ds; GridView1.DataMember = employee; GridView1.DataBind(); } protected void Button1_Click(object sender EventArgs e) { ExportToExcel(Report.xls GridView1); } private void ExportToExcel(string strFileName GridView dg) { Response.Clear(); Response.Buffer = true; Response.ContentType = application/vnd.ms-excel; Response.Charset = ; this.EnableViewState = false; System.IO.StringWriter oStringWriter = new System.IO.StringWriter(); System.Web.UI.HtmlTextWriter oHtmlTextWriter = new System.Web.UI.HtmlTextWriter(oStringWriter); GridView1.RenderControl(oHtmlTextWriter); Response.Write(oStringWriter.ToString()); Response.End(); } public override void VerifyRenderingInServerForm(Control control) { } } } Thanks If this post helps you mark it as answer