XLSX.js 导出Excel 笔记

GitHub：https://github.com/SheetJS/js-xlsx

<script src="~/lib/xlsx/dist/xlsx.full.min.js"></script>


<h6>导出测试页面</h6>

<button onclick="ExportExcel()">导出xlsx</button>


<script>
    function ExportExcel() {
        var aoa = [
            ['姓名', '性别', '年龄', '注册时间'],
            ['张三', '男', 18, new Date()],
            ['李四', '女', 22, new Date()]
        ];

        //创建book
        var wb = XLSX.utils.book_new();
        var sheet = XLSX.utils.aoa_to_sheet(aoa);
        var timestamp = (new Date()).getTime();
        //sheet写入book
        XLSX.utils.book_append_sheet(wb, sheet, "file");
        //输出
        XLSX.writeFile(wb, "file" + timestamp + ".xlsx");
    }
</script>