通过向页面写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 }