Login | Register   
LinkedIn
Google+
Twitter
RSS Feed
Download our iPhone app
TODAY'S HEADLINES  |   ARTICLE ARCHIVE  |   FORUMS  |   TIP BANK
Browse DevX
Sign up for e-mail newsletters from DevX


Tip of the Day
Language: ASP.NET
Expertise: Intermediate
Apr 17, 2006

How to Display ASP.NET DataGrid Data in Excel

Suppose you have a DataGrid with several columns full of data. The DataGrid contains several pages. You can disable paging and export all the data to Excel using the RenderControl method:

//export to excel
DataGrid_Dimension.AllowPaging = false;
BindGrid();

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

this.ClearControls(DataGrid_Dimension);
DataGrid_Dimension.RenderControl(oHtmlTextWriter);

Response.Write(oStringWriter.ToString());

Response.End();
Naveen Lanke
 
Comment and Contribute

 

 

 

 

 


(Maximum characters: 1200). You have 1200 characters left.

 

 

Sitemap