我使用vue和axios分装的request去导入一个远程链接下的excel文件,文件数据能够通过resp获取到,
console.log 打印是一堆这样的excel数据
�N�@ E xl/PK
�N�@ b xl/_rels/PK �N�@��� � � xl/_rels/workbook.xml.relsPK �N�@�A�/� W � xl/sharedStrings.xmlPK �N�@%Y=�
VM
Q
xl/styles.xmlPK
�N�@ xl/theme/PK �N�@L��� E xl/theme/theme1.xmlPK �N�@v��& � � xl/workbook.xmlPK
�N�@ f xl/worksheets/PK �N�@���LV V � xl/worksheets/sheet1.xmlPK F
后面我使用excelIo.open 去 加载这个数据,但是报了的错误
TypeError: Failed to execute 'readAsArrayBuffer' on 'FileReader': parameter 1 is not of type 'Blob'. at e.loadFile (gc.spread.excelio.min.js?8e91:26:1) at e.open (gc.spread.excelio.min.js?8e91:22:1)
不知道使用哪里出了问题
getXlsx: function(webpath) {
const excelIo = new IO();
request({ url: webpath , method: 'get', headers: { cache: false,"Content-Type": "application/x-www-form-urlencoded", "Access-Control-Allow-Origin": "*", 'X-Requested-With': 'XMLHttpRequest', crossDomain: true} })
.then(resp => {
console.log('get excel', resp);
excelIo.open(resp, json => {
console.log('excel json',json);
this.spread.fromJSON(json);
});
}).catch(error => {
console.log(error);
});
}
|