Export Grid View of .Net to Excel
Dear All, Here is a new article for exporting your Grid View to Excel. Feel Free to ask your queries. Following are the steps for this: 1. Create a Grid View on Web Page. 2. Bind grid view with data. For binding of gridview you can refer to the previous article "Dynamic Gridview Bind" Url: http://dinesh-itsolutions.blogspot.in/2010/09/dynamic-gridview-bind.html. 3. After binding the grid view put a button on the web page named "Export to Excel". On Clicking of that button you can copy and paste the following code. protected void btnExport( object sender, EventArgs e) { Response.Clear(); Response.Buffer = true ; Response.AddHeader( "content-disposition" , "attachment;filename=ExportedFile.xls" ); Response.Charset = "" ; Response.ContentType = "application/vnd.ms-excel" ; using ( StringWriter sw = new StringWriter ()) {