Response.ContentType = "application/vnd.ms-excel";
Response.Charset="GB2312";
Response.AppendHeader("Content-Disposition","attachment;filename=UpdateDataLog.xls");
Response.ContentEncoding=System.Text.Encoding.UTF7; //设置输出流为简体中文
this.EnableViewState = false;
System.IO.StringWriter sw = new System.IO.StringWriter();
System.Web.UI.HtmlTextWriter hw = new System.Web.UI.HtmlTextWriter(sw);
int nCur = this.dgRepair.CurrentPageIndex;
int nSize = this.dgRepair.PageSize;
this.dgRepair.AllowPaging = false;
this.RepairBind();
this.dgRepair.RenderControl(hw);
//以下恢复分页
this.dgRepair.AllowPaging = true;
this.dgRepair.CurrentPageIndex = nCur;
this.dgRepair.PageSize = nSize;
//重新绑定DataGrid
this.RepairBind();
Response.Write(sw.ToString());
Response.End();
DataGrid导出到Excel(带分页)
最新推荐文章于 2024-05-06 08:53:54 发布
这篇博客介绍如何将带有分页的DataGrid数据导出为Excel文件。通过设置Response.ContentType和Content-Disposition,创建一个Excel文件并指定文件名。使用UTF7编码确保中文字符正确显示,并禁用DataGrid的分页功能进行渲染,然后恢复分页设置,最后将内容写入Response并结束响应。
摘要由CSDN通过智能技术生成