<el-upload :action="url" :http-request="importExcel" list-type="text" :show-file-list="false" >
<el-button size="small" type="primary">导入</el-button>
</el-upload>
import XLSX from 'xlsx' // 需要引入 XLSX
importExcel (content) {
const file = content.file
// let file = file.files[0] // 使用传统的input方法需要加上这一步
const types = file.name.split('.')[1]
const fileType = ['xlsx', 'xlc', 'xlm', 'xls', 'xlt', 'xlw', 'csv'].some(item => item === types)
if (!fileType) {
this.$message('格式错误!请重新选择')
return
}
this.file2Xce(file).then(tabJson => {
if (tabJson && tabJson.length > 0) {
this.xlsxJson = tabJson
this.fileList = this.xlsxJson[0].sheet
let n = '匹配的字段'
this.fileList.forEach((item, index, arr) => {
if (item[n] === this.name) {
this.dataForm.projectno = item['XXXX'] // 需要的值的表头
}
})
}
})
},
file2Xce (file) {
return new Promise(function (resolve, reject) {
const reader = new FileReader()
reader.onload = function (e) {
const data = e.target.result
this.wb = XLSX.read(data, {
type: 'binary'
})
const result = []
this.wb.SheetNames.forEach((sheetName) => {
result.push({
sheetName: sheetName,
sheet: XLSX.utils.sheet_to_json(this.wb.Sheets[sheetName])
})
})
resolve(result)
}
// reader.readAsBinaryString(file.raw)
reader.readAsBinaryString(file) // 传统input方法
})
},
网友评论