nodejs操作excel，js-xlsx文档，excel转json数据

npm地址：https://www.npmjs.com/package/js-xlsx

实现的功能

excel转json

XLSX.utils.sheet_to_json(worksheet)

if(typeof require !== 'undefined') XLSX = require('xlsx');
const path = require('path')
const xlsPath = path.join(__dirname, './assets/2020-10-15.xls')
var workbook = XLSX.readFile(xlsPath);
var sheet_name_list = workbook.SheetNames;

sheet_name_list.forEach(function(y) { /* iterate through sheets */
  // console.log(y) // Sheet1
  var worksheet = workbook.Sheets[y];

  // const jsonData = JSON.stringify( XLSX.utils.sheet_to_json(worksheet) ); // 得到json字符串
  const jsonData = XLSX.utils.sheet_to_json(worksheet); // 得到json数组
  // console.log(jsonData);
 }