通過向頁面寫html代碼導出excel，html代碼導出excel
1 //excel文件名
2 string filename = "考勤匯總";
3 StringBuilder ExcelHtml = new StringBuilder();
4 ExcelHtml.Append("<table border='1' style='vnd.ms-excel.numberformat:@'>");
5 //拼接<tr><th></th></tr>第一行標題
6 //循環拼接<tr><td></td></tr>每一行的內容
7 ExcelHtml.Append("</table>");
8 DownloadExcelByTtml(ExcelHtml.ToString(), filename);
9
10
11 /// <summary>
12 /// 下載 Excel
13 /// </summary>
14 /// <param name="ExcelHtml"></param>
15 /// <param name="filename"></param>
16 /// <returns></returns>
17 public void DownloadExcelByTtml(string ExcelHtml, string filename)
18 {
19 Page p = HttpContext.Current.Handler as Page;
20 p.Response.Clear();
21 p.Response.Buffer = true;
22 p.Response.Charset = "UTF-8";
23 p.Response.AppendHeader("Content-Disposition", "attachment;filename=" + HttpUtility.UrlEncode(filename, Encoding.UTF8) + ".xls");
24 p.Response.ContentEncoding = Encoding.UTF8;
25 p.Response.ContentType = "application/vnd.ms-excel";
26 p.EnableViewState = false;
27 p.Response.Write("<html><head><meta http-equiv='Content-Type' content='application/vnd.ms-excel; charset=utf-8' /></head>" + ExcelHtml + "</html>");
28 p.Response.End();
29 }
