<input type="file" onChange="excelChange(this)">
var persons = [];
function excelChange(e) {
var files = e.files
var fileReader = new FileReader();
fileReader.onload = function(ev) {
console.log(ev);
var data = ev.target.result
var workbook = XLSX.read(data, {
type: 'binary'
})
var fromTo = '';
// 遍历每张表读取
for (var sheet in workbook.Sheets) {
if (workbook.Sheets.hasOwnProperty(sheet)) {
fromTo = workbook.Sheets[sheet]['!ref'];
persons = persons.concat(XLSX.utils.sheet_to_json(workbook.Sheets[sheet], {
defval: ''
}));
//break; // 如果只取第一张表,就取消注释这行
}
}
};
// 以二进制方式打开文件
fileReader.readAsBinaryString(files[0]);
}