GridView导出Excel文档

 

 protected void Button1_Click(object sender, EventArgs e)
    
{
        Response.Clear();
        Response.Buffer 
= true;
        Response.Charset 
= "GB2312";
        Response.AppendHeader(
"Content-Disposition""attachment;filename=FileName.xls");
        
// 如果设置为 GetEncoding("GB2312");导出的文件将会出现乱码!!!
        Response.ContentEncoding = System.Text.Encoding.UTF7;
        Response.ContentType 
= "application/ms-excel";//设置输出文件类型为excel文件。 
        System.IO.StringWriter oStringWriter = new System.IO.StringWriter();
        System.Web.UI.HtmlTextWriter oHtmlTextWriter 
= new System.Web.UI.HtmlTextWriter(oStringWriter);
        
this.GridView1.RenderControl(oHtmlTextWriter); 
        Response.Output.Write(oStringWriter.ToString());
        Response.Flush();
        Response.End();

    }

如果出现以下错误:

类型“GridView”的控件“GvList”必须放在具有 runat=server 的窗体标记内。

需要重载一个方法;
public override void VerifyRenderingInServerForm(Control control)
{
}
里面什么都不用写;

这样就OK了;

posted @ 2007-10-04 22:49    阅读(397)  评论(0编辑  收藏  举报