js excel下载

实现excel导出

// 导出代码写在一个公共方法中，引入到页面
import { exportExcel } from '@/utils/index'
// res是接口返回的文件流，第二个是文件名称，这里取的是列表文件名，要去掉后缀
exportExcel(res, row.fileName.replace(/\.xls(x)?/i, ''))

// 导出Excel、zip压缩文件
export const exportExcel = (res, name, loadtype) => {
  let blob = null
  if (loadtype !== '' && loadtype === 'zip') { // zip
    blob = new Blob([res], { type: 'application/zip' })
    const objectURL = URL.createObjectURL(blob)
    const downEle = document.createElement('a')
    downEle.href = objectURL
    downEle.setAttribute('download', `${name}.zip`)
    document.body.appendChild(downEle)
    downEle.click()
  } else { // Excel
    blob = new Blob([res], { type: 'application/vnd.ms-excel' })
    const objectURL = URL.createObjectURL(blob)
    const downEle = document.createElement('a')
    downEle.href = objectURL
    downEle.setAttribute('download', `${name}.xlsx`)
    document.body.appendChild(downEle)
    downEle.click()
  }
}