一、xlsx文件
二、代码实现
HTML:
<van-uploader
:before-read="beforeUpload"
:accept="'application/vnd.ms-excel, application/vnd.openxmlformats-officedocument.spreadsheetml.sheet'">
<van-button icon="plus" type="primary">上传文件</van-button>
</van-uploader>
JS:
beforeUpload(file) {
if (file.size / 1024 / 1024 > 5) {
this.$message({
message: '上传文件大于5M',
type: 'info'
})
return false
}
return new Promise((resolve, reject) => {
let reader = new FileReader()
reader.onload = r => {
let data = r.target.result
let workbook = XLSX.read(data, { type: 'binary' })
let worksheet = workbook.Sheets[workbook.SheetNames[0]]
let excelData = XLSX.utils.sheet_to_json(worksheet, {
header: ['a', 'b', 'c', 'd', 'e', 'f', 'g', 'h']
})
excelData.shift()
console.log(excelData)
resolve()
}
reader.readAsBinaryString(file)
})
}