js excel导出

  • SheetJS 官网下载 dist/xlsx.full.min.js文件
<!DOCTYPE html>
<html lang="en">
<head>
    <meta charset="UTF-8">
    <title>Title</title>
    <script src="js/xlsx.full.min.js">  //引用

</script>
<script>
   function downExcel(down_id) {
       // alert("开始");

        var elt = document.getElementById(down_id);
        var wb = XLSX.utils.table_to_book(elt, {sheet: "导入销售单商品"});
        //alert(wb.Sheets);
        return XLSX.writeFile(wb, '创建销售单.xlsx'); //   保存文件 }

</head>
<body>

<table border="1" id="down_table">
<tr >
    <th>商品</th>
    <th>Something</th>
  </tr>

  <tr style="height: 20px">

    <td id="td_1"><input oninput="inputS('td_1')"> </input></td>
    <td><input> </input></td>
  </tr>
  <tr id="tr_1 "style="height: 20px">

    <td id="td_2"><input oninput="inputS('td_2')"> </input></td>
    <td><input> </input></td>
  </tr>
</table>
<button id="excelOut" onclick="downExcel('down_table')">table导出Excel</a>

</body>
</html>

posted on 2019-07-07 19:11  游荡的鱼  阅读(628)  评论(0)  编辑  收藏  举报

导航