Export to Excel from Gridview in ASP.net Form

Question

Dear Frnds, I want a form in which i have a Gridview, i want to export all the records or data in that Gridview to Excel. please help me. Thanks aamir

Tulasi · Answer

Response.Clear() ' Set the type and filename Response.AddHeader( "content-disposition" , "attachment;filename=FileName.xls" ) Response.Charset = "" Response.ContentType = "application/vnd.xls" ' Add the HTML from the GridView to a StringWriter so we can write it out later Dim sw As System.IO.StringWriter = New System.IO.StringWriter Dim hw As System.Web.UI.HtmlTextWriter = New HtmlTextWriter(sw) GridView1.RenderControl(hw) ' Write out the data Response.Write(sw.ToString) Response. End () check the below link http://www.codeproject.com/KB/office/office_automation.aspx Please mark the answer as Accepted if it helps you.

Hemant Kumar · Answer

Hi You need to add this lines of Code in the button Click of Export to Excel Response.Clear(); Response.AddHeader("content-disposition", "attachment; filename=FileName.xls"); Response.Charset = ""; // If you want the option to open the Excel file without saving than // comment out the line below // Response.Cache.SetCacheability(HttpCacheability.NoCache); Response.ContentType = "application/vnd.xls"; System.IO.StringWriter stringWrite = new System.IO.StringWriter(); System.Web.UI.HtmlTextWriter htmlWrite = new HtmlTextWriter(stringWrite); GridView1.RenderControl(htmlWrite); Response.Write(stringWrite.ToString()); Response.End();

Export to Excel from Gridview in ASP.net Form

Insert Link

Embed YouTube Video

Table Options

Insert Image

Answers (2)