asp.net 導出Excel

分享一個asp.net 導出假Excel代碼。優點，不用借助于任何插件比如（NPOI）,復制代碼，修改grid.DataSource直接導出。

先看導出后的效果圖

 1 System.Web.UI.WebControls.DataGrid grid = new DataGrid();
 2                 grid.CellSpacing = 6;
 3                 grid.CellPadding = 6;
 4                 grid.EnableViewState = false;
 5                 grid.DataSource = tableCars;
 6                 grid.DataBind();
 7                 foreach (DataGridColumn clos in grid.Columns)
 8                 {
 9                     clos.HeaderStyle.Width = 200;
10                     clos.ItemStyle.Width = 200;
11                 }
12                 System.IO.StringWriter tw = new System.IO.StringWriter();
13                 HtmlTextWriter hw = new HtmlTextWriter(tw);
14                 grid.RenderControl(hw);
15                 string fileName = System.Web.HttpUtility.UrlEncode(DateTime.Now.ToString("yyyyMMddHHmmss") + ".xls", System.Text.Encoding.UTF8);
16                 HttpContext.Current.Response.Charset = "utf-8";
17                 HttpContext.Current.Response.ContentEncoding = System.Text.Encoding.UTF8;
18                 HttpContext.Current.Response.ContentType = "application/ms-excel";
19                 HttpContext.Current.Response.AppendHeader("Content-Disposition", "attachment;filename=" + fileName);
20                 HttpContext.Current.Response.Write(tw.ToString());
21                 HttpContext.Current.Response.End();

View Code

posted on 2016-03-16 15:26?無影飛絮劍閱讀(...) 評論(...) 編輯收藏

轉載于:https://www.cnblogs.com/itslives-com/p/DownExcel.html

本文來自互聯網用戶投稿，該文觀點僅代表作者本人，不代表本站立場。本站僅提供信息存儲空間服務，不擁有所有權，不承擔相關法律責任。
如若轉載，請注明出處：http://www.pswp.cn/news/374994.shtml
繁體地址，請注明出處：http://hk.pswp.cn/news/374994.shtml
英文地址，請注明出處：http://en.pswp.cn/news/374994.shtml

如若內容造成侵權/違法違規/事實不符，請聯系多彩編程網進行投訴反饋email:809451989@qq.com，一經查實，立即刪除！