最简单实用的GridView导出到Excel表格代码

    protected void btnExcel_Click(object sender, EventArgs e)
        {
            if (Session["strWhere"] == null)
            {
                MessageBox.Show(this, "请先查询，再导出EXCEL");
                return;
            }
            gvHYXF.DataSource = (object)bll.BindData(Session["strWhere"].ToString());  //为GridView绑定数据
            gvHYXF.DataBind();
            DataGrid n = new DataGrid();
            DataSet dsn = new DataSet();

            dsn = ChangeC(bll.BindData(Session["strWhere"].ToString()), gvHYXF);
            this.DataGridToExcel(n, dsn);
        }

    protected void btnExcel_Click(object sender