Click here to Skip to main content
16,016,306 members
Please Sign up or sign in to vote.
1.00/5 (1 vote)
See more:
Hi Developers,

Export Data to excel and how to export particular sheet in web application ,

here how to export to excel data i know but i don't know how to export particular sheet.please help me on this urgent.

Thanks for advance helping,

regards
aravind
Posted

1 solution

Not sure particular sheet means. But, I've the code to export GridView data into excel as:

C#
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);
      oHtmlTextWriter.WriteLine("<font size="5"><font color="blue"><center> REPORT </center></font></font>");
      GridView1.RenderControl(oHtmlTextWriter);
      Response.End();
  }
 
Share this answer
 
Comments
Aravind Garre 12-Feb-12 23:38pm    
Dear GanesanSenthilvel,

Thanks For response.is it possible to export existing excel sheets in web application.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)



CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900