<!DOCTYPE html>
<html>
<head>
<meta charset="UTF-8">
<title></title>
<script src="js/xlsx.full.min.js"></script>
</head>
<body>
<input type="file" onchange="importf(this)" />
<!--<div id="demo"></div>-->
<textarea name="" id="demo" cols="30" rows="10"></textarea>
<script src="js/jquery-1.12.4.min.js"></script>
<script>
var wb;//读取完成的数据
var rABS = true; //是否将文件读取为二进制字符串
function importf(obj) {//导入
console.log("test",obj);
if(!obj.files) {
return;
}
if (typeof FileReader == "undefined") {
console.log("您的浏览器不支持FileReader");
} else {
console.log("您的浏览器支持FileReader");
}
var f = obj.files[0];
var reader = new FileReader();
reader.readAsArrayBuffer(f);
reader.onload = function(e) {
console.log("sss ",e);
var data = e.target.result;
console.log(11);
console.log(data);
if(rABS) {
wb = XLSX.read(btoa(fixdata(data)), {//手动转化
type: 'base64'
});
} else {
wb = XLSX.read(data, {
type: 'binary'
});
}
//wb.SheetNames[0]是获取Sheets中第一个Sheet的名字
//wb.Sheets[Sheet名]获取第一个Sheet的数据
document.getElementById("demo").value=JSON.stringify(XLSX.utils.sheet_to_json(wb.Sheets[wb.SheetNames[0]] ));
console.log(XLSX.utils.sheet_to_json(wb.Sheets[wb.SheetNames[0]] ));
};
if(rABS) {
// reader.readAsArrayBuffer(f);
} else {
reader.readAsBinaryString(f);
}
}
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;
}
// function objToArray(array) {
// var arr = [];
// for (var i in array) {
// arr.push(array[i]);
// }
// return arr;
// }
// if (!FileReader.prototype.readAsBinaryString) {
// FileReader.prototype.readAsBinaryString = function (fileData) {
// var binary = "";
// var pt = this;
// var reader = new FileReader();
// reader.onload = function (e) {
// var bytes = new Uint8Array(reader.result);
// var length = bytes.byteLength;
// for (var i = 0; i < length; i++) {
// binary += String.fromCharCode(bytes[i]);
// }
// //pt.result - readonly so assign binary
// pt.content = binary;
// $(pt).trigger('onload');
// }
// reader.readAsArrayBuffer(fileData);
// }
// }
</script>
</body>
</html>