xlsx模块 前端_纯前端利用 js-xlsx 实现 Excel 文件导入导出功能示例(2)-阿里云开发者社区...

导入功能实现

var rABS = false; //是否将文件读取为二进制字符串

function importf(obj) {//导入

if (!obj.files) { return; }

var f = obj.files[0];

{

var reader = new FileReader();

var name = f.name;

reader.onload = function (e) {

var data = e.target.result;

var wb;

if (rABS) {

wb = XLSX.read(data, { type: 'binary' });

} else {

var arr = fixdata(data);

wb = XLSX.read(btoa(arr), { type: 'base64' });

}

document.getElementById("demo").innerHTML = JSON.stringify(XLSX.utils.sheet_to_json(wb.Sheets[wb.SheetNames[0]]));

};

if (rABS) reader.readAsBinaryString(f);

else reader.readAsArrayBuffer(f);

}

}

function fixdata(data) {

var o = "", l = 0, w = 10240