将gridview导出到ASP.Net中的Excel [英] Export a gridview to Excel in ASP.Net

问题描述

我在某个页面中有一个网格视图。我需要将网格视图的内容导出为MS Excel格式。



请帮助。



谢谢。

解决方案

嗨Singha Roy，

 <   pre     lang   =  cs  >  Response.ClearContent（）; 
 Response.Buffer = true; 
 Response.AddHeader（content-disposition，string.Format（attachment; filename = {0}，Customers.xls））; 
 Response.ContentType =application / ms-excel; 
 StringWriter sw = new StringWriter（）; 
 HtmlTextWriter htw = new HtmlTextWriter（sw）; 
 gvdetails.AllowPaging = false; 
 gvdetails.DataBind（）; 
 gvdetails.RenderControl（htw）; 
 Response.Write（sw.ToString（））; 
 Response.End（）; <   / pre  >  

查看此链接。我留给您的唯一任务是选择您喜欢的那个。



GridView导出到asp.net中的excel [ ^ ]

对于大型数据网格内容，请看：< br $> b $ b

导出非常大的数据到Excel fi le [ ^ ]

I have a grid view in a certain page. I need to export the contents of the grid view to MS Excel format.

Please Help.

Thank You.

解决方案

Hi Singha Roy,

<pre lang="cs">Response.ClearContent();
Response.Buffer = true;
Response.AddHeader("content-disposition", string.Format("attachment; filename={0}", "Customers.xls"));
Response.ContentType = "application/ms-excel";
StringWriter sw = new StringWriter();
HtmlTextWriter htw = new HtmlTextWriter(sw);
gvdetails.AllowPaging = false;
gvdetails.DataBind();
gvdetails.RenderControl(htw);
Response.Write(sw.ToString());
Response.End();</pre>

See this link.The only task i left on you is to choose the one you like.

GridView export to excel in asp.net[^]

For large datagrid contents, please see this :

Export very large data to Excel file[^]

这篇关于将gridview导出到ASP.Net中的Excel的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！