实例详解javascript将json格式数组下载为excel表格-js教程-PHP中文网

实例详解javascript将json格式数组下载为excel表格

小云云

发布： 2017-12-23 13:52:33

原创

1569人浏览过

本文主要为大家分享一篇javascript将json格式数组下载为excel表格的方法，具有很好的参考价值，希望对大家有所帮助。一起跟随小编过来看看吧，希望能帮助到大家。

实例如下：

 
 
  <meta> 
  <script></script> 
  <script> 
    $(document).ready(function(){ 
      $(&#39;#wwo&#39;).click(function(){ 
        var data = {
"title":
[
{"value":"A1标题"}, 
{"value":"B1标题"}
],
"data":
[
[
{"value":"好好"}, 
{"value":"2015-08-24"}
],
[
{"value":"123"}, 
{"value":"hahah"}
]
]
}; 
        if(data == &#39;&#39;){ 
          return; 
}else{
JSONToExcelConvertor(data.data, "Report", data.title); 
}
      }); 
    }); 
 
    function JSONToExcelConvertor(JSONData, FileName, ShowLabel) { 
      //先转化json 
      var arrData = typeof JSONData != &#39;object&#39; ? JSON.parse(JSONData) : JSONData; 
       
      var excel = &#39;<table>&#39;;   
       
      //设置表头 
      var row = "<tr>"; 
      for (var i = 0, l = ShowLabel.length; i < l; i++) { 
        row += "<td>" + ShowLabel[i].value + &#39;&#39;; 
      } 
       
       
      //换行 
      excel += row + ""; 
       
      //设置数据 
      for (var i = 0; i < arrData.length; i++) { 
        var row = "<tr>"; 
         
        for (var index in arrData[i]) { 
          var value = arrData[i][index].value === "." ? "" : arrData[i][index].value; 
          row += &#39;<td>&#39; + value + &#39;&#39;; 
        } 
         
        excel += row + ""; 
      } 
 
      excel += ""; 
 
      var excelFile = "<html xmlns:o=&#39;urn:schemas-microsoft-com:office:office&#39; xmlns:x=&#39;urn:schemas-microsoft-com:office:excel&#39; xmlns=&#39;http://www.w3.org/TR/REC-html40&#39;>"; 
      excelFile += &#39;<meta http-equiv="content-type" content="application/vnd.ms-excel; charset=UTF-8">&#39;; 
      excelFile += &#39;<meta http-equiv="content-type" content="application/vnd.ms-excel&#39;; 
      excelFile += &#39;; charset=UTF-8">&#39;; 
      excelFile += "<head>"; 
      excelFile += "<!--[if gte mso 9]>"; 
      excelFile += "<xml>"; 
      excelFile += "<x:ExcelWorkbook>"; 
      excelFile += "<x:ExcelWorksheets>"; 
      excelFile += "<x:ExcelWorksheet>"; 
      excelFile += "<x:Name>"; 
      excelFile += "{worksheet}"; 
      excelFile += ""; 
      excelFile += "<x:WorksheetOptions>"; 
      excelFile += "<x:DisplayGridlines/>"; 
      excelFile += ""; 
      excelFile += ""; 
      excelFile += ""; 
      excelFile += ""; 
      excelFile += ""; 
      excelFile += "<![endif]-->"; 
      excelFile += ""; 
      excelFile += "<body>"; 
      excelFile += excel; 
      excelFile += ""; 
      excelFile += "</script>

登录后复制

以上就是实例详解javascript将json格式数组下载为excel表格的详细内容，更多请关注php中文网其它相关文章！