导入,导出

<el-button type="primary" @click="exportData">

      <svg-icon class="svg-icon-btn" icon-class="asset_export_excel" />

      导出

    </el-button>

 

 

 

 

import download from '@/base/utils/download'

// 导出

    exportData() {

      const formInline = this.$refs.TableArea.formInline

      exportData(formInline).then(res => {

        download(res, '单位会计科目')

      })

    }

 

download.js

/**

 * @default 导出

 */

import { parseTime } from './index'

export default function download(response, name) {

  const blob = new Blob([response], { type: 'application/vnd.ms-excel;charset=utf-8' })

  const downloadElement = document.createElement('a')

  const href = window.URL.createObjectURL(blob)

  downloadElement.href = href

  downloadElement.download = name + parseTime(+new Date()) + '.xls'

  document.body.appendChild(downloadElement)

  downloadElement.click()

  document.body.removeChild(downloadElement)

  window.URL.revokeObjectURL(href)

}

 

 

 

<ImportFile

      :file-name="'财政会计科目'"

      :http-url="'http://39.104.108.253:9909/account/importData'"

      :is-import="false"

      @refresh="refreshEvent"

    />

 

 

ImportFile组件

<el-upload

      v-if="isOutput && !isChoice"

      action=""

      :http-request="importOutitem"

      :show-file-list="false"

      :file-list="fileList"

      :limit="1"

      accept=".xlsx"

      style="display: inline-block; margin:0 10px;"

      @on-exceed="fileExceed"

    >

      <el-button type="primary" :loading="loading"><svg-icon class="svg-icon-btn" icon-class="Import" />{{ buttonText }}</el-button>

    </el-upload>

 

importOutitem(val) {

      this.loading = true

      const form = new FormData()

      form.append('fileName', val.file)

      request({

        url: this.isChoice ? `/${this.httpUrl}/${this.intRemind}` : `${this.httpUrl}`,

        method: 'post',

        data: form,

        timeout: Infinity,

        'Content-Type': 'multipart/form-data'

      }).then(res => {

        if (res.code === 20000) {

          const temp = {}

          const arr = []

          for (var p in res.data.columnlist) {

            if (p === 'strreason') {

              temp.label = res.data.columnlist[p]

              temp.prop = p

            } else {

              arr.push({

                label: res.data.columnlist[p],

                prop: p

              })

            }

          }

          this.head = arr.sort((a, b) => { return a.prop.match(/\d+/g) - b.prop.match(/\d+/g) })

          this.head.unshift(temp)

          this.list = res.data.importtemplatelist

          this.dialog.isShow = true

          this.$emit('refresh')

        }

        this.loading = false

        this.fileList = []

      }).catch(err => {

        this.loading = false

        console.log('catch ' + err) // catch error

        this.fileList = []

      })

    }

 

 

 

//普通的导入

<el-upload

      action=""

      :http-request="uploadFile"

      :show-file-list="false"

      accept="application/vnd.openxmlformats-officedocument.spreadsheetml.sheet,application/vnd.ms-excel"

    >

      <el-button type="primary" :loading="importLoading"><svg-icon class="svg-icon-btn" icon-class="Import" />导入</el-button>

    </el-upload>

 

 

//  导入数据

    uploadFile(item) {

      this.importLoading = true

      const form = new FormData()

      form.append('file', item.file)

      importAccount(form).then(res => {

        this.importLoading = false

        if (res.code === 20000) {

          this.$message.success(res.message)

        }

        this.refreshEvent()

      })

    }