.net导出EXCEL
来源:互联网 发布:小米mix2抢购软件 编辑:程序博客网 时间:2024/06/15 09:16
#region 导出EXCEL代码
protected void Button3_Click(object sender, EventArgs e)
{
//if (this.GridView1.Rows.Count != 0)
//{
// HttpContext.Current.Response.Clear();
// HttpContext.Current.Response.Charset = "utf-8";
// HttpContext.Current.Response.Buffer = true;
// HttpContext.Current.Response.ContentType = "application/excl";
// HttpContext.Current.Response.AddHeader("content-disposition", "attachment;filename=" + DateTime.Now.ToString("yyyyMMddHHmmss") + ".xls");
// System.IO.StringWriter writer = new System.IO.StringWriter();
// System.Web.UI.HtmlTextWriter htmlwrite = new HtmlTextWriter(writer);
// //this.GridView1.AllowPaging = false;
// this.LrTable1.RenderControl(htmlwrite);
// HttpContext.Current.Response.Write(writer);
//}
//else
//{
// Response.Redirect("<script>alert('对不起,暂无信息可以导出!!')</script>");
//}
Response.Clear();
Response.Buffer = true;
Response.Charset = "utf-8";
Response.AppendHeader("Content-Disposition", "attachment;filename=statzy.xls");
Response.ContentEncoding = System.Text.Encoding.GetEncoding("utf-8");//设置输出流为简体中文
Response.ContentType = "application/ms-excel";//设置输出文件类型为excel文件。
this.EnableViewState = false;
System.Globalization.CultureInfo myCItrad = new System.Globalization.CultureInfo("ZH-CN", true);
System.IO.StringWriter oStringWriter = new System.IO.StringWriter(myCItrad);
System.Web.UI.HtmlTextWriter oHtmlTextWriter = new System.Web.UI.HtmlTextWriter(oStringWriter);
this.GridView1.RenderControl(oHtmlTextWriter);//将服务器控件的内容输出
Response.Write(oStringWriter.ToString());
Response.End();
}
public override void VerifyRenderingInServerForm(Control control)
{
//base.VerifyRenderingInServerForm(control);
}
#endregion
注释掉的是导出的GV以后的页面中所有东西!
- asp.net导出excel
- asp.net导出Excel
- .NET----导出EXCEL
- asp.net导出excel
- NET导出Excel-1
- NET导出Excel-2
- .net 导出Excel报表
- asp.net导出Excel
- Asp.net 导出Excel
- asp.net导出excel
- .net导出Excel
- asp.net 导出excel
- .NET导出Excel文件
- .NET导出Excel文件
- asp.net 导出Excel
- .net 导出到Excel
- asp.net 导出 excel
- asp.net导出Excel
- 启动mongodb报1067错误
- KMP Oulipo
- 电脑在IDE模式下能正常启动,改成AHCI后蓝屏——解决方法
- [转载]x86/x86-64/x64/AMD64/IA64/Intel64
- editui界面常用代码
- .net导出EXCEL
- 44. Element insertBefore() 方法
- 利用ffmpeg将H264流 解码为RGB
- Windows/MFC_ 如何判断CString类型是否为空
- ThinkPHP学习笔记( 一)安装配置
- ORA-01461: 仅能绑定要插入 LONG 列的 LONG 值
- 解决MAVEN内存溢出
- Golang适合高并发场景的原因分析
- hdu 1686 Oulipo