js如何将读取excel文件内容
template.html
<html><head><meta http-equiv="Content-Type" content="text/html; charset=UTF-8"><title>JS-XLSX Live Demo</title><link href="../css/bootstrap.min.css" rel="stylesheet"><style>#drop{border:2px dashed #bbb;-moz-border-radius:5px;-webkit-border-radius:5px;border-radius:5px;padding:25px;text-align:center;font:20pt bold,"Vollkorn";color:#bbb}#b64data{width:100%;}a { text-decoration: none }button{}</style></head><body><pre><input type="file" name="xlfile" id="xlf"><button type="button" class="btn btn-danger"><a href="Techrecord.html">返回</a></button><input type="checkbox" name="useworker" checked="" style="display: none;"><input type="checkbox" name="xferable" checked="" style="display: none;"><input type="checkbox" name="userabs" checked="" style="display: none;"></pre><button class="submit_all">提交</button><pre id="out"></pre><br><script src="../js/jquery.js"></script><script src="../js/common.js"></script>//这里主要封装了一下方法，可以忽略，主要使用到以下几个js<script type="text/javascript" async="" src="http://www.google-/ga.js"></script><script src="../js/shim.js"></script><script src="../js/xlsx.full.min.js"></script><script src='../js/myexcel.js'></script></body></html>
myexcel.js
/*jshint browser:true *//*global XLSX */var X = XLSX;var XW = {/* worker message */msg: 'xlsx',/* worker scripts */rABS: '../js/xlsxworker2.js',norABS: '../js/xlsxworker1.js',noxfer: '../js/xlsxworker.js'};function ab2str(data) {var o = "", l = 0, w = 10240;for(; l<data.byteLength/w; ++l) o+=String.fromCharCode.apply(null,new Uint16Array(data.slice(l*w,l*w+w)));o+=String.fromCharCode.apply(null, new Uint16Array(data.slice(l*w)));return o;}function s2ab(s) {var b = new ArrayBuffer(s.length*2), v = new Uint16Array(b);for (var i=0; i != s.length; ++i) v[i] = s.charCodeAt(i);return [v, b];}function xw_xfer(data, cb) {var worker = new Worker(rABS ? XW.rABS : XW.norABS);worker.onmessage = function(e) {switch(e.data.t) {case 'ready': break;case 'e': console.error(e.data.d); break;default: xx=ab2str(e.data).replace(/\n/g,"\\n").replace(/\r/g,"\\r");cb(JSON.parse(xx)); break;}};if(rABS) {var val = s2ab(data);worker.postMessage(val[1], [val[1]]);} else {worker.postMessage(data, [data]);}}function xw(data, cb) {transferable = document.getElementsByName("xferable")[0].checked;if(transferable) xw_xfer(data, cb);else xw_noxfer(data, cb);}function get_radio_value( radioName ) {var radios = document.getElementsByName( radioName );for( var i = 0; i < radios.length; i++ ) {if( radios[i].checked || radios.length === 1 ) {return radios[i].value;}}}function to_json(workbook) {var result = {};workbook.SheetNames.forEach(function(sheetName) {var roa = X.utils.sheet_to_row_object_array(workbook.Sheets[sheetName]);if(roa.length > 0){result[sheetName] = roa;}});return result;}var tarea = document.getElementById('b64data');function b64it() {if(typeof console !== 'undefined') console.log("onload", new Date());var wb = X.read(tarea.value, {type: 'base64',WTF:wtf_mode});process_wb(wb);}var token=Cookies.get("token");console.log(token);if(token==null){// alert("你是怎么进来的？请先登录");// window.location.href="../login.html";}var global_wb;function process_wb(wb) {global_wb = wb;var output = "";
//这里是成绩批量录入代码，可以忽略不计$(".submit_all").on("click",function(){var array=Object.values(to_json(wb))[0];var len=array.length;var array1="",array2="",array3="",array4="",array5="";for(var i=0;i<len;i++){array1+=array[i].学号+",";array2+=array[i].成绩+",";array3+=array[i].总分+",";array4+=array[i].时间+",";array5+=array[i].评语+",";}array1=array1.substring(0,array1.length-1);array2=array2.substring(0,array2.length-1);array3=array3.substring(0,array3.length-1);array4=array4.substring(0,array4.length-1);array5=array5.substring(0,array5.length-1);console.log(array1);var url='grade/addall';var params={"token":token,"gradeUserId":array1,"gradeCourse":array2,"gradeRank":array3,"gradeRemark":array5,"gradeTime":array4};pullData(url,params,function(res){if(res.state==0){alert("成绩录入成功！");window.location.href="Techrecord.html";}else if(res.state==1){alert("您输入的学号不存在");}});})output = JSON.stringify(to_json(wb), 2, 2);if(out.innerText === undefined) out.textContent = output;else out.innerText = output;if(typeof console !== 'undefined') console.log(output);}function setfmt() {if(global_wb) process_wb(global_wb);}var xlf = document.getElementById('xlf');function handleFile(e) {rABS = document.getElementsByName("userabs")[0].checked;use_worker = document.getElementsByName("useworker")[0].checked;var files = e.target.files;var f = files[0];{var reader = new FileReader();var name = f.name;reader.onload = function(e) {if(typeof console !== 'undefined')var data = e.target.result;if(use_worker) {xw(data, process_wb);} else {var wb;if(rABS) {wb = X.read(data, {type: 'binary'});} else {var arr = fixdata(data);wb = X.read(btoa(arr), {type: 'base64'});}process_wb(wb);}};if(rABS) reader.readAsBinaryString(f);else reader.readAsArrayBuffer(f);}}if(xlf.addEventListener) xlf.addEventListener('change', handleFile, false);
导入一个新建的excel
查看读取到的值，以json格式显示
给大家一个下载这个插件包的地址 点我
