国产探花免费观看_亚洲丰满少妇自慰呻吟_97日韩有码在线_资源在线日韩欧美_一区二区精品毛片,辰东完美世界有声小说,欢乐颂第一季,yy玄幻小说排行榜完本

首頁 > 編程 > JavaScript > 正文

vue + element-ui實現(xiàn)簡潔的導入導出功能

2019-11-19 14:40:06
字體:
供稿:網(wǎng)友

前言

眾所周知,ElementUI,是一個比較完善的UI庫,但是使用它需要有一點vue的基礎。在開始本文的正文之前,我們先來看看安裝的方法吧。

安裝ElementUI模塊

cnpm install element-ui -S

在main.js中引入

import ElementUI from 'element-ui'import 'element-ui/lib/theme-default/index.css'

全局安裝

Vue.use(ElementUI)

當我們安裝完記得重新運行,cnpm run dev ,現(xiàn)在就可以直接使用elementUI了。

vue + element-ui導入導出功能

1.前段后臺管理系統(tǒng)中數(shù)據(jù)展示一般都是用表格,表格會涉及到導入和導出;

2.導入是利用element-ui的Upload 上傳組件;

<el-upload class="upload-demo"  :action="importUrl"http://上傳的路徑  :name ="name"http://上傳的文件字段名  :headers="importHeaders"http://請求頭格式  :on-preview="handlePreview"http://可以通過 file.response 拿到服務端返回數(shù)據(jù)  :on-remove="handleRemove"http://文件移除  :before-upload="beforeUpload"http://上傳前配置  :on-error="uploadFail"http://上傳錯誤  :on-success="uploadSuccess"http://上傳成功  :file-list="fileList"http://上傳的文件列表  :with-credentials="withCredentials">//是否支持cookie信息發(fā)送</el-upload>

