js的excel文件导出

import axios from 'axios'
import moment from 'moment'

export function downloadExcel(method = 'get', data, name = '') {
  let baseURL = 'https://XXXX' // 域名
  const token = sessionStorage.getItem('token')
  const params = {
    method: method,
    headers: { 'token': token },
    responseType: 'blob',
  }
  let url = '/api/detail/export' // 接口路径
  if(method === 'get') {
    params.url = url + '?' + Object.keys(data).map(i => `${i}=${(data[i]||'')}`).join('&')
  } else {
    params.data = data
  }
  const newDate = moment().format('YYYY-MM-DD HH:mm:ss')
  axios(params).then((res) => {
    // 可以更改导出文件格式
    const blob = new Blob([res.data], { type: res.headers['application/vnd.ms-excel'] })
    const link = document.createElement('a')
    link.href = window.URL.createObjectURL(blob)
    // 下载文件的名称及文件类型后缀
    link.download = name + '_' + newDate + '.xlsx'
    document.body.appendChild(link)
    link.click()
    // 在资源下载完成后 清除 占用的缓存资源
    window.URL.revokeObjectURL(link.href)
    document.body.removeChild(link)
  })
}