准备
安装
npm install xlsx --s
引入
import xlsx from "xlsx";
导入
<el-upload
action=""
:auto-upload="false"
accept=".xlsx, .xls"
:show-file-list="false"
:on-change="handleOnChange"
>
<el-button type="success" icon="el-icon-upload2"
>导入
</el-button>
</el-upload>
async handleOnChange(value) {
let reader = new FileReader();
let file = value.raw;
let excel = await new Promise((resolve) => {
reader.readAsBinaryString(file);
reader.onload = (ev) => {
resolve(ev.target.result);
};
});
const context = xlsx.read(excel, {
type: "binary" });
excel = xlsx.utils.sheet_to_json(context.Sheets[context.SheetNames[0]]);
console.log("excel", excel);
let arr =