在UpdatePanel中，导出为Excel格式，解决办法汇总。

 

ion = "false" AutoEventWireup="true" CodeFile="testExport.aspx.cs" Inherits="Test_testExport" Title="Untitled Page" %>
<asp:Content ID="Content1" ContentPlaceHolderID="ContentPlaceHolder1" Runat="Server">

   <asp:ScriptManager ID="ScriptManager1" runat="server">
       </asp:ScriptManager>
    <asp:UpdatePanel ID="UpdatePanel1" runat="server">
    <Triggers >
         <asp:PostBackTrigger ControlID ="Button1" />
    </Triggers>
        <ContentTemplate>
            <asp:Button ID="Button1" runat="server" OnClick="Button1_Click" Text="Button" />
        </ContentTemplate>
    </asp:UpdatePanel>
 

</asp:Content>

CS代码：

    protected void Button1_Click(object sender, EventArgs e)
    {
        string xlsname;

        xlsname = Server.MapPath("~").ToString() + @"\Orders\UpLoad\" + "6BReport.xls";
        DataSet ds = Report.B6OrderStatus_Activities_Item_excel(BaseFun.NullToDate(System .DateTime .Now .ToShortDateString ()), BaseFun.NullToDate(System .DateTime .Now .ToShortDateString ()));
        XlsHelper.DataTableToExcel(ds.Tables[0], xlsname, "6BReport", true);
    }