1. <!DOCTYPE html>
    2. <html lang="en">
    3.   <head>
    4.     <meta charset="UTF-8" />
    5.     <meta http-equiv="X-UA-Compatible" content="IE=edge,chrome=1" />
    6.     <title>页面名称</title>
    7.   </head>
    8.   <body>
    9.     <textarea id="text" rows="30" cols="220"> </textarea><br />
    10.     <input type="button" value="统计" onclick="word();" /><br />
    11.     <script type="text/javascript">
    12.       var text = document.getElementById("text");
    13.       function word() {
    14.         var arr = text.value.match(/[\w\-]+/g) || [];
    15.         console.log(arr);
    16.         var k = {},
    17.           p = {};
    18.         for (var i = 0; i < arr.length; i++) {
    19.           var v = arr[i].toLowerCase();
    20.           if (k[v]) {
    21.             k[v]++;
    22.           } else {
    23.             k[v] = 1;
    24.           }
    25.         }
    26.         function sortObj(obj) {
    27.           var arr = [];
    28.           for (var i in obj) {
    29.             arr.push([obj[i], i]);
    30.           }
    31.           arr.sort(function (a, b) {
    32.             return b[0] - a[0];
    33.           });
    34.           var len = arr.length,
    35.             obj = {};
    36.           for (var i = 0; i < len; i++) {
    37.             obj[arr[i][1]] = arr[i][0];
    38.           }
    39.           return obj;
    40.         }
    41.         k = sortObj(k);
    43.         function f1(k) {
    44.           if (k == null) {
    45.             k = {};
    46.           }
    47.           var title = ["单词", "个数"];
    48.           console.log(k);
    49.           JSONToExcelConvertor(k, "report", title);
    50.         }
    51.         f1(k);
    52.       }
    53.     </script>
    54.     <script>
    55.       function JSONToExcelConvertor(JSONData, FileName, title, filter) {
    56.         if (!JSONData) return;
    57.         //转化json为object
    58.         var arrData = typeof JSONData != "object" ? JSON.parse(JSONData) : JSONData;
    60.         var excel = "<table>";
    62.         //设置表头
    63.         var row = "<tr>";
    65.         if (title) {
    66.           //使用标题项
    67.           for (var i in title) {
    68.             row += "<th align='center'>" + title[i] + "</th>";
    69.           }
    70.         } else {
    71.           //不使用标题项
    72.           for (var i in arrData[0]) {
    73.             row += "<th align='center'>" + i + "</th>";
    74.           }
    75.         }
    77.         excel += row + "</tr>";
    79.         var row = "";
    80.         for (var index in arrData) {
    81.           row += "<tr>";
    82.           row += "<td align='center'>" + index + "</td>";
    83.           row += "<td align='center'>" + arrData[index] + "</td>";
    84.           row += "</tr>";
    85.         }
    87.         excel += row;
    89.         excel += "</table>";
    90.         var excelFile = "<html xmlns:o='urn:schemas-microsoft-com:office:office' xmlns:x='urn:schemas-microsoft-com:office:excel' xmlns='http://www.w3.org/TR/REC-html40'>";
    91.         excelFile += '<meta http-equiv="content-type" content="application/vnd.ms-excel; charset=UTF-8">';
    92.         excelFile += '<meta http-equiv="content-type" content="application/vnd.ms-excel';
    93.         excelFile += '; charset=UTF-8">';
    94.         excelFile += "<head>";
    95.         excelFile += "<!--[if gte mso 9]>";
    96.         excelFile += "<xml>";
    97.         excelFile += "<x:ExcelWorkbook>";
    98.         excelFile += "<x:ExcelWorksheets>";
    99.         excelFile += "<x:ExcelWorksheet>";
    100.         excelFile += "<x:Name>";
    101.         excelFile += "{worksheet}";
    102.         excelFile += "</x:Name>";
    103.         excelFile += "<x:WorksheetOptions>";
    104.         excelFile += "<x:DisplayGridlines/>";
    105.         excelFile += "</x:WorksheetOptions>";
    106.         excelFile += "</x:ExcelWorksheet>";
    107.         excelFile += "</x:ExcelWorksheets>";
    108.         excelFile += "</x:ExcelWorkbook>";
    109.         excelFile += "</xml>";
    110.         excelFile += "<![endif]-->";
    111.         excelFile += "</head>";
    112.         excelFile += "<body>";
    113.         excelFile += excel;
    114.         excelFile += "</body>";
    115.         excelFile += "</html>";
    117.         var uri = "data:application/vnd.ms-excel;charset=utf-8," + encodeURIComponent(excelFile);
    119.         var link = document.createElement("a");
    120.         link.href = uri;
    122.         link.style = "visibility:hidden";
    123.         link.download = FileName + ".xls";
    124.         document.body.appendChild(link);
    125.         link.click();
    126.         document.body.removeChild(link);
    127.       }
    128.     </script>
    129.   </body>
    130. </html>

    image.png