public static void ExcelOutProc( System.Data.DataTable dtData,string strFileName) { try { System.Web.UI.WebControls.GridView dgExport = null; System.Web.HttpContext curContext = System.Web.HttpContext.Current; System.IO.StringWriter strWriter = null; System.Web.UI.HtmlTextWriter htmlWriter = null; if (dtData != null) { System.Web.HttpContext.Current.Response.Clear(); System.Web.HttpContext.Current.Response.HeaderEncoding = System.Text.Encoding.GetEncoding("SHIFT-JIS"); curContext.Response.ContentType = "application/vnd.ms-excel"; curContext.Response.AppendHeader("Content-Disposition", "attachment;filename=" + strFileName + ".xls"); //curContext.Response.ContentEncoding = System.Text.Encoding.UTF8; curContext.Response.ContentEncoding = System.Text.Encoding.GetEncoding("SHIFT-JIS"); System.Web.HttpContext.Current.Response.ContentEncoding = System.Text.Encoding.Default; curContext.Response.Charset = ""; strWriter = new System.IO.StringWriter(); htmlWriter = new System.Web.UI.HtmlTextWriter(strWriter); dgExport = new System.Web.UI.WebControls.GridView(); dgExport.DataSource = dtData.DefaultView; dgExport.AllowPaging = false; dgExport.DataBind(); dgExport.RenderControl(htmlWriter); curContext.Response.Write(strWriter.ToString()); curContext.Response.Flush(); curContext.Response.Clear(); curContext.Response.Close(); curContext.Response.End(); } } catch (Exception ex) { throw ex; } }
C#将DataTable的数据下载到本地生成Excel方法
最新推荐文章于 2024-07-25 09:10:51 发布