导出到Excel导出整个网页，而不仅仅是网格视图(已启用排序)

本文关键字：视图 启用 排序 网格 Excel 网页 不仅仅是 | 更新日期: 2023-09-27 18:21:28

在我的C#应用程序中，我根据用户的输入生成一个Gridview，然后我必须给用户一个将Gridview导出到excel表的选项。

这是我的abc.aspx页面：

    <body>
    <form id="form1" runat="server">
        <div>
            <b>Enter p1 :</b>
            <asp:TextBox ID="tb_P1" runat="server" />
            <br />
            <b>Enter p2 :</b>
            <asp:TextBox ID="tb_P2" runat="server" /><br />

            <asp:Button ID="btn1" runat="server" OnClick="Button1_Click" Text="Start Search" ClientIDMode="Static" />
           <asp:Button ID="btn2" runat="server" OnClick="Button2_Click" Text="Export Data to Excel" />
            <hr />
                    <asp:GridView ID="GridView1" runat="server" AutoGenerateColumns="true"
                        ShowFooter="false"
                       AllowSorting="true"
                        OnSorting="GridView1_Sorting"
                        EnableViewState="false"
                       ShowHeaderWhenEmpty="True"
                        AllowPaging="false">
                        <RowStyle Wrap="false" />
                        <HeaderStyle Wrap="false" />
                    </asp:GridView>    
        </div>
    </form>
    <br />  
</body>

这是我的.cs页面：

using System;
using System.Collections.Generic;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Data.SqlClient;
using System.Data;
using System.Web.Script.Services;
using System.Configuration;
using System.Drawing;
using System.Windows.Forms;
using System.ComponentModel;
using System.IO;
public partial class pSearch : System.Web.UI.Page
{
    SqlConnection sqlconn = new SqlConnection(System.Configuration.ConfigurationManager.ConnectionStrings["DBConnectionString"].ConnectionString);
    DataSet dsldata;
    protected void Page_Load(object sender, EventArgs e)
    {
    }
    protected void Button2_Click(object sender, EventArgs e)
    {
        string fname = filename.Text;

        GridView1.DataSource = (DataSet)Session["data"];
        GridView1.DataBind();
        int rowCount = GridView1.Rows.Count;
        if (rowCount == 0)
        {
            Response.Write("<script>alert('Result Empty!');</script>");
        }
        else
        {
                ExportToExcel(GridView1, fname);
        }
    }

    private void ExportToExcel(GridView GrdView, string fname)
    {
        try
        {
            Response.AddHeader("contentdisposition", "attachment;filename=test1.xls");
            Response.Charset = "";
            Response.ContentType = "application/vnd.xls";
            System.IO.StringWriter stringWrite = new System.IO.StringWriter();
            System.Web.UI.HtmlTextWriter htmlWrite = new System.Web.UI.HtmlTextWriter(stringWrite);
            GrdView.RenderControl(htmlWrite);
            Response.Write(stringWrite.ToString());
            Response.End();
        }
        catch (Exception ex)
        {
            Response.Write("<script>alert('" + ex.Message + "')</script>");
        }
    }
    public override void VerifyRenderingInServerForm(System.Web.UI.Control control)
    {
    }

    protected void Button1_Click(object sender, EventArgs e)
    {
        string Rname= Page.Request.QueryString["rname"];
        string typeofquery = "my command";
        string abc = null;
       abc = "" + typeofquery + " @RName='" + RName "'";
        SqlDataAdapter cmdldata = new SqlDataAdapter(abc, sqlconn);
        cmdldata.SelectCommand.CommandTimeout = 600;
        dsldata = new DataSet();
        try
        {
            cmdldata.Fill(dsldata);
            Session["data"] = dsldata;
            GridView1.DataSource = dsldata;
            GridView1.DataBind();
        }//end of try
        catch (Exception ex)
        {
            Response.Write(ex);
        }//end of catch
    }
    private const string ASCENDING = " ASC";
    private const string DESCENDING = " DESC";

    public SortDirection GridViewSortDirection
    {
        get
        {
            if (ViewState["sortDirection"] == null)
                ViewState["sortDirection"] = SortDirection.Ascending;
            return (SortDirection)ViewState["sortDirection"];
        }
        set { ViewState["sortDirection"] = value; }
    }

    protected void GridView1_Sorting(object sender, GridViewSortEventArgs e)
    {
        string sortExpression = e.SortExpression;
        if (GridViewSortDirection == SortDirection.Ascending)
        {
            GridViewSortDirection = SortDirection.Descending;
            SortGridView(sortExpression, DESCENDING);
        }
        else
        {
            GridViewSortDirection = SortDirection.Ascending;
            SortGridView(sortExpression, ASCENDING);
        }
    }
    private void SortGridView(string sortExpression, string direction)
    {
        dsldata = (DataSet)HttpContext.Current.Session["data"];
        DataTable dt = dsldata.Tables[0];
        DataView dv = new DataView(dt);
        dv.Sort = sortExpression + direction;
        dt = dv.ToTable();
        DataSet ds1 = new DataSet("table");
        ds1.Tables.Add(dt);
        Session["data"] = ds1;
        GridView1.DataSource = dv;
        GridView1.DataBind();
    }
}

我在网格视图中启用了排序。问题是：我的整个网页都被导出到excel表格中。我只想导出我的网格视图。排序工作正常，我确实在excel表中得到了新的排序表，但它与整个网页一致。我在互联网上的不同地方寻找解决方案。似乎很多人都面临过这个问题。我也尝试过他们的解决方案，比如更改Response.ContentType="application/vnd.xls"；至
Response.ContentType="application/vnd.ms-excel"；其他大多数解决方案都类似于我的ExportToExcel（）函数。

从过去两天起，我一直在为这件事而苦恼，但我的申请什么都不起作用。

请帮忙！提前谢谢！

更改了我的ExporttoExcel函数

private void ExportToExcel(GridView GrdView, string fname)
{
try
{
    Response.Clear();
    Response.AddHeader("content-disposition", "attachment;filename=" + fname + ".xls");
    Response.Charset = "";
    Response.ContentType = "application/vnd.ms-excel";
    StringWriter stringWrite = new StringWriter();
    HtmlTextWriter htmlWrite = new HtmlTextWriter(stringWrite);
    GridView1.RenderControl(htmlWrite);
    Response.Write(stringWrite.ToString());
    Response.End();
}
catch (Exception ex)
{
    Response.Write("<script>alert('" + ex.Message + "')</script>");
}
}

导出到Excel导出整个网页，而不仅仅是网格视图(已启用排序)

我已经解决了这个问题。我意识到问题出在我的网格视图的AllowSorting功能中。我关闭了该页面的事件验证。

<%@ Page Language="C#" AutoEventWireup="true" CodeFile="abc.aspx.cs" Inherits="abc" EnableEventValidation = "false" %>

成功了！

我认为您需要在Export ToExcel()函数的顶部使用Response.Clear()。

相关文章：