概述
需要給頁面的table做一個數據導出功能,發現一個好用sheetjs工具,可以直接在頁面引入,官網的地址在這裡
<script src="https://cdn.sheetjs.com/xlsx-0.20.0/package/dist/xlsx.full.min.js"></script>
只需要簡單的js語法如下,就可以將table的數據導出來
function load(){
var date = new Date();
date.setTime(date.getTime() + (8 * 60 * 60 * 1000));
var table = document.getElementById("tab");
var worksheet = XLSX.utils.table_to_sheet(table);
var workbook = XLSX.utils.book_new();
XLSX.utils.book_append_sheet(workbook, worksheet, 'Sheet1');
XLSX.writeFile(workbook, 'output.xlsx');
}