js中json转excel

1.利用xlsx插件

var arrData = json.excel_lists;
var data= [];
//js对象转为数组
for (var i in arrData) {
    var item = [];
    for (var j in arrData[i]) item.push(arrData[i][j]);
    data.push(item)
}
/* Render data to table */
var ws = XLSX.utils.aoa_to_sheet(data);
var wb=XLSX.utils.book_new();
wb.SheetNames.push("{=date('Ymd')}");
wb.Sheets["{=date('Ymd')}"] = ws;
return  XLSX.writeFile(wb, 'test_{=date('YmdHis')}.xlsx');

相关文章：
PHP配合SheetJS/js-xlsx导出Excel大量