如何将JavaScript JSON数据导出成Excel表格？

本文共计302个文字，预计阅读时间需要2分钟。

javascriptjson2excel.jsvar myjson={ 英文: English };var newExcArr=[];// 预处理个人的JSON数据，拼接成以下形式for (var k in myjson) { newArr=''; newHtml=''; newExcArr.push({ val: newArr + k + ' : ' + myjson[k] + '' });}

json2excel.js

var myjson = { "英文":"English", }; var newExcArr = []; //预处理个人的json数据 拼接成如下形式 for (var k in myjson) { newArr += '"' + k + '", ' newHtml += '' + k + ':"' + myjson[k] + '",
' newExcArr.push([ { "value": k, "type": "ROW_HEADER" }, { "value": myjson[k], "type": "ROW_HEADER" } ]); } var data = { "title": [ { "value": "中文", "type": "ROW_HEADER_HEADER", "datatype": "string" }, { "value": "英文", "type": "ROW_HEADER_HEADER", "datatype": "string" } ], "data": newExcArr }; //开始导出 JSONToExcelConvertor(data.data, "Report", data.title); function JSONToExcelConvertor(JSONData, FileName, ShowLabel) { //先转化json var arrData = typeof JSONData != 'object' ? JSON.parse(JSONData) : JSONData; var excel = ' '; //设置表头 var row = " "; for (var i = 0, l = ShowLabel.length; i < l; i++) { row += " " + ShowLabel[i].value + ''; } //换行 excel += row + " "; //设置数据 for (var i = 0; i < arrData.length; i++) { var row = " "; for (var index in arrData[i]) { var value = arrData[i][index].value === "." ? "" : arrData[i][index].value; row += ' ' + value + ''; } excel += row + " "; } excel += " "; var sheetName = "英文包"; // 生成sheet表格 var excelFile = ""; excelFile += ''; excelFile += ''; excelFile += ""; excelFile += " "; excelFile += ""; excelFile += ""; excelFile += excel; excelFile += ""; excelFile += ""; 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); }