C#HTML转EXCEL的方法

OStack程序员社区-中国程序员成长平台 › 门户 › 编程› Node.js›Node.js教程

原作者: [db:作者] 来自: [db:来源] 收藏邀请

 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);//HTML
36             Response.Flush();
37             Response.End();
38         }