62,046
社区成员
发帖
与我相关
我的任务
分享
比如说导出的记录:
列1 列2 列3 列1 列2 列3
1 2 3 1 2 3
2 3 4 2 3 4
..................................
<asp:ScriptManager ID="ScriptManager1" runat="server">
</asp:ScriptManager>
<asp:UpdatePanel ID="UpdatePanel1" runat="server">
<ContentTemplate>
<asp:GridView ID="GridView1" runat="server" PageSize="10" PagerSettings-Visible="false" AllowPaging="true" CssClass="GridViewStyle" OnRowDataBound="GridView1_RowDataBound" AutoGenerateColumns="false">
</asp:GridView>
<asp:Button ID="ExportExcel" runat="server" CssClass="btnStyle" Text="导出Excel"
onclick="ExportExcel_Click" />
</ContentTemplate>
<Triggers>
<asp:PostBackTrigger ControlID="ExportExcel" />
</Triggers>
</asp:UpdatePanel>
protected void ExportExcel_Click(object sender, EventArgs e)
{
//在导出信息的时候,可以选择某些列将其隐藏,不导出。
// GridView1.Columns[8].Visible = false;
Response.Clear();
Response.Buffer = true;
Response.Charset = "GB2312";
Response.ContentEncoding = System.Text.Encoding.GetEncoding("GB2312");
Response.AppendHeader("Content-Disposition", "attachment;filename=" + HttpUtility.UrlEncode("SaleStatsReport.xls", Encoding.UTF8).ToString());
Response.ContentType = "application/ms-excel";
this.EnableViewState = false;
StringWriter tw = new StringWriter();
HtmlTextWriter hw = new HtmlTextWriter(tw);
//取消分页显示,全部导出记录信息
GridView1.AllowPaging = false;
GridView1.AutoGenerateColumns = false;
//重新绑定GridView
SelectBindGridView();
GridView1.RenderControl(hw);
Response.Output.Write(tw.ToString());
Response.Flush();
Response.End();
//恢复分页显示信息
GridView1.AllowPaging = true;
//重新绑定GridView
SelectBindGridView();
}
public override void VerifyRenderingInServerForm(Control control)
{
//base.VerifyRenderingInServerForm(control);
}