1.txt格式
// 导入
buttonUpload(file) {
let self = this
let reader = new FileReader()
reader.onload = () => {
if (reader.result) {
console.log(reader.result)
}
}
reader.readAsText(file)
},
2.excel
uploadText(file) {
let fileReader = new FileReader()
fileReader.onload = function (ev) {
let workbook
try {
let data = ev.target.result
workbook = XLSX.read(data, {
type: 'binary'
}) // 以二进制流方式读取得到整份excel表格对象
// persons = []; // 存储获取到的数据
} catch (e) {
console.log('文件类型不正确', e)
return
}
// 表格的表格范围,可用于判断表头是否数量是否正确
let fromTo = ''
// 遍历每张表读取
for (let sheet in workbook.Sheets) {
if (workbook.Sheets.hasOwnProperty(sheet)) {
fromTo = workbook.Sheets[sheet]['!ref']
console.log(fromTo)
persons = persons.concat(XLSX.utils.sheet_to_json(workbook.Sheets[sheet]))
// break; // 如果只取第一张表,就取消注释这行
}
}
console.log(persons)
}
fileReader.readAsBinaryString(file.raw)
},