前端导出excel表

导出excel表

<button @click="exportList">导出</button>

//导出
const exportList = () => {
  exportRoster();
};
const exportRoster = () => {
  let params = {
   //根据后端需要传参
  };
  http.watchList.exportRoster(params).then((res: any) => {
    ElMessage.success("导出成功");
    let data = res;
    let url = window.URL.createObjectURL(new Blob([data]));
    let link = document.createElement("a");
    link.style.display = "none";
    link.href = url;
    const name = new Date().getTime();
    link.setAttribute("download", "值班表" + ".xlsx"); // 需要文件名字
    document.body.appendChild(link);
    link.click();
    document.body.removeChild(link); //下载完成移除元素
    window.URL.revokeObjectURL(url); //释放掉blob对象
  });
};