ajax下导出excel的解决办法(转载)

AJAX下EXCEL不能按原来的方式导出,因为在异步方式下Response.write是会出错的,所有在页面加载的时候可以将导出按钮注册为同步方式,同时在UpdatePanel里不能注册导出按钮,即可解决该问题。【对于VS自带的ajax此办法即可解决,网上找了N久,很多都是第三方ajax(非vs自带的)导出excel的解决办法,好不容易才找到此办法】

C#代码:

protected void Page_Load(object sender, EventArgs e)

{

        PostBackTrigger trigger = new PostBackTrigger();

        trigger.ControlID = "btn_export";

        ((UpdatePanel)Page.Controls[0].FindControl("UpdatePanel1")).Triggers.Add(trigger);

}   

 

//重载VerifyRenderingInServerForm方法,否则运行的时候会出现如下错误提示:“类型“GridView”的控件“GridView1”必须放在具有 runat=server 的窗体标记内
    public override void VerifyRenderingInServerForm(Control control)
    {
        //override VerifyRenderingInServerForm.
    }

 

前台代码:

<asp:UpdatePanel ID="UpdatePanel1" runat="server">

         <ContentTemplate>

                   <span style="color: #000000; font-family: 宋体">

                    <asp:Button ID="btn_export" runat="server" Text="导出" CssClass="button100" Width="80px" OnClick="Button6_Click"/></span>

                    <asp:GridView ID="gv_oil" runat="server"

                    CellPadding="4" ForeColor="#333333" GridLines="None" Width="100%">

                   <FooterStyle BackColor="#507CD1" Font-Bold="True" ForeColor="White" />

                    <RowStyle BackColor="#EFF3FB" />

                    <PagerStyle BackColor="#2461BF" ForeColor="White" HorizontalAlign="Center" />

                    <SelectedRowStyle BackColor="#D1DDF1" Font-Bold="True" ForeColor="#333333" />

                     <HeaderStyle BackColor="#507CD1" Font-Bold="True" ForeColor="White" />

                     <EditRowStyle BackColor="#2461BF" />

                      <AlternatingRowStyle BackColor="White" />

                      </asp:GridView>

          </ContentTemplate>

           <Triggers>

           </Triggers>

</asp:UpdatePanel

原文地址:https://www.cnblogs.com/zsuxiong/p/1953053.html