Skip to content

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)
})