<!DOCTYPE html>
<html>
<head>
<meta charset="UTF-8">
<title>JavaScript解析并遍历Excel示例</title>
<script src="xlsx.full.min.js"></script>
</head>
<body>
<input type="file" onchange="getExcel(this);" accept=".xls,.xlsx" />
<script>
//使用插件 https://github.com/SheetJS/js-xlsx
var excelData;//读取完成的数据
function getExcel(obj) {//导入
if(obj.files.length==0) {
return;
}
var reader = new FileReader();
reader.onload = function(e) {
var data = e.target.result;
excelData = XLSX.read(data, {
type: 'binary'
});
var List = XLSX.utils.sheet_to_json(excelData.Sheets[excelData.SheetNames[0]]);
for(var i=0;i<List.length;i++){
console.log(List[i]);
// console.log(List[i].姓名);
// console.log(List[i].账号);
//ajax 发起请求
}
alert("操作完成");
};
reader.readAsBinaryString(obj.files[0]);
}
</script>
</body>
</html>