vue调用后端接口导出excel文件

//导出excel文件
exportExcel() {
  applyOrderExportExcel(this.listQuery).then((res) => {
    const fileName = `${+new Date()}.xlsx`;
    const blob = new Blob([res], {type: 'application/vnd.ms-excel;charset=utf-8'});
    if (navigator.msSaveBlob) {
      navigator.msSaveBlob(blob, fileName);
    } else {
      const link = document.createElement('a');
      link.href = URL.createObjectURL(blob);
      link.download = fileName;
      link.click();
      URL.revokeObjectURL(link.href);
    }
  });
},

//申请单查询导出
export function applyOrderExportExcel(query) {
  return request({
    url:'/excel/applyOrderExportExcel',
    method:'POST',
    data:query,
    responseType:'blob'
  })
}

注：返回数据格式responseType:'blob'