js处理excel表格需要引入相应的js文件,在这里你可以下载。详细请看代码。或者下载xlsx模块,导入名称为XLSX
analyzeFile(file){
let reader = new FileReader();
reader.onload = (e) => {
/* Parse data */
let bstr = e.target.result;
let wb = XLSX.read(bstr, {
type: 'binary', cellDates: true});
/* Get first worksheet */
let wsname = wb.SheetNames[0];
let ws = wb.Sheets[wsname];
/* Convert array of arrays */
let data = XLSX.utils.sheet_to_json(ws, {
header: 1});
//this.importFileForm用来接收从excel读取到的对象数组
this.importFileForm = constructData(data);
}
reader.