vue 下载.xlsx文件

//下载.xlsx文件
responseType: 'blob',
export function exportFile(data, type, fileName) {
	const blob = new Blob([ data ], {
		// type类型后端返回来的数据中会有，根据自己实际进行修改
		// 表格下载为 application/xlsx，压缩包为 application/zip等，
		type: type
	})
	const filename = fileName
	if (typeof window.navigator.msSaveBlob !== 'undefined') {
		window.navigator.msSaveBlob(blob, filename)
	} else {
		var blobURL = window.URL.createObjectURL(blob)
		// 创建隐藏<a>标签进行下载
		var tempLink = document.createElement('a')
		tempLink.style.display = 'none'
		tempLink.href = blobURL
		tempLink.setAttribute('download', filename)
		if (typeof tempLink.download === 'undefined') {
			tempLink.setAttribute('target', '_blank')
		}
		document.body.appendChild(tempLink)
		tempLink.click()
		document.body.removeChild(tempLink) // 移除dom元素
		window.URL.revokeObjectURL(blobURL) // 释放bolb内存
	}
}

//不掉接口下载table
import FileSaver from 'file-saver'
import XLSX from 'xlsx'
 downLoadExcel(title, id) {
      const et = XLSX.utils.table_to_book(document.getElementById(`${id}`)) // 此处传入table的DOM节点
      const etout = XLSX.write(et, {
        bookType: 'xlsx',
        bookSST: true,
        type: 'array',
      })
      try {
        FileSaver.saveAs(
          new Blob([etout], {
            type: 'application/octet-stream',
          }),
          `${title}.xlsx`
        ) // trade-publish.xlsx 为导出的文件名
      } catch (e) {
        // console.log(e, etout);
      }
      return etout
    },