.net把DataGrid导出到excel怎么过滤掉按钮列？

Question

1、下面是我的代码，好像只能导出整个页面，不知道怎么过滤按钮

  public void ToExcel(System.Web.UI.Control ctl, String filename)
{

    HttpContext.Current.Response.AppendHeader("Content-Disposition", "attachment;filename=" + filename + ".xls");

    HttpContext.Current.Response.Charset = "UTF-8";

    HttpContext.Current.Response.ContentEncoding = System.Text.Encoding.Default;

    HttpContext.Current.Response.ContentType = "application/ms-excel";//image/JPEG;text/HTML;image/GIF;vnd.ms-excel/msword

    ctl.Page.EnableViewState = false;

    System.IO.StringWriter tw = new System.IO.StringWriter();

    System.Web.UI.HtmlTextWriter hw = new System.Web.UI.HtmlTextWriter(tw);

    ctl.RenderControl(hw);

    HttpContext.Current.Response.Write(tw.ToString());

    HttpContext.Current.Response.End();

}

2、我的页面是这样的

3、点击按钮导出之后是这样，求指点怎么解决，谢谢

Answer 1

最简单的是
ctl.RenderControl(hw);
string s = tw.ToString();
这里你调试输出下s

然后用证则表达式将不要的内容replace掉
再HttpContext.Current.Response.Write(s);