1.下包
npm install xlsx
yarn add xlsx
2.结构
<template><input type="file" @change="onFileChange" />
</template>
3.代码
<script>
import * as XLSX from 'xlsx'export default {methods: {onFileChange (event) {const file = event.target.files[0]const reader = new FileReader()reader.onload = (e) => {const data = e.target.resultconst fileType = file.name.split('.').pop().toLowerCase();if (fileType !== 'xls' && fileType !== 'xlsx' && fileType !== 'excel') {alert('请选择有效的xls、xlsx或Excel文件');return;}const workbook = XLSX.read(data, { type: 'binary' })workbook.SheetNames.forEach(sheetName => {const worksheet = workbook.Sheets[sheetName]const rows = XLSX.utils.sheet_to_json(worksheet, { header: 1 })console.log(`Sheet Name: ${sheetName}`)rows.forEach(row => {console.log(row, '每一行')})})}reader.readAsBinaryString(file)}}
}
</script>
4.结果