GridView导出成Excel(整理)
来源:互联网 发布:阿里云 弹性ip bgp带宽 编辑:程序博客网 时间:2024/06/04 17:39
将gridview导出成excel
后台代码:
#region 导入Excel
protected void btnOutExcel_Click(object sender, EventArgs e)
{
string style = "<style> td { mso-number-format:\"\\@\"; } </style> ";//导入excel时,将所有数据类型改为文本类型
HttpContext.Current.Response.Clear();
HttpContext.Current.Response.Buffer = true;
HttpContext.Current.Response.Charset = "UTF-8";
HttpContext.Current.Response.AddHeader("content-disposition", "attachment;filename=TerminalDetails.xls");
Response.ContentEncoding = System.Text.Encoding.GetEncoding("UTF-8");
HttpContext.Current.Response.ContentType = "application/ms-excel";
Response.Write("<meta http-equiv=Content-Type content=\"text/html;chartset=UTF-8\">");
System.IO.StringWriter stringWrite = new System.IO.StringWriter();
System.Web.UI.HtmlTextWriter htmlWrite = new HtmlTextWriter(stringWrite);
this.gdvTerminalDetals.AllowPaging = false;
stringWrite.WriteLine(style);
this.gdvTerminalDetals.RenderControl(htmlWrite);
Response.Output.Write(stringWrite.ToString());
HttpContext.Current.Response.Flush();
HttpContext.Current.Response.End();
}
public override void VerifyRenderingInServerForm(Control control)
{
}
#endregion
- GridView导出成Excel(整理)
- GridView导出成Excel遇到的问题整理
- Gridview导出成Excel
- 将gridview导出成Excel
- gridview导出Excel解决方案整理(解决乱码问题)
- GridView导出成EXCEL的代码
- UpdatePanel中的GridView导出成Excel
- GridView导出Excel(网页版)
- GridView导出Excel研究
- GridView导出Excel研究
- GridView导出Excel研究
- GridView导出Excel
- GridView格式化导出Excel
- GridView导出Excel研究
- GridView导出到Excel
- GridView导出Excel研究
- GridView导出Excel研究
- GridView导出Excel研究
- arm-elf和arm-eabi的区别
- 加密算法简介
- MFC的COleDateTime类使用
- 如何使用Activity创建对话框
- jquery json
- GridView导出成Excel(整理)
- automake,autoconf使用详解
- 重要blog关注
- Excel 匯出,服務器文件資料下載
- VC操作Excel,使用Worksheet的get_Range发生异常
- 利用DB_LINK在不同平台的数据库中复制数据。
- 通过System.getProperties()获取系统参数
- GridView导出成Excel遇到的问题整理
- js jquery 计算两个时间差