Skip to content

导出excel文件流

js
// 导出
export function downFpdkcxmx(params) {
    return request({
        url: '/fpgx/downFpdkcxmx',
        method: 'post',
        data: params,
        responseType: 'blob', // 注意!
    })
}
// 导出
export function downFpdkcxmx(params) {
    return request({
        url: '/fpgx/downFpdkcxmx',
        method: 'post',
        data: params,
        responseType: 'blob', // 注意!
    })
}
js
downFpdkcxmx(this.downLoadXLS_params).then((res) => {
    let fileName = ''
    let name = '增值税发票明细' // 文件名称
    fileName = name + '.xls' // 文件名称 + 文件后缀
    let blob = new Blob([res.data], {
        type: 'application/vnd.ms-excel;charset=utf-8'
    })
    let downloadElement = document.createElement('a')
    let href = window.URL.createObjectURL(blob) // 创建下载的链接
    downloadElement.href = href
    downloadElement.download = fileName // 下载后文件名
    document.body.appendChild(downloadElement)
    downloadElement.click() // 点击下载
    document.body.removeChild(downloadElement) // 下载完成移除元素
    window.URL.revokeObjectURL(href) // 释放掉blob对象
}).finally(() => {
    this.DownLoadExcel_loading = false // 其他操作
})
downFpdkcxmx(this.downLoadXLS_params).then((res) => {
    let fileName = ''
    let name = '增值税发票明细' // 文件名称
    fileName = name + '.xls' // 文件名称 + 文件后缀
    let blob = new Blob([res.data], {
        type: 'application/vnd.ms-excel;charset=utf-8'
    })
    let downloadElement = document.createElement('a')
    let href = window.URL.createObjectURL(blob) // 创建下载的链接
    downloadElement.href = href
    downloadElement.download = fileName // 下载后文件名
    document.body.appendChild(downloadElement)
    downloadElement.click() // 点击下载
    document.body.removeChild(downloadElement) // 下载完成移除元素
    window.URL.revokeObjectURL(href) // 释放掉blob对象
}).finally(() => {
    this.DownLoadExcel_loading = false // 其他操作
})

表单提交

有的后端要求使用FormData对象提交表单

js
const formData = new FormData()
formData.append('gfsbh', this.params.nsrsbh)
formData.append('ssq', this.params.skssq)
formData.append('fplx', '')
getDqsqtjxxmxdc(formData).then((res) => {
    let fileName = ''
    let name = '发票明细'
    fileName = name + '.xls'
    let blob = new Blob([res.data], {
        type: 'application/vnd.ms-excel;charset=utf-8'
    })
    let downloadElement = document.createElement('a')
    let href = window.URL.createObjectURL(blob) //创建下载的链接
    downloadElement.href = href
    downloadElement.download = fileName //下载后文件名
    document.body.appendChild(downloadElement)
    downloadElement.click() //点击下载
    document.body.removeChild(downloadElement) //下载完成移除元素
    window.URL.revokeObjectURL(href) //释放掉blob对象
}).finally(() => {
    this.xzfpmx_loading = false
})
const formData = new FormData()
formData.append('gfsbh', this.params.nsrsbh)
formData.append('ssq', this.params.skssq)
formData.append('fplx', '')
getDqsqtjxxmxdc(formData).then((res) => {
    let fileName = ''
    let name = '发票明细'
    fileName = name + '.xls'
    let blob = new Blob([res.data], {
        type: 'application/vnd.ms-excel;charset=utf-8'
    })
    let downloadElement = document.createElement('a')
    let href = window.URL.createObjectURL(blob) //创建下载的链接
    downloadElement.href = href
    downloadElement.download = fileName //下载后文件名
    document.body.appendChild(downloadElement)
    downloadElement.click() //点击下载
    document.body.removeChild(downloadElement) //下载完成移除元素
    window.URL.revokeObjectURL(href) //释放掉blob对象
}).finally(() => {
    this.xzfpmx_loading = false
})