bind the grid view data into excel sheet

Hi Naidu,
follow this link.
http://www.aspdotnet-suresh.com/2011/04/how-to-export-gridview-data-to-excel-or.html

Thanks & Regards
Hari

Subbaniadu, if this helps please login to Mark As Answer. | Alert Moderator

this is pretty easy to do in the DOTNET world. All you have to do is set the contenttype of the response to excel and write the html output to the buffer.
private void ExportToExcel()
{
Response.Clear();
Response.AddHeader("content-disposition", "attachment;filename=Products.xls");
Response.Charset = String.Empty;
Response.ContentType = "application/ms-excel";
StringWriter stringWriter = new StringWriter();
HtmlTextWriter HtmlTextWriter = new HtmlTextWriter(stringWriter);
gvProducts.RenderControl(HtmlTextWriter);
Response.Write(stringWriter.ToString());
Response.End();
}
For complete details and explanation of the process, go to this link http://technico.qnownow.com/2012/04/06/export-data-from-asp-net-gridview-control-to-excel/

Subbaniadu, if this helps please login to Mark As Answer. | Alert Moderator

i think, this is what you wanted

http://www.aspsnippets.com/Articles/Read-and-Import-Excel-Sheet-into-ASP.Net-GridView-Control.aspx

Subbaniadu, if this helps please login to Mark As Answer. | Alert Moderator