将html导出到excel或word

weixin_34380296

于 2015-09-02 16:46:00 发布

116

原文链接：http://www.cnblogs.com/myboke/p/4778968.html

版权

本质是将html写成word或excel支持的html格式。

如何将html写成word或excel支持的格式？

只需打开计算机上任意一个word或excel文档，打开文件->另存为，选择文件类型为“*.htm,*.html”格式，即将一篇word转化为html格式文件。

在浏览器中打开该文件，查看源码，即可看到转化后的html文档。

只需参照此文档内容，将html写成该格式，然后将html内容写入到文件中，把文件后缀名改为“.xls”或“.doc”即可。

  1 using System;
  2 using System.Collections.Generic;
  3 using System.IO;
  4 using System.Linq;
  5 using System.Text;
  6 using System.Threading.Tasks;
  7 
  8 namespace ConsoleApplication1
  9 {
 10     class Program
 11     {
 12         /// <summary>
 13         /// 导出到excel
 14         /// </summary>
 15         /// <returns></returns>
 16         public static void exportExcel() {
 17          string HEADER = "<html xmlns:x=\"urn:schemas-microsoft-com:office:excel\">" +
 18                                           "<meta http-equiv=Content-Type content=\"text/html; charset=\"gb2312\">" +
 19                                           "<head>" +
 20                                           "<!--[if gte mso 9]><xml>" +
 21                                            "<x:ExcelWorkbook>" +
 22                                                "<x:ExcelWorksheets>" +
 23                                                    "<x:ExcelWorksheet>" +
 24                                                        "<x:Name>工作表标题</x:Name>" +
 25                                                        "<x:WorksheetOptions>" +
 26                                                            "<x:Print>" +
 27                                                                "<x:ValidPrinterInfo />" +
 28                                                            "</x:Print>" +
 29                                                        "</x:WorksheetOptions>" +
 30                                                    "</x:ExcelWorksheet>" +
 31                                                "</x:ExcelWorksheets>" +
 32                                            "</x:ExcelWorkbook>" +
 33                                        "</xml>" +
 34                                        "<![endif]-->" ;
 35 
 36          string STYLE="<style type=\"text/css\">" +
 37                                        ".spercent" +
 38                                        " {" +
 39                                        "   background-color:#ffff99;" +
 40                                        "   mso-number-format:0.00%;" +
 41                                        " }" +
 42                                         ".sId" +
 43                                        " {" +
 44                                        "   background-color:#ff6633;" +
 45                                        "   mso-number-format:0;" +
 46                                        " }" +
 47                                         ".sName" +
 48                                        " {" +
 49                                        "     color:red;" +
 50                                        " }" +
 51                                         ".sValue" +
 52                                        " {" +
 53                                        "   color:blue;" +
 54                                        "   mso-number-format:0;" +
 55                                        " }" +
 56                                        "</style>";
 57 
 58          using (StreamWriter writer = new StreamWriter(@"C:\Users\linghuam\Desktop\1111.xls", true, System.Text.Encoding.GetEncoding("gb2312"), 512))
 59          {
 60              writer.WriteLine(HEADER);
 61              writer.WriteLine(STYLE);
 62              writer.WriteLine("</head><body><table border=\"1\" style=\"font-size:9pt\"><tr>");
 63              writer.WriteLine("<th>ID</th>");
 64              writer.WriteLine("<th>Name</th>");
 65              writer.WriteLine("<th>Value</th>");
 66              writer.WriteLine("<th>Percent</th>");
 67 
 68              for (int row = 1; row < 50; row++)
 69              {
 70                  writer.WriteLine("<tr>");
 71                  writer.WriteLine("<td class=\"sId\">{0}</td>", row);
 72                  writer.WriteLine("<td class=\"sName\">{0}</td>", Guid.NewGuid().ToString());
 73                  writer.WriteLine("<td class=\"sValue\">{0}</td>", new Random().Next());
 74                  writer.WriteLine("<td class=\"spercent\">{0}</td>", new Random().NextDouble());
 75                  writer.WriteLine("</tr>");
 76              }
 77 
 78              writer.WriteLine("</table></body>");
 79          }
 80         }
 81         /// <summary>
 82         /// 导出到word
 83         /// </summary>
 84         /// <returns></returns>
 85 
 86         public static bool exportWord() {
 87             string html = "<html xmlns:v=\"urn:schemas-microsoft-com:vml\"xmlns:o=\"urn:schemas-microsoft-com:office:office\"xmlns:w=\"urn:schemas-microsoft-com:office:word\"xmlns:m=\"http://schemas.microsoft.com/office/2004/12/omml\"xmlns=\"http://www.w3.org/TR/REC-html40\"> <head> <![endif]><!--[if gte mso 9]><xml> <x:ExcelWorkbook> <x:ExcelWorksheets> <x:ExcelWorksheet> <x:Name>gis</x:Name> <x:WorksheetSource/> </x:ExcelWorksheet> </x:ExcelWorksheets> <x:ProtectStructure>False</x:ProtectStructure> <x:ProtectWindows>False</x:ProtectWindows> </x:ExcelWorkbook> </xml><![endif]--> <meta http-equiv=Content-Type content=\"text/html; charset=gb2312\"> <meta name=ProgId content=Word.Document> <meta name=Generator content=\"Microsoft Word 15\"> <meta name=Originator content=\"Microsoft Word 15\"> <style> div{background:rgba(255,0,0,0.5); } p{color: blue; font-size: 22px; font-weight: bolder; } h1{color: rgb(125,125,125); width: 100%; height: 100%; padding: 20px; background:rgb(66,89,224); } </style> </head> <body> <div> <p>I am chinese!</p> <h1>我发发非法上访</h1> </div> </body> </html>";
 88             using (StreamWriter writer = new StreamWriter(@"C:\Users\linghuam\Desktop\1111.doc", true, System.Text.Encoding.GetEncoding("gb2312"), 512))
 89             {
 90                 writer.WriteLine(html);
 91                 return true;
 92             }
 93             return false;
 94         }
 95         static void Main(string[] args)
 96         {
 97             exportExcel();
 98             exportWord();
 99         }
100     }
101 }

View Code

转载于:https://www.cnblogs.com/myboke/p/4778968.html

weixin_34380296

关注

0
点赞
踩
0

收藏
0
评论
将html导出到excel或word

本质是将html写成word或excel支持的html格式。如何将html写成word或excel支持的格式？只需打开计算机上任意一个word或excel文档，打开文件->另存为，选择文件类型为“*.htm,*.html”格式，即将一篇word转化为html格式文件。在浏览器中打开该文件，查看源码，即可看到转化后的html文档。只需参照此文档内容，将html写成该格式，然后将...
复制链接

扫一扫