将gridview的数据导入excel

//导入Excel事件
    protected void but_DRExcel_ServerClick(object sender, EventArgs e)
    {
            // 当前对话
           System.Web.HttpContext curContext = System.Web.HttpContext.Current;
           // IO用于导出并返回excel文件
           System.IO.StringWriter strWriter = null;
           System.Web.UI.HtmlTextWriter htmlWriter = null;

           if (gdv_jiaoFei != null)
           {
               // 设置编码和附件格式
               curContext.Response.ContentType = "application/vnd.ms-excel";
               curContext.Response.ContentEncoding =System.Text.Encoding.UTF8;
               curContext.Response.Charset = ""; //显示的字符串格式
             //Response.AppendHeader("Content-Disposition", "attachment;filename=FileName.xls");
               
               // 导出excel文件
               strWriter = new System.IO.StringWriter();
               htmlWriter = new System.Web.UI.HtmlTextWriter(strWriter);

               // 返回客户端    
               gdv_jiaoFei.RenderControl(htmlWriter);    
               //curContext.Response.Write(strWriter.ToString());
               if (GridView1 != null)
    
               {
                   GridView1.RenderControl(htmlWriter);  
               }
               curContext.Response.Write(strWriter.ToString());
               curContext.Response.End();
           }
    }

 

//下面重写方法必不可少
    public override void VerifyRenderingInServerForm(Control control)
    {

    }