Gridview导出成Excel

在aspx里面加上

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

重载一个方法

public override void VerifyRenderingInServerForm(Control control)

{

//这个必不可少

}

//先隐藏一些列

GridView_AdvancePaymentChange.AllowPaging = false;

bindData();

GridView_AdvancePaymentChange.Columns[0].Visible = false;

DateTime dt = System.DateTime.Now;

string str = dt.ToString("yyyyMMddhhmmss");

str = "预付款调整表" + str + ".xls";

Response.ClearContent();

Response.AppendHeader("Content-Disposition", "attachment;filename=" + HttpUtility.UrlEncode(str, Encoding.UTF8).ToString());

Response.ContentType = "application/excel";

StringWriter sw = new StringWriter();

HtmlTextWriter htw = new HtmlTextWriter(sw);

GridView_AdvancePaymentChange.RenderControl(htw);

Response.Write(sw.ToString());

Response.End();

GridView_AdvancePaymentChange.AllowPaging = true;

巴特西

Gridview导出成Excel

最新文章

热门文章