导出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
})