yuanMM
/
html


			
				
					
						
						
							1234567891011121314151617181920212223242526272829303132333435363738394041424344454647484950515253
							<!DOCTYPE html>
<html>

<head>
    <meta charset='utf-8'>
    <title>JS-XLSX Demo</title>
    <script src="xlsx.full.min.js"></script>
</head>

<body>

    <p>使用JS导出Excel表，将JS中定义的数组、json的内容导入到一个Excel文件中</p>
    <p>
        <button onclick="exportData()">导出Excel</button>
    </p>

    <script type="text/javascript">
        function exportData() {

            var data = [{
                "name": "John",
                "city": "Seattle"
            }, {
                "name": "Mike",
                "city": "Los Angeles"
            }, {
                "name": "Zach",
                "city": "New York"
            }];

            downloadXls(data)
        }

        function downloadXls(data) {
            // Excel文件名称
            var filename = "导出json案例.xlsx";

            //相关连接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

            /* 创建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, filename);
        }
    </script>
</body>

</html>