如何删除分页文本Excel工作表，同时从GridView控件Excelsheet导出数据？ [英] How to remove paging text in excel sheet while exporting data from GridView to Excelsheet?

问题描述

我实现出口asp.net application.Here到Excel功能我从网格视图的数据导出到Excel的sheet.I也网格视图应用寻呼。

I implemented export to excel functionality in asp.net application.Here i export data from Grid-view to excel-sheet.I also applied Paging in Grid-view.

所以，当我从网格视图数据导出到Excel工作表，分页文本也在Excel工作表如图所示，给定图像中显示。

So when i export data from Grid-view to excel sheet,paging text also display in excel sheet as shown in the given image.

我们如何可以将其删除。

How can we remove it

我按照下面的方法将数据导出

i follow the below approach for exporting data

code-背后：

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

感谢

推荐答案

在渲染之前 - 禁用分页，将数据绑定，然后渲染：

Before rendering - disable the paging, bind the data and then render:

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

这篇关于如何删除分页文本Excel工作表，同时从GridView控件Excelsheet导出数据？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！