导出Data数据到execle表

/// <summary> /// 导出数据到execle表 /// </summary> /// <param name="dt"></param> private void DownLoad(System.Data.DataTable dt,int shopID) { if (dt == null || dt.Rows.Count < 1) { Sun_sjy.JavaScript.Alert("请先查询数据！"); return; } System.Text.StringBuilder sb = new System.Text.StringBuilder(); System.IO.StringWriter sw = new System.IO.StringWriter(sb); System.Web.UI.HtmlTextWriter htw = new System.Web.UI.HtmlTextWriter(sw); System.Web.UI.Page page = new System.Web.UI.Page(); System.Web.UI.HtmlControls.HtmlForm form = new System.Web.UI.HtmlControls.HtmlForm(); System.Web.UI.WebControls.GridView grvExport = new GridView(); grvExport.DataSource = dt.DefaultView; grvExport.DataBind(); grvExport.AllowPaging = false; grvExport.EnableViewState = false; page.EnableEventValidation = false; page.DesignerInitialize(); page.Controls.Add(form); form.Controls.Add(grvExport); page.RenderControl(htw); System.Web.HttpContext.Current.Response.Clear(); System.Web.HttpContext.Current.Response.Buffer = true; System.Web.HttpContext.Current.Response.ContentType = "application/vnd.ms-excel"; System.Web.HttpContext.Current.Response.AddHeader("Content-Disposition", string.Format("attachment;filename=userinfo_{0}_{1}.xls",shopID, DateTime.Now.ToString("yyyy-MM-dd"))); System.Web.HttpContext.Current.Response.Charset = "UTF-8"; System.Web.HttpContext.Current.Response.ContentEncoding = System.Text.Encoding.UTF8; System.Web.HttpContext.Current.Response.Write(sb.ToString()); System.Web.HttpContext.Current.Response.End(); htw.Close(); sw.Close(); }