vue_table导出excel

vue直接导出对应table

const exportClick = () => {
  const wb = XLSX.utils.table_to_book(document.querySelector('#newTables'))// 关联dom节点
  
  /* get binary string as output */
  const wbout = XLSX.write(wb, {
    bookType: 'xlsx',
    bookSST: true,
    type: 'array',
  })
  try {
    FileSaver.saveAs(new Blob([wbout], {
      type: 'application/octet-stream',
    }), '库存.xlsx')
  }
  catch (e) {
    // eslint-disable-next-line max-statements-per-line, no-console
    if (typeof console !== 'undefined') { console.log(e, wbout) }
  }
  return wbout
}

• 需要引入的依赖：

import * as XLSX from "xlsx"
import FileSaver from 'file-saver'