第一种方法:
/// <summary>
/// 导出表格到excel文件功能
/// </summary>
/// <param name="page">需要导出的页面</param>
/// <param name="gridData">要导出的数据表</param>
public static void ExportExcel(Page page, GridView gridData,string fileName)
{
page.Response.Clear();
page.Response.Buffer = true;
page.Response.Charset = "GB2312";
page.Response.AppendHeader("Content-Disposition", "attachment;filename=" + fileName + ".xls");
//如果设置为 GetEncoding("GB2312");导出的文件将会出现乱码
page.Response.ContentEncoding = System.Text.Encoding.UTF7;
page.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);
gridData.RenderControl(oHtmlTextWriter);
page.Response.Output.Write(oStringWriter.ToString());
page.Response.Flush();
page.Response.End();
}
在需要导出Excel的页面代码上添加函数
/// <summary>
/// 导出表格到excel文件功能
/// </summary>
/// <param name="page">需要导出的页面</param>
/// <param name="gridData">要导出的数据表</param>
public static void ExportExcel(Page page, GridView gridData,string fileName)
{
page.Response.Clear();
page.Response.Buffer = true;
page.Response.Charset = "GB2312";
page.Response.AppendHeader("Content-Disposition", "attachment;filename=" + fileName + ".xls");
//如果设置为 GetEncoding("GB2312");导出的文件将会出现乱码
page.Response.ContentEncoding = System.Text.Encoding.UTF7;
page.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);
gridData.RenderControl(oHtmlTextWriter);
page.Response.Output.Write(oStringWriter.ToString());
page.Response.Flush();
page.Response.End();
}
在需要导出Excel的页面代码上添加函数
public override void VerifyRenderingInServerForm( Control control )
{ }
{ }
当用GridView导出Execl的时候,会发生只能在执行 Render() 的过程中调用 RegisterForEventValidation的错误提示。
有两种方法可以解决以上问题:
1.修改web.config(不推荐)<pages enableEventValidation ="false" ></pages>
2.直接在导出Execl的页面修改
<%@ Page Language="C#" EnableEventValidation = "false" AutoEventWireup="true"
CodeFile="ExportGridView.aspx.cs" Inherits="ExportGridView" %>
第二种方法:简洁方便 安全性更高(专家建议的)
有两种方法可以解决以上问题:
1.修改web.config(不推荐)<pages enableEventValidation ="false" ></pages>
2.直接在导出Execl的页面修改
<%@ Page Language="C#" EnableEventValidation = "false" AutoEventWireup="true"
CodeFile="ExportGridView.aspx.cs" Inherits="ExportGridView" %>
第二种方法:简洁方便 安全性更高(专家建议的)
第一步:添加函数VerifyRenderingInServerForm并改动HTML页面
第二步:添加代码:
protected void Button2_Click(object sender, EventArgs e)
{
Response.ContentType = "application/vnd.ms-excel";
Response.Charset = "";
this.EnableViewState = false;
System.IO.StringWriter sw = new System.IO.StringWriter();
System.Web.UI.HtmlTextWriter hw = new HtmlTextWriter(sw);
this.GridView1.RenderControl(hw);
Response.Write(sw.ToString());
Response.End();
}