js——excel导出

//res是返回的值，name是文件名
export const exportExcelFile = (res = {}, name) => {
  const blob = new Blob([res], {
    type: 'application/octet-stream'
  }); // , { type: 'application/vnd.openxmlformats-officedocument.spreadsheetml.sheet;charset=utf-8' }
  const downloadElement = document.createElement('a');
  const href = window.URL.createObjectURL(blob);
  downloadElement.href = href;
  // cms start 兼容ie
  downloadElement.download = name + formatdate(new Date()).replace(/:/g, '-') + '.xls'; // 文件名（自己随意设置）
  document.body.appendChild(downloadElement);
  if (!!window.ActiveXObject || 'ActiveXObject' in window) {
    window.navigator.msSaveOrOpenBlob(blob, downloadElement.download);
  } else {
    downloadElement.click();
  }
  // cms end
  document.body.removeChild(downloadElement); // 下载完成移除元素
  window.URL.revokeObjectURL(href);
};

使用：

export const exportNotificationFeedback = params => {

return axios({url: `http://********`,method: 'get',params: params,responseType: 'blob'   //必传});

};

async downOemNoRead() {

await exportNotificationFeedback(params).then(res => {

exportExcelFile(res.data, '车厂未读列表.xls');

});

},