我正在尝试解析我已经拥有URL的excel文件.尝试访问该文件时,我一直遇到不同的错误,以便它可以读取.现在,这是我的代码:
const input_file = doc.input_file;
const extension = input_file.split('.').pop();
let XMLHttpRequest = require("xmlhttprequest").XMLHttpRequest;
let oReq = new XMLHttpRequest();
oReq.open("GET", input_file, true);
oReq.respOnseType= "arraybuffer";
oReq.Onload= function(e) {
let arraybuffer = oReq.responseText;
/* convert data to binary string */
let data = new Uint8Array(arraybuffer);
let arr = new Array();
for(let i = 0; i != data.length; ++i) arr[i] = String.fromCharCode(data[i]);
let bstr = arr.join("");
/* Call XLSX */
let workbook = XLSX.read(bstr, {type:"binary"});
/* DO SOMETHING WITH workbook HERE */
let firstSheet = workbook.SheetNames[0];
let parsed = XLSX.utils.sheet_to_csv(firstSheet);
console.log(parsed);
}
oReq.send();
我得到的当前错误是:Error: Unsupported file NaN当我尝试读取文件时:let workbook = XLSX.read(bstr, {type:"binary"});
我不确定读取外部链接的最简单方法.有任何想法吗?如果有帮助,我正在使用Meteor.
|