导出gridview后，删除excel标头中的图像 [英] Remove Image in excel header after exporting the gridview

问题描述

请帮助我如何删除excel标头中的图像.我使用gridview作为源数据使用export命令生成了excel.这是我的代码

Kindly help me on how to remove image in my excel header. I generate the excel using export command using gridview as source data. Here is my code

Response.AddHeader("content-disposition", "attachment;filename=" & strFilename & ".xls")         
Response.Clear()         
Response.Charset = ""         
Response.ContentType = "application/vnd.xls"           
Dim sw As System.IO.StringWriter = New System.IO.StringWriter()         
Dim htw As System.Web.UI.HtmlTextWriter = New System.Web.UI.HtmlTextWriter(sw)           
grvData.AllowPaging = False         
grvData.AllowSorting = False         
PopulateGrid()          
grvData.RenderControl(htw)         
Response.Write(sw.ToString)         
Response.End() 

一切都已设置-除了我的标头中有一个标头名称空白(因为现在显示的图像)-该图像来自gridview(我使用箭头表示asc和desc)

Everything was set - except that one my header had a blank header name because of the image that was now shown - the image is came from gridview (I''m using arrow for asc and desc)

推荐答案

导出之前，隐藏您的HeaderImage
使用visible = false;

Before Exporting hide your HeaderImage
use visible = false;

这篇关于导出gridview后，删除excel标头中的图像的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！