asp.net - 将数据从 GridView 导出到 Excelsheet 时如何删除 Excel 工作表中的分页文本？

Question

我在asp.net应用程序中实现了导出到excel的功能。这里我将数据从 GridView 导出到excel表。我还在 GridView 中应用了分页。

因此，当我将数据从 GridView 导出到 Excel 工作表时，分页文本也会显示在 Excel 工作表中，如给定图像所示。

如何删除它

我按照以下方法导出数据

代码隐藏:

Response.Clear()
Response.ClearHeaders()
Response.AddHeader("content-disposition", "attachment;filename=sample.xls")
Response.Charset = ""
Response.ContentType = "application/vnd.xls"

Dim sb As StringBuilder = New StringBuilder()
Dim objStringWriter As StringWriter = New StringWriter(sb)
Dim objHtmlTextWriter As HtmlTextWriter = New HtmlTextWriter(objStringWriter)

//gvSample is Gridview server control
gvSample.RenderControl(objHtmlTextWriter)

Response.ContentEncoding = Encoding.Unicode
Response.BinaryWrite(System.Text.Encoding.Unicode.GetPreamble())
Response.Write(objStringWriter)
Response.End()

谢谢

Answer 1

渲染之前 - 禁用分页，绑定(bind)数据然后渲染:

 gvSample.AllowPaging = false;
 gvSample.DataSource = ds; //Data Source
 gvSample.DataBind();
 gvSample.RenderControl(objHtmlTextWriter)