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 ????????}HTML转EXCEL的方法
原文地址：https://www.cnblogs.com/maja/p/10231347.html