js 将json数据转成excel

最新推荐文章于 2024-07-24 17:11:47 发布

生命难溶恐惧

最新推荐文章于 2024-07-24 17:11:47 发布

阅读量2.2k

点赞数

文章标签： js excel json

本文链接：https://blog.csdn.net/qq_38399909/article/details/94619146

版权

调用方式（需·引入·jquery）

var th=["th1","th2","th3"];
 //调用方法
 function download(){
 JSONToExcelConvertor({
 	 jsonData:dataJson,
 	 fileName:"测试",
 	 th:th,
 	 

 });

函数源码：
function JSONToExcelConvertor(options)
          var defaults = {
                    fileName:'myexcel',
                     jsonData:[],

                };
var options = $.extend(defaults,options);
        //json
        var arrData = typeof options.jsonData != 'object' ? JSON.parse(c) :     options.jsonData;
   // #region 拼接数据
        var excel = '<table>';
        //设置表头
        var row = "<tr>";
        var tableth=arrData[0];
        if(!options.th)
        {
        for (var name in tableth) {
            //每个单元格都可以指定样式. eg color:red   生成出来的就是 红色的字体了.
            row += "<td style='color:red;text-align:center;'>" + name + '</td>';
        }
        }
     else{
           //自定义表头
        tableth=options.th;
         for (var name in tableth) {
            //每个单元格都可以指定样式. eg color:red   生成出来的就是 红色的字体了.
            row += "<td style='color:red;text-align:center;'>" + tableth[name] + '</td>';
        }

          }
        //列头结束
        excel += row + "</tr>";

        //设置数据
        for (var i = 0; i < arrData.length; i++) {

            var row = "<tr>";
            for (var index in arrData[i]) {

                var value = arrData[i][index] === "." ? "" : arrData[i][index];

                row += '<td style="text-align:center;">' + value + '</td>';//将值放入td
            }
            //将td 放入tr,将tr放入table
            excel += row + "</tr>";
        }
        //table结束
        excel += "</table>";

        // #endregion


        // #region 拼接html

        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;//将table 拼接
        excelFile += "</body>";
        excelFile += "</html>";

        // #endregion

        var uri = 'data:application/vnd.ms-excel;charset=utf-8,' + encodeURIComponent(excelFile);

        //创建a标签
        var link = document.createElement("a");
        //指定url
        link.href = uri;
        //设置为隐藏
        link.style = "visibility:hidden";
        //指定文件名和文件后缀格式
        link.download = options.fileName + ".xls";
        //追加a标签
        document.body.appendChild(link);
        //触发点击事件
        link.click();
        //移除a标签
        document.body.removeChild(link);
    }

生命难溶恐惧

关注

0
点赞
踩
2

收藏

觉得还不错? 一键收藏
0
评论
js 将json数据转成excel

调用方式（需·引入·jquery）var th=[“th1”,“th2”,“th3”];//调用方法function download(){JSONToExcelConvertor({jsonData:dataJson,fileName:“测试”,th:th,});函数源码：function JSONToExcelConvertor(options) {///json转exc...
复制链接

扫一扫