asp.net GridView导出到Excel代码

复制代码 代码如下:

  StringBuilder sb = new StringBuilder();

  StringWriter sw = new StringWriter(sb);

  HtmlTextWriter htw = new HtmlTextWriter(sw);

  Page page = new Page();

  HtmlForm form = new HtmlForm();

  GVLinkman.EnableViewState = false;

  page.EnableEventValidation = false;

  page.DesignerInitialize();

  page.Controls.Add(form);

  form.Controls.Add(GVLinkman);

  page.RenderControl(htw);

  Response.Clear();

  Response.Buffer = true;

  Response.ContentType = "application/vnd.ms-excel";

  Response.AddHeader("Content-Disposition", "attachment;filename=data.xls");

  Response.Charset = "UTF-8";

  Response.ContentEncoding = Encoding.Default;

  Response.Write(sb.ToString());

  Response.End();