1.引入XLSX
readXLSX(file) {
const nameSplit = file.name.split('.')
const format = nameSplit[nameSplit.length - 1]
if (!['xlsx', 'csv'].includes(format)) {
return false
}
return new Promise((resolve, reject) => {
const reader = new FileReader()
reader.readAsBinaryString(file)
reader.onload = evt => {
const data = evt.target.result // 读到的数据
const workbook = XLSX.read(data, { type: 'binary' })
const firstSheetName = workbook.SheetNames[0]
const worksheet = workbook.Sheets[firstSheetName]
const results = XLSX.utils.sheet_to_json(worksheet, {
header: 1,
blankrows: false,
defval: &#