前端实现excel中多个sheet页导入功能

1.前端使用xlsx插件对excel里的多个sheet转成json数据，发送给后端。

  // execute workbook stranfer main func
  const process_wb = function (workbook) {
    console.log('workbook.SheetNames', workbook.SheetNames.length);
    // 这两行原版本支持单个sheet转换成json数据
    if (workbook.SheetNames.length == 1) {
      const first_name = workbook.SheetNames[0]; // first sheet to json
      const res = XLSX.utils.sheet_to_json(workbook.Sheets[first_name]); // 转化规则：sheet首行为key, 后续行化为对象数组
      return res;
    } else {
      var result = {};
      workbook.SheetNames.forEach(function (sheetName) {
        if (sheetName != '参考值集') {
          var roa = XLSX.utils.sheet_to_json(workbook.Sheets[sheetName]);
          if(roa.length) result[sheetName] = roa;
        }
      });
      console.log('result===>>>',result)
      return result;
    }
  }