exexcl导出

把GridView数据导出到Eexcel中

private   void  Export( string  FileType,  string  FileName,GridView TempGrid)
    {
        Response.Charset  =   " GB2312 " ;
         //  如果设置为 GetEncoding("GB2312");导出的文件将会出现乱码！！！
        Response.ContentEncoding  =  System.Text.Encoding.UTF7;
        Response.AppendHeader( " Content-Disposition " ,  " attachment;filename= "   +  HttpUtility.UrlEncode(FileName, Encoding.UTF8).ToString());
         // 设置输出文件类型为excel文件。
        Response.ContentType  =  FileType;
         this .EnableViewState  =   false ;

        System.IO.StringWriter tw  =   new  System.IO.StringWriter();
        System.Web.UI.HtmlTextWriter hw  =   new  HtmlTextWriter(tw);

        TempGrid.RenderControl(hw);
        Response.Write(tw.ToString());
        Response.End();

    }

// 调用方法:
// gvPeoField为GridView
Export( " application/ms-excel " ,  " execl.xls " , gvPeoField);

详细请访问:

http://blog.csdn.net/bat800/archive/2007/07/17/1694537.aspx