3.導出是利用file的一個對象blob;通過調(diào)用后臺接口拿到數(shù)據(jù),然后用數(shù)據(jù)來實例化blob,利用a標簽的href屬性鏈接到blob對象

 export const downloadTemplate = function (scheduleType) {  axios.get('/rest/schedule/template', {   params: {    "scheduleType": scheduleType   },   responseType: 'arraybuffer'  }).then((response) => {   //創(chuàng)建一個blob對象,file的一種   let blob = new Blob([response.data], { type: 'application/x-xls' })   let link = document.createElement('a')   link.href = window.URL.createObjectURL(blob)   //配置下載的文件名   link.download = fileNames[scheduleType] + '_' + response.headers.datestr + '.xls'   link.click()  }) }

4.貼上整個小demo的完整代碼,在后臺開發(fā)可以直接拿過去用(vue文件)

<template><div> <el-table ref="multipleTable" :data="tableData3" tooltip-effect="dark" border style="width: 80%" @selection-change="handleSelectionChange"> <el-table-column  type="selection"  width="55"> </el-table-column> <el-table-column  label="日期"  width="120">  <template slot-scope="scope">{{ scope.row.date }}</template> </el-table-column> <el-table-column  prop="name"  label="姓名"  width="120"> </el-table-column> <el-table-column  prop="address"  label="地址"  show-overflow-tooltip> </el-table-column> </el-table> <div style="margin-top: 20px"> <el-button @click="toggleSelection([tableData3[1], tableData3[2]])">切換第二、第三行的選中狀態(tài)</el-button> <el-button @click="toggleSelection()">取消選擇</el-button> <el-button type="primary" @click="importData">導入</el-button> <el-button type="primary" @click="outportData">導出</el-button> </div> <!-- 導入 --> <el-dialog title="導入" :visible.sync="dialogImportVisible" :modal-append-to-body="false" :close-on-click-modal="false" class="dialog-import">  <div :class="{'import-content': importFlag === 1, 'hide-dialog': importFlag !== 1}">  <el-upload class="upload-demo"  :action="importUrl"  :name ="name"  :headers="importHeaders"  :on-preview="handlePreview"  :on-remove="handleRemove"  :before-upload="beforeUpload"  :on-error="uploadFail"  :on-success="uploadSuccess"  :file-list="fileList"  :with-credentials="withCredentials">  <!-- 是否支持發(fā)送cookie信息 -->   <el-button size="small" type="primary" :disabled="processing">{{uploadTip}}</el-button>   <div slot="tip" class="el-upload__tip">只能上傳excel文件</div>  </el-upload>  <div class="download-template">   <a class="btn-download" @click="download">   <i class="icon-download"></i>下載模板</a>  </div>  </div>  <div :class="{'import-failure': importFlag === 2, 'hide-dialog': importFlag !== 2}" >  <div class="failure-tips">   <i class="el-icon-warning"></i>導入失敗</div>  <div class="failure-reason">   <h4>失敗原因</h4>   <ul>   <li v-for="(error,index) in errorResults" :key="index">第{{error.rowIdx + 1}}行,錯誤:{{error.column}},{{error.value}},{{error.errorInfo}}</li>   </ul>  </div>  </div> </el-dialog> <!-- 導出 --></div></template><script>import * as scheduleApi from '@/api/schedule'export default { data() { return {  tableData3: [  {   date: "2016-05-03",   name: "王小虎",   address: "上海市普陀區(qū)金沙江路 1518 弄"  },  {   date: "2016-05-02",   name: "王小虎",   address: "上海市普陀區(qū)金沙江路 1518 弄"  },  {   date: "2016-05-04",   name: "王小虎",   address: "上海市普陀區(qū)金沙江路 1518 弄"  },  {   date: "2016-05-01",   name: "王小虎",   address: "上海市普陀區(qū)金沙江路 1518 弄"  },  {   date: "2016-05-08",   name: "王小虎",   address: "上海市普陀區(qū)金沙江路 1518 弄"  },  {   date: "2016-05-06",   name: "王小虎",   address: "上海市普陀區(qū)金沙江路 1518 弄"  },  {   date: "2016-05-07",   name: "王小虎",   address: "上海市普陀區(qū)金沙江路 1518 弄"  }  ],  multipleSelection: [],  importUrl:'www.baidu.com',//后臺接口config.admin_url+'rest/schedule/import/'  importHeaders:{  enctype:'multipart/form-data',  cityCode:''  },  name: 'import',  fileList: [],  withCredentials: true,  processing: false,  uploadTip:'點擊上傳',  importFlag:1,  dialogImportVisible:false,  errorResults:[] }; }, methods: { toggleSelection(rows) {  if (rows) {  rows.forEach(row => {   this.$refs.multipleTable.toggleRowSelection(row);  });  } else {  this.$refs.multipleTable.clearSelection();  } }, handleSelectionChange(val) {  //復選框選擇回填函數(shù),val返回一整行的數(shù)據(jù)  this.multipleSelection = val; }, importData() {  this.importFlag = 1  this.fileList = []  this.uploadTip = '點擊上傳'  this.processing = false  this.dialogImportVisible = true }, outportData() {  scheduleApi.downloadTemplate() }, handlePreview(file) {  //可以通過 file.response 拿到服務端返回數(shù)據(jù) }, handleRemove(file, fileList) {  //文件移除 }, beforeUpload(file){  //上傳前配置  this.importHeaders.cityCode='上海'//可以配置請求頭  let excelfileExtend = ".xls,.xlsx"http://設置文件格式  let fileExtend = file.name.substring(file.name.lastIndexOf('.')).toLowerCase();  if (excelfileExtend.indexOf(fileExtend) <= -1) {   this.$message.error('文件格式錯誤')   return false  }  this.uploadTip = '正在處理中...'  this.processing = true }, //上傳錯誤 uploadFail(err, file, fileList) {  this.uploadTip = '點擊上傳'  this.processing = false  this.$message.error(err) }, //上傳成功 uploadSuccess(response, file, fileList) {  this.uploadTip = '點擊上傳'  this.processing = false  if (response.status === -1) {  this.errorResults = response.data  if (this.errorResults) {   this.importFlag = 2  } else {   this.dialogImportVisible = false   this.$message.error(response.errorMsg)  }  } else {  this.importFlag = 3  this.dialogImportVisible = false  this.$message.info('導入成功')  this.doSearch()  } }, //下載模板 download() {  //調(diào)用后臺模板方法,和導出類似  scheduleApi.downloadTemplate() }, }};</script><style scoped>.hide-dialog{ display:none;}</style>

5.js文件,調(diào)用接口

import axios from 'axios'// 下載模板 export const downloadTemplate = function (scheduleType) {  axios.get('/rest/schedule/template', {   params: {    "scheduleType": scheduleType   },   responseType: 'arraybuffer'  }).then((response) => {   //創(chuàng)建一個blob對象,file的一種   let blob = new Blob([response.data], { type: 'application/x-xls' })   let link = document.createElement('a')   link.href = window.URL.createObjectURL(blob)   link.download = fileNames[scheduleType] + '_' + response.headers.datestr + '.xls'   link.click()  }) }

總結(jié)

以上就是這篇文章的全部內(nèi)容了,希望本文的內(nèi)容對大家的學習或者工作具有一定的參考學習價值,如果有疑問大家可以留言交流,謝謝大家對武林網(wǎng)的支持。

發(fā)表評論 共有條評論
用戶名: 密碼:
驗證碼: 匿名發(fā)表
主站蜘蛛池模板: 甘孜| 兴宁市| 宁化县| 龙州县| 沙河市| 申扎县| 浦东新区| 文登市| 青州市| 定西市| 朝阳区| 交城县| 遵义县| 远安县| 黄骅市| 黔西县| 广宗县| 葫芦岛市| 岑溪市| 大方县| 施秉县| 长白| 宜丰县| 津市市| 和硕县| 于田县| 枣强县| 西安市| 延安市| 砀山县| 无锡市| 苍梧县| 黄大仙区| 都昌县| 石嘴山市| 奉节县| 腾冲县| 家居| 抚宁县| 隆尧县| 沐川县|