GridView导出数据到Excel
来源:互联网 发布:手机代理设置软件 编辑:程序博客网 时间:2024/04/30 09:38
protected void OutButton_Click(object sender, EventArgs e)
{
GridView2.DataSource = 数据;
GridView2.DataBind();
Response.Clear();
Response.Buffer = true;
Response.Charset = "GB2312";
Response.AppendHeader("Content-Disposition", "attachment;filename=StandingBooks.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.GridView2.RenderControl(oHtmlTextWriter);
//Response.Write("<meta http-equiv=Content-Type c/html;charset=gb2312>");
Response.Write(oStringWriter.ToString());
Response.End();
GridView2.Visible = false;
}
{
GridView2.DataSource = 数据;
GridView2.DataBind();
Response.Clear();
Response.Buffer = true;
Response.Charset = "GB2312";
Response.AppendHeader("Content-Disposition", "attachment;filename=StandingBooks.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.GridView2.RenderControl(oHtmlTextWriter);
//Response.Write("<meta http-equiv=Content-Type c/html;charset=gb2312>");
Response.Write(oStringWriter.ToString());
Response.End();
GridView2.Visible = false;
}
- GridView导出数据到Excel
- GridView导出数据到Excel
- GridView导出数据到Excel
- GridView导出数据到Excel
- Gridview导出数据到Excel
- 导出gridview数据到Excel
- gridview导出数据到excel
- 导出GridView数据到Excel
- GridView导出数据到Excel
- GridView导出数据到Excel
- Gridview导出数据到Excel
- GridView导出数据到Excel
- gridView导出数据到Excel...Excel导入数据到GridView
- GridView 导出数据到excel数据乱码
- GridView 导出数据到 EXCEL 失败
- GridView 数据导出到 Excel文件
- GridView数据导出到Word/Excel中
- gridview数据导出到excel打印
- 嵌入式系统开发学习
- c#中Split等分割字符串的几种方法(转)
- 修改Zend引擎实现PHP源码加密的原理及实践
- javascript-----页面对象
- 两个很常用的存储过程
- GridView导出数据到Excel
- 中国最牛十大美女CEO
- P2P的工作原理
- 开始tcl/tk之旅
- 选择软件行业不要后悔
- Sql*plus技巧之SPOOL应用
- 内存映射文件
- 删除XP和linux中的linux的方法
- 职业人,不但要管理时间,更要管理自己