element-ui导出表格

安装依赖

npm install --save xlsx file-saver

需要的组件内引入

import FileSaver from "file-saver";import XLSX from "xlsx";

js

//导出表格   
 exportExcel () {        
  /* generate workbook object from table */         
  var wb = XLSX.utils.table_to_book(document.querySelector('#exportExcel'))        
   /* get binary string as output */         
   var wbout = XLSX.write(wb, { bookType: 'xlsx', bookSST: true, type: 'array' })         
   try {            
    FileSaver.saveAs(new Blob([wbout], { 
    type: 'application/octet-stream' 
    }), 'OrderList.xlsx')         } 
    catch (e) { if (typeof console !== 'undefined') console.log(e, wbout) }        
     return wbout     }

exportExcel( 放入的是table 的DOM 节点 ) ，OrderList.xlsx 即为导出表格的名字，可修改！

原文

https://blog.csdn.net/u010427666/article/details/79208145