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;
posted on 2013-11-07 17:44 tongdengquan 阅读(105) 评论(0) 编辑 收藏 举报