javascript 如何将 json 格式数组转为 excel 表格| sheetJS
案例
// https://unpkg.com/xlsx@0.18.5/dist/xlsx.full.min.js
function exportXlsx(jsonData, fileName = '', mine = null) {const workbook = XLSX.utils.book_new();// 将JSON数组转换成工作表const worksheet = XLSX.utils.json_to_sheet(jsonData);// 向工作簿添加工作表XLSX.utils.book_append_sheet(workbook, worksheet, 'Sheet1');fileName = !fileName? 'output': fileNamemine = typeof mine != 'string'? 'xlsx': mineXLSX.writeFile(workbook, [fileName, mine].join('.'));
}exportXlsx([{name: '张三', age: 13, sex: '男'}, {name: '李四', age: 14, sex: '女'}])
参考
- javascript 如何将 json 格式数组转为 excel 表格