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