各位,在弹出的模态框上,将GridView里的内容导出到Excel。怎么不好用呀!我的导出的后台代码public static void ToExcel(GridView gvExport, string fileName)
{
HttpContext curContext = HttpContext.Current;
StringWriter strWriter = null;
HtmlTextWriter htmlWriter = null; curContext.Response.AddHeader("content-disposition", "attachment; filename=" + fileName);
curContext.Response.ContentType = "application/vnd.ms-excel";
curContext.Response.ContentEncoding = Encoding.UTF7;
strWriter = new StringWriter();
htmlWriter = new HtmlTextWriter(strWriter); gvExport.RenderControl(htmlWriter);
curContext.Response.Write(strWriter.ToString());
curContext.Response.Flush();
//curContext.ApplicationInstance.CompleteRequest();
curContext.Response.End(); }
{
HttpContext curContext = HttpContext.Current;
StringWriter strWriter = null;
HtmlTextWriter htmlWriter = null; curContext.Response.AddHeader("content-disposition", "attachment; filename=" + fileName);
curContext.Response.ContentType = "application/vnd.ms-excel";
curContext.Response.ContentEncoding = Encoding.UTF7;
strWriter = new StringWriter();
htmlWriter = new HtmlTextWriter(strWriter); gvExport.RenderControl(htmlWriter);
curContext.Response.Write(strWriter.ToString());
curContext.Response.Flush();
//curContext.ApplicationInstance.CompleteRequest();
curContext.Response.End(); }
解决方案 »
- repeater中绑定图片地址
- 读写 txt
- 关于asp。net
- 为什么我的TreeView控件在VS2005中可以正常显示,而在IIS中就不能显示了?
- 怎样传递页面值??
- 如何在网页中实现类似.net 中代码段 #region ....endregion 收缩的功能?
- 在VISUAL STUDIO 2003 中怎样手工画表格,象在frontpage中一样 ??
- 在线请教一个用脚本代码判断DataGrid中是否有选中的项目?
- 请问如何使强制用户从网站的登录页面进入,而防止直接输入内部一个页面地址进入?
- 焦急求救中!
- <a>标签的问题!新手提问!
- 跪谢!一直没有心爱的后台编辑器,希望各路英豪能够给小弟2个?!
public void OutExcel(int pageIndex)
{
Response.Clear();
Response.Buffer = true;
//string filename = "attachment;filename=" + System.Web.HttpUtility.UrlEncode("报表", System.Text.Encoding.UTF8) + ".xls";
//Response.AppendHeader("Content-Disposition", filename); string fileName = this.Date + "列表" + ".xls";
Response.AppendHeader("Content-Disposition", "attachment;filename=" + System.Web.HttpUtility.UrlEncode(fileName));
Response.Charset = "gb2312";
EnableViewState = false;
// 如果设置为 GetEncoding("GB2312");导出的文件将会出现乱码!!!
//Response.ContentEncoding = System.Text.Encoding.UTF7;
Response.ContentType = "application/ms-excel";//设置输出文件类型为excel文件。
System.IO.StringWriter oStringWriter = new System.IO.StringWriter();
System.Web.UI.HtmlTextWriter oHtmlTextWriter = new System.Web.UI.HtmlTextWriter(oStringWriter);
this.DataGrid1.AllowPaging = false; this.htxtbindState.Value = "1";
ShowData(); this.DataGrid1.RenderControl(oHtmlTextWriter);
Response.Output.Write(oStringWriter.ToString());
Response.Flush();
Response.End(); this.DataGrid1.AllowPaging = true;
this.DataGrid1.CurrentPageIndex = pageIndex; this.htxtbindState.Value = "0";
ShowData();
}请参考一下 我都用这个方法导出的
{
//base.VerifyRenderingInServerForm(control);
}加这方法看看