前端JS Excel解析导入

需要引入：

html：

<!DOCTYPE html>
<html lang="en">

<head>
  <meta charset="UTF-8">
  <meta name="viewport" content="width=device-width, initial-scale=1.0">
  <meta http-equiv="X-UA-Compatible" content="ie=edge">
</head>

<body>
  <input type="file" onchange="importXlsx(this)">
</body>

JS：

  function importXlsx(e) {
    let files = e.files;
    for (let i = 0; i < files.length; i++) {
      let reader = new FileReader();
      let name = files[i].name;
      reader.onload = function (e) {
        let data = e.target.result;
        let workbook = XLSX.read(data, {
          type: typeof FileReader !== "undefined" && (FileReader.prototype || {}).readAsBinaryString ?
            'binary' : 'array'
        });
        let workbookSheets = workbook.Sheets;
        for (let sheet in workbookSheets) {
          if (workbookSheets.hasOwnProperty(sheet)) {
            fromTo = workbookSheets[sheet]['!ref'];
            let xlsxData = XLSX.utils.sheet_to_json(workbookSheets[sheet]);
            // 结果数组
            console.log(sheet)
            console.log(xlsxData);
          }
        }
      };
      reader.readAsBinaryString(files[i]);
    }
  }