初始化一个node项目
npm init
//使用ejsexcel读取excel文件 npm install ejsexcel --save
let ejsExcel=require('ejsexcel');
let fs=require('fs');
let exBuf=fs.readFileSync('../public/EjsExcelTest/dataAnalysis.xlsx');
console.log(exBuf);
ejsExcel.getExcelArr(exBuf).then(exlJson=>{
console.log("************ read success:getExcelArr");
let workBook=exlJson;
let workSheets=workBook[0];
workSheets.forEach((item,index)=>{
console.log((index+1)+" row:"+item.join(' '));
})
}).catch(error=>{
console.log("************** had error!");
console.log(error);
});