asp.net GridView导出到Excel代码_asp.net教程-查字典教程网
asp.net GridView导出到Excel代码
asp.net GridView导出到Excel代码
发布时间:2016-12-29 来源:查字典编辑
摘要:复制代码代码如下:StringBuildersb=newStringBuilder();StringWritersw=newStringWr...

复制代码 代码如下:

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

相关阅读
推荐文章
猜你喜欢
附近的人在看
推荐阅读
拓展阅读
  • 大家都在看
  • 小编推荐
  • 猜你喜欢
  • 最新asp.net教程学习
    热门asp.net教程学习
    编程开发子分类