纯JS实现的读取excel文件内容功能示例【支持所有浏览器】
本文实例讲述了纯JS实现的读取excel文件内容功能。分享给大家供大家参考,具体如下:
template.html
JS-XLSX Live Demo
//这里主要封装了一下方法,可以忽略,主要使用到以下几个js
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 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" rel="external nofollow" ;
}
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