JS导出JSON到EXCEL文件

Convert JSON data to XLSX file

HTML

<script src="https://rawgit.com/eu81273/jsfiddle-console/master/console.js"></script>
<script src="https://cdnjs.cloudflare.com/ajax/libs/xlsx/0.13.1/xlsx.full.min.js"></script>
<button onclick="ExportData()">
  导出数据
</button>

JavaScript

function ExportData()
{
    //相关连接http://www.qinluo1023.com/2018/07/03/JS%E8%AF%BB%E5%8F%96%E6%9C%AC%E5%9C%B0EXCEL%E6%96%87%E4%BB%B6.html
    var data = https://www.yidaiyilu.gov.cn/js/SJ/data-json1.json

    /* 创建worksheet */
    var ws = XLSX.utils.json_to_sheet(data);

    /* 新建空workbook，然后加入worksheet */
    var wb = XLSX.utils.book_new();
    XLSX.utils.book_append_sheet(wb, ws, "People");
    
    /* 生成xlsx文件 */
    XLSX.writeFile(wb, "sheetjs.xlsx");
}