XLSX
js
// npm i XLSX
//加载excel
async loadExcelData() {
// const url = window.Config.baseUrl + '/回填线下点位.xls';
let url = '/excel/回填线下点位.xls';
return await fetch(url)
.then(response => response.arrayBuffer())
.then(data => {
const workbook = XLSX.read(data, { type: 'array' });
const sheetName = workbook.SheetNames[0]; // 假设读取第一个Sheet
const worksheet = workbook.Sheets[sheetName];
const jsonData = XLSX.utils.sheet_to_json(worksheet, { header: 1 });
return jsonData; // 打印解析后的JSON数据
})
.catch(async error => {
console.error('Failed to load Excel file:', error)
});
}
// 调用
this.loadExcelData().then(data => {
console.log(data)
})