将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)    {

    }