BS导出Excel实例

 1、 public void GridViewToExcel(System.Web.UI.WebControls.GridView gv, string FileType, string FileName)
    {
        for (int i = 0; i < gv.Rows.Count; i++)
        {
            foreach (System.Web.UI.WebControls.TableCell tc in gv.Rows[i].Cells)
            {
                foreach (System.Web.UI.Control c in tc.Controls)
                {
                    if (c.GetType() == typeof(System.Web.UI.WebControls.TextBox))
                    {
                        tc.Controls.Clear();
                        tc.Text = ((System.Web.UI.WebControls.TextBox)c).Text;
                    }
                }
            }
        }
        System.Web.HttpContext.Current.Response.Charset = "utf-8";
        System.Web.HttpContext.Current.Response.ContentEncoding = System.Text.Encoding.UTF8;
        System.Web.HttpContext.Current.Response.AppendHeader("Content-Disposition", "attachment;filename="
            + System.Web.HttpUtility.UrlEncode(FileName, System.Text.Encoding.UTF8).ToString());
        System.Web.HttpContext.Current.Response.ContentType = FileType;
        //this.EnableViewState = false;
        System.IO.StringWriter tw = new System.IO.StringWriter();
        System.Web.UI.HtmlTextWriter hw = new System.Web.UI.HtmlTextWriter(tw);
        gv.RenderControl(hw);
        System.Web.HttpContext.Current.Response.Write(tw.ToString());
        System.Web.HttpContext.Current.Response.End();
    }
    public override void VerifyRenderingInServerForm(Control control) { }

 

用法：GridViewToExcel(GridView1, "application/ms-Excel", "文件名.xls");

 

2、 public void ToExcel(System.Web.UI.Control ctl) 
  {
   HttpContext.Current.Response.AppendHeader("Content-Disposition","attachment;filename=Excel.xls");
   HttpContext.Current.Response.Charset ="UTF-8";   
   HttpContext.Current.Response.ContentEncoding =System.Text.Encoding.Default;
   HttpContext.Current.Response.ContentType ="application/ms-excel";//image/JPEG;text/HTML;image/GIF;vnd.ms-excel/msword
   ctl.Page.EnableViewState =false;  
   System.IO.StringWriter  tw = new System.IO.StringWriter() ;
   System.Web.UI.HtmlTextWriter hw = new System.Web.UI.HtmlTextWriter (tw);
   ctl.RenderControl(hw);
   HttpContext.Current.Response.Write(tw.ToString());
   HttpContext.Current.Response.End();
  }

 

用法：ToExcel(GridView1);

 

3、  private static void ExportToExcel(GridView gvw,string title)
    {
      string fileName;
      HttpContext.Current.Response.Buffer = true;
      HttpContext.Current.Response.ClearContent();
      HttpContext.Current.Response.ClearHeaders();
      fileName = string.Format("Export-File {0:yyyy-MM-dd_HH_mm}.xls", DateTime.Now);
      HttpContext.Current.Response.AppendHeader("Content-Disposition", "attachment;filename=" + fileName);
      HttpContext.Current.Response.ContentType = "application/vnd.ms-excel";
      System.IO.StringWriter tw = new System.IO.StringWriter();
      System.Web.UI.HtmlTextWriter hw = new System.Web.UI.HtmlTextWriter(tw);
      gvw.RenderControl(hw);
      if (!string.IsNullOrEmpty(title))
      {
        HttpContext.Current.Response.Write("<b><center><font size=3 face=Verdana color=#0000FF>" +title +"</font></center></b>");
      }
      HttpContext.Current.Response.Write(tw.ToString());
      HttpContext.Current.Response.Flush();
      HttpContext.Current.Response.Close();
      HttpContext.Current.Response.End();

      gvw.Dispose();
      tw.Dispose();
      hw.Dispose();
     
      gvw = null;
      tw = null;
      hw = null;

    }

 

用法：ExportToExcel(GridView1, "bgfd");