前端实现导出excel 功能

脱了壳的小乌龟

于 2024-06-21 09:46:43 发布

阅读量170

点赞数 1

文章标签：前端 excel javascript

本文链接：https://blog.csdn.net/lyx1838102537/article/details/139852152

版权

import request from 'axios'
export function exportMethod(data){
    return request({
        method:data.method,
        url:`${data.url}`,
        responseType:'blob',
        params: data.param
    }).then(res=>{
        const link = document.createElement('a')
        const blob = new Blob([res.data],{type: 'application/vnd.ms-excel'})
        link.style.display = 'none'
        link.href = URL.createObjectURL(blob)
        const fileName = res.headers['content-disposition'].split('=')[1]
        link.download = decodeURIComponent(fileName)
        doucument.body.appendChild(link)
        link.click()
        document.body.removeChild(link)
    }).catch(err=>{
        console.log(err)
    })
}
get_full_url(url){
    const baseURL = process.env.BASE_API
    if(url.startsWith('/')){
        url = '/'+url
    }
    return baseURL + url
}

// 使用方法
exportExcel(){
    const url = this.get_full_url('api/exportExcel')
    this.exportMethod({
        url:url,
        method:'get',
        param:{
            name:'张三',
            age:18
        }
    })
}