json导出excel

最新推荐文章于 2025-03-23 10:00:00 发布

好事总会发生在下个转弯

最新推荐文章于 2025-03-23 10:00:00 发布

阅读量606

点赞数

分类专栏：功能文章标签： json

本文链接：https://blog.csdn.net/drawlessonsfrom/article/details/119910666

版权

功能专栏收录该内容

13 篇文章

订阅专栏

关键代码

 /*
 json导出
 @Parameter JSONData:json数组
 @Parameter FileName：导出文件名（不要后缀）
 @Parameter title：表头（数组，如['姓名', '年龄', '联系方式', '详细地址']）
 @Parameter filter
 */
 function jsonExcel(JSONData, FileName, title, filter) {
     if (!JSONData) return;
     //转化json为object
     var arrData = typeof JSONData != "object" ? JSON.parse(JSONData) : JSONData;
     var excel = "<table>";
     //设置表头
     var row = "<tr>";
     if (title) { //使用标题项
         for (var i in title) {
             row += "<th align='center'>" + title[i] + "</th>";
         }
     } else {//不使用标题项
         for (var i in arrData[0]) {
             row += "<th align='center'>" + i + "</th>";
         }
     }
     excel += row + "</tr>";
     //设置数据
     for (var i = 0; i < arrData.length; i++) {
         var row = "<tr>";
         for (var index in arrData[i]) {
             //判断是否有过滤行
             if (filter) {
                 if (filter.indexOf(index) == -1) {
                     var value = arrData[i][index] == null ? "" : arrData[i][index];
                     row += "<td>" + value + "</td>";
                 }
             } else {
                 var value = arrData[i][index] == null ? "" : arrData[i][index];
                 row += "<td align='center'>" + value + "</td>";
             }
         }
         excel += row + "</tr>";
     }
     excel += "</table>";
     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'>";
     excelFile +=
         '<meta http-equiv="content-type" content="application/vnd.ms-excel; charset=UTF-8">';
     excelFile +=
         '<meta http-equiv="content-type" content="application/vnd.ms-excel';
     excelFile += '; charset=UTF-8">';
     excelFile += "<head>";
     excelFile += "<!--[if gte mso 9]>";
     excelFile += "<xml>";
     excelFile += "<x:ExcelWorkbook>";
     excelFile += "<x:ExcelWorksheets>";
     excelFile += "<x:ExcelWorksheet>";
     excelFile += "<x:Name>";
     excelFile += "{worksheet}";
     excelFile += "</x:Name>";
     excelFile += "<x:WorksheetOptions>";
     excelFile += "<x:DisplayGridlines/>";
     excelFile += "</x:WorksheetOptions>";
     excelFile += "</x:ExcelWorksheet>";
     excelFile += "</x:ExcelWorksheets>";
     excelFile += "</x:ExcelWorkbook>";
     excelFile += "</xml>";
     excelFile += "<![endif]-->";
     excelFile += "</head>";
     excelFile += "<body>";
     excelFile += excel;
     excelFile += "</body>";
     excelFile += "</html>";
     var uri =
         "data:application/vnd.ms-excel;charset=utf-8," +
         encodeURIComponent(excelFile);
     var link = document.createElement("a");
     link.href = uri;
     link.style = "visibility:hidden";
     link.download = FileName + ".xls";
     document.body.appendChild(link);
     link.click();
     document.body.removeChild(link);
 }