通过向页面写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 }
【推荐】编程新体验,更懂你的AI,立即体验豆包MarsCode编程助手
【推荐】凌霞软件回馈社区,博客园 & 1Panel & Halo 联合会员上线
【推荐】抖音旗下AI助手豆包,你的智能百科全书,全免费不限次数
【推荐】轻量又高性能的 SSH 工具 IShell:AI 加持,快人一步