前端JSON轉excel下載

方法一

let jsonData = [{id: "1",grade: "大二",}, {id: "1",grade: "大二",name: "Mike"}];var str = 'Id,年紀,姓名\n';for (let i = 0; i < jsonData.length; i++) {for (let item in jsonData[i]) {str += `${jsonData[i][item] + '\t,'}`;}console.log(str);str = str + '\n';};// toLargerCSV(jsonData) { if ('download' in document.createElement('a')) { // 非IE下載 var blob = new Blob([str], {type: "text/plain;charset=utf-8"});//解決中文亂碼問題blob = new Blob([String.fromCharCode(0xFEFF), blob], {type: blob.type});var object_url = window.URL.createObjectURL(blob);var link = document.createElement("a");link.href = object_url;link.download = "數據列表.xls";document.body.appendChild(link);link.click();URL.revokeObjectURL(link.href); // 釋放URL 對象document.body.removeChild(link);} else { // IE10+下載 var blob = new Blob([str], {type: "text/plain;charset=utf-8"});//解決中文亂碼問題blob = new Blob([String.fromCharCode(0xFEFF), blob], {type: blob.type});const fileName = '數據列表.xls';navigator.msSaveBlob(blob, fileName);}}

方法二

npm install -save js-export-excel const ExportJsonExcel = require('js-export-excel')

或

<script src="https://cuikangjie.github.io/JsonExportExcel/dist/JsonExportExcel.min.js"></script> <script>function getExcel(){var option={};option.fileName = 'excel'option.datas=[{sheetData:[//后端返回的數據表格json數據{name:'lili',age:'18'},{name:'mary',age:'20'}],sheetHeader:['姓名','年齡'],//前端指定的表頭sheetName: 'sheet',sheetFilter: ['name', 'age']},{sheetData:[//表格2的內容{name:'lili',grade:'90'},{name:'mary',grade:'99'}],sheetHeader:['姓名','成績']}];var toExcel=new ExportJsonExcel(option);toExcel.saveExcel();} </script>

總結

以上是生活随笔為你收集整理的前端JSON转excel下载的全部內容，希望文章能夠幫你解決所遇到的問題。

如果覺得生活随笔網站內容還不錯，歡迎將生活随笔推薦給好友。