GridView表中数据导入excel文件中

步骤一：

页面设计代码添加 EnableEventValidation="false"

例：<%@ Page Language="C#" MasterPageFile="~/MasterPage.master" EnableEventValidation="false"
    AutoEventWireup="true" CodeFile="SalesList.aspx.cs" Inherits="StockAndSales_SalesList"
    Title="自定义" %>

步骤二：

页面添加导出按钮并编写点击按钮事件代码

    protected void Button1_Click(object sender, EventArgs e)
    {
        string filename = "门店单品销售排行.xls";//保存excel文件的文件名
        GridView1.AllowPaging = false; //清除分页
        GridView1.AllowSorting = false; //清除排序     
        datading();  //你绑定gridview1数据源的那个函数。
        Response.Clear();
        Response.Buffer = true;
        Response.AddHeader("content-disposition", "attachment;filename=" + HttpUtility.UrlEncode(filename, Encoding.UTF8));
        Response.AddHeader("Content-Type", "application/vnd.ms-excel; charset=UTF-8");
        Response.ContentEncoding = System.Text.Encoding.UTF8;
        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);
        GridView1.RenderControl(oHtmlTextWriter);
        Response.Output.Write(oStringWriter.ToString());
        Response.Flush();
        Response.End();
        GridView1.AllowSorting = true; //恢复分页         
        GridView1.AllowPaging = true;  //恢复排序
        datading(); //再次绑定
    }
    public override void VerifyRenderingInServerForm(Control control)
    {

    }