创建通用功能以将gridview导出到Excel [英] create common function to export gridview to Excel

问题描述

我在aspx.cs页面中使用以下代码导出到excel
它的工作很好

 Response.Clear();
Response.Buffer =  true ;
Response.AddHeader(" ，" 附件；文件名= g.xls")；
Response.Charset = " ;
Response.ContentType = " ;
StringWriter sw = 新 StringWriter();
HtmlTextWriter ht = 新 HtmlTextWriter(sw);
gvDisplay.AllowPaging =  false ;
gvDisplay.DataBind();
gvDisplay.RenderControl(ht);
Response.Output.Write(sw.ToString());
Response.Flush();
Response.End(); 

折叠|复制代码
公共 覆盖  void  VerifyRenderingInServerForm(控制控件)
{

} 

但是我想在我的普通课堂上创建全局功能，我尝试关注

 公共  void  export(GridView gvDisplay，fileName)
{
     Response.Clear();
Response.Buffer =  true ;
Response.AddHeader(" ，" 附件；文件名=" + fileName +  . xls");
Response.Charset = " ;
Response.ContentType = " ;
StringWriter sw = 新 StringWriter();
HtmlTextWriter ht = 新 HtmlTextWriter(sw);
gvDisplay.AllowPaging =  false ;
gvDisplay.DataBind();
gvDisplay.RenderControl(ht);
Response.Output.Write(sw.ToString());
Response.Flush();
Response.End();
} 

但我不能使用

 公共 覆盖  void  VerifyRenderingInServerForm(控制控件)
{

} 

类中的方法
请帮我解决
感谢u

解决方案

从C#中的GridView导出到Excel [ ^ ]

hi,
i use following code in aspx.cs page to export to excel
its work fine

Response.Clear();
Response.Buffer = true;
Response.AddHeader("content-disposition","attachment;filename=g.xls");
Response.Charset = "";
Response.ContentType = "application/vnd.ms-excel";
StringWriter sw = new StringWriter();
HtmlTextWriter ht = new HtmlTextWriter(sw);
gvDisplay.AllowPaging = false;
gvDisplay.DataBind();
gvDisplay.RenderControl(ht);
Response.Output.Write(sw.ToString());
Response.Flush();
Response.End();

Collapse | Copy Code
public override void VerifyRenderingInServerForm(Control control)
{

}

but i want to create global functon in my common class i try followin

public void export(GridView gvDisplay, fileName)
{
     Response.Clear();
Response.Buffer = true;
Response.AddHeader("content-disposition","attachment;filename="+fileName+".xls");
Response.Charset = "";
Response.ContentType = "application/vnd.ms-excel";
StringWriter sw = new StringWriter();
HtmlTextWriter ht = new HtmlTextWriter(sw);
gvDisplay.AllowPaging = false;
gvDisplay.DataBind();
gvDisplay.RenderControl(ht);
Response.Output.Write(sw.ToString());
Response.Flush();
Response.End();
}

but i cant use

public override void VerifyRenderingInServerForm(Control control)
{

}

method in class
pls help me to solve it
Thank u

解决方案

Exporting a DataGridView to Excel in .NET 2.0 (C# code)[^]

Hi, use below link. it will provide a best solution and a well formatted excel.

Export to Excel from GridView in C#[^]

这篇关于创建通用功能以将gridview导出到Excel的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！