GridView导出Excel加上样式并且去除超链接

最新推荐文章于 2025-04-07 15:52:16 发布

Love-glory

最新推荐文章于 2025-04-07 15:52:16 发布

阅读量1.1k

点赞数

文章标签： GridView 导出 Excel 加上样式除超链接

本文介绍了一个使用ASP.NET中GridView导出数据到Excel的方法，并详细解释了如何去除导出内容中的超链接及添加自定义样式。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

GridView导出Excel加上样式并且去除超链接

protected void BtnExcel_Click(object sender, EventArgs e)
{
Response.Clear();
//Response.AddHeader("content-disposition", "attachment;filename=考核结果.xls");
Response.AppendHeader("Content-Disposition", "attachment;filename=" + HttpUtility.UrlEncode("考核结果.xls",Encoding.UTF8).ToString());
Response.Charset = "gb2312";
Response.ContentType = "application/ms-excel";
System.IO.StringWriter stringWrite = new System.IO.StringWriter();
System.Web.UI.HtmlTextWriter htmlWrite = new HtmlTextWriter(stringWrite);
GridView1.RenderControl(htmlWrite);

string strExcel = stringWrite.ToString();

//正则表达式,去除超链接,加个名称空间:System.Text.RegularExpressions;
strExcel = Regex.Replace(strExcel, "<a (.*?)>", "", RegexOptions.Compiled);

strExcel = Regex.Replace(strExcel, "</a>", "");

//添加样式
Response.Write(@"<style type='text/css'>
.width300{width:100px;}
</style>");
Response.Write(strExcel);
Response.End();
}
//如果没有下面方法会报错类型“GridView”的控件“GridView1”必须放在具有 runat=server 的窗体标记内
public override void VerifyRenderingInServerForm(Control control)
{

}