nodejs读取excel

第一步引入包 
npm install xlsx -save

第一步代码

console.clear();

var xl = require('xlsx');

var fs = require('fs');

var workbook = xl.readFile("1.xlsx")

//var dataa =xl.utils.sheet_to_json(worksheet);

const sheetNames = workbook.SheetNames; // 返回 ['sheet1', 'sheet2']

// 根据表名获取对应某张表

const worksheet = workbook.Sheets[sheetNames[0]];

var dataa =xl.utils.sheet_to_json(worksheet);

var str = JSON.stringify(dataa);

console.log(str)