HTML转EXCEL的方法 -云博客

HTML转EXCEL的方法

# 前端 2024-05-05 15:33 0 45 来源：云博客

 1 private void ToExcel(string html) 2  { 3  4 Response.ContentType = "application/force-download"; 5 Response.AddHeader("content-disposition", 6 "attachment; filename=" + DateTime.Now.ToString("yyyyMMddHHmmss") + ".xls"); 7 Response.Write("<html xmlns:x=\"urn:schemas-microsoft-com:office:excel\">"); 8 Response.Write("<head>"); 9 Response.Write("<META http-equiv=\"Content-Type\" content=\"text/html; charset=utf-8\">");10 string fileCss = Server.MapPath("~/UI/themes/DRP.UI.Ext.css");11 string cssText = string.Empty;12 StreamReader sr = new StreamReader(fileCss);13 var line = string.Empty;14 while ((line = sr.ReadLine()) != null)15  {16 cssText += line;17  }18  sr.Close();19 Response.Write("<style>" + cssText + "</style>");20 Response.Write("<!--[if gte mso 9]><xml>");21 Response.Write("<x:ExcelWorkbook>");22 Response.Write("<x:ExcelWorksheets>");23 Response.Write("<x:ExcelWorksheet>");24 Response.Write("<x:Name>Report Data</x:Name>");25 Response.Write("<x:WorksheetOptions>");26 Response.Write("<x:Print>");27 Response.Write("<x:ValidPrinterInfo/>");28 Response.Write("</x:Print>");29 Response.Write("</x:WorksheetOptions>");30 Response.Write("</x:ExcelWorksheet>");31 Response.Write("</x:ExcelWorksheets>");32 Response.Write("</x:ExcelWorkbook>");33 Response.Write("</xml>");34 Response.Write("<![endif]--> ");35 Response.Write(html);//HTML36  Response.Flush();37  Response.End();38 }