<script src="jquery-2.1.1.min.js" type="text/javascript"></script>//引入你的jqery
<script type="text/javascript" src="xlsx.full.min.js"></script>//引入你自己的xlsx.full
<input type="file" id="file"/>
<div id="car-list"></div>
<script>
// js读取解析Excel
// 定义一个carData,用来保存读取到的数据
var carData;
$(document).ready(function(){
var wb;//读取完成的数据
var rABS = false; //是否将文件读取为二进制字符串
function fixdata(data) { //文件流转BinaryString
var o = "",
l = 0,
w = 10240;
for(; l < data.byteLength / w; ++l) o += String.fromCharCode.apply(null, new Uint8Array(data.slice(l * w, l * w + w)));
o += String.fromCharCode.apply(null, new Uint8Array(data.slice(l * w)));
return o;
}
$("#file").change(function(){
if(!this.files) {
return;
}
var f = this.files[0];
var reader = new FileReader();
reader.onload = function(e) {
var data = e.target.result;
if(rABS) {
wb = XLSX.read(btoa(fixdata(data)),{
type: 'base64'
});
} else {
wb = XLSX.read(data,{
type: 'binary'
});
}
// carData就是我们需要的JSON数据
carData = XLSX.utils.sheet_to_json(wb.Sheets[wb.SheetNames[0]]); //接收的数据
var longzhanghao="";//登录账号
var longName="";//登录账号
for(var k=0;k<carData.length;k++){
longzhanghao=carData[k].登录账户;//登录账号
longName=carData[k].真实姓名;//登录账号
console.log(longzhanghao)
console.log(longName)
$.ajax({
url:"/system/dept/printIdByDeptName",
data:{"printName":carData[k].真实姓名}
,dataType:"json"
, contentType : "application/json"//上传内容格式为json结构
, async: false
,success:function (res){
$.ajax({
url:"/system/user/add",
contentType : "application/json",//上传内容格式为json结构
data:JSON.stringify({"deptId":res,"loginName":longzhanghao,"userName":longName,"password":"123456","phonenumber":"","email":"","sex":"","status":"0","roleIds":[101],"postIds":[4]})
,type:"POST"
,dataType:"json"
, async: false
,success:function (res) {
console.log(res);
console.log("添加成功")
},error:function (res) {
console.log("出现错误");
}
})
},error:function(res){
console.log("出现错误")
return ;
}
})
}
}
if(rABS) {
reader.readAsArrayBuffer(f);
} else {
reader.readAsBinaryString(f);
}
})
});