1.npm下载并引入:
//安装
npm install --save xlsx file-saver
//需要的页面引入
import XLSX from 'xlsx'
2.data里定义一个参数tableHtml
3.处理方法
methods:{
dealt: function(url) {
let that = this;
var xhr = new XMLHttpRequest()
xhr.open('get', url, true)
xhr.responseType = 'arraybuffer'
xhr.onload = function(e) {
if (xhr.status === 200) {
var data = new Uint8Array(xhr.response)
var workbook = XLSX.read(data, {
type: 'array'
})
that.tableToHtml(workbook)
}
}
xhr.send()
},
tableToHtml: function(workbook) {
var worksheet = workbook.Sheets[workbook.SheetNames[0]];
var innerHTML = XLSX.utils.sheet_to_html(worksheet);
this.tableHtml = innerHTML;
},
}