前端导出Excel

前端导出Excel

1、首先下载：query-string

cnpm i --save-dev query-string
或者
npm i --save-dev query-string

2、引入

import queryString from 'query-string'

3、代码中应用：

import { requestPath } from '@/utils/global.js'
import queryString from 'query-string'

exportFile() { //导出会员
    //筛选条件：
    this.searchQuery.ids = getSelectionIds(this.chooiceList).join(',')
    this.searchQuery.name = this.listQuery.name
    this.searchQuery.isbn = this.listQuery.isbn
    this.searchQuery.beginTime = this.listQuery.beginTime
    this.searchQuery.endTime = this.listQuery.endTime
    let {...params} = this.searchQuery
    let tempParams = {}
    //处理条件参数：
    for (const key in params) {
        if (({}).hasOwnProperty.call(params, key) && params[key]!== null && params[key]!== '' && params[key]!== undefined) {
            tempParams[key] = params[key]
        }
    }
    let paramStr = queryString.stringify(tempParams)
    if(this.chooiceList.length > 0) {
        if(paramStr) { //导出选中的一条或多条数据
            confirm.apply(this,['确认导出选中的数据吗?']).then(() => {
                window.open(`${process.env.VUE_APP_URL}${requestPath.member}/p-member/export?${paramStr}`)
            })
        }
    } else { //导出全部数据
        if(paramStr) {
            confirm.apply(this,['确认导出全部数据吗?']).then(() => {
                window.open(`${process.env.VUE_APP_URL}${requestPath.member}/p-member/export?${paramStr}`)
            });
        }
    }
},