Excel导出

最新推荐文章于 2024-07-19 10:47:34 发布

不tu头ing

最新推荐文章于 2024-07-19 10:47:34 发布

阅读量24

点赞数

文章标签： excel javascript 开发语言

本文链接：https://blog.csdn.net/weixin_57791080/article/details/129829953

版权

elcel导出

export const exportExcel = (response, name = '') => {
  let names = name;
  const blob = new Blob([response], { type: 'application/vnd.ms-excel;charset=utf-8'}); // 不加格式貌似也行
  const link = document.createElement('a')
  link.href = window.URL.createObjectURL(blob);
  // console.log(blob,name)
  // 获取文件名
  // let content_disposition = response.headers['content-disposition'];
  if (names === '' && content_disposition == undefined) names = `下载文件${Date.now()}`;
  let disposition = '';
  if (names) disposition = names;
  else disposition = response.headers['content-disposition'];
  if (disposition !== undefined) {
    if (names) link.download = decodeURI(disposition + '.xlsx');
    else link.download = decodeURI(disposition.substring(disposition.indexOf('=') + 2, disposition.length - 1));
    link.click()
  }
  window.URL.revokeObjectURL(link.href);
}
//新建一个js文件，放进去就可