通過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 }
