node读取.xlsx文件写入文件
- node读取.xlsx文件
var fs = require('fs');
var events = require('events');
var xlsx = require('node-xlsx');
var eventEmitter = new events.EventEmitter();
var work;
var workdata;
var objCategory={};
var aryCategory=[];
var connectHandler = function connected() {
console.log('连接成功。');
work = xlsx.parse(__dirname+'/日本出口报关分类表20190121.xlsx');
workdata = work[0].data;
for(var i=0;i<workdata.length;i++){
var list={};
list.japanExitChinese = workdata[i][0];
list.japanExitJapanese = workdata[i][1];
list.japanExitEnglish = workdata[i][2];
aryCategory.push(list)
}
eventEmitter.emit('data_received');
}
eventEmitter.on('connection', connectHandler);
eventEmitter.on('data_received', function(){
console.log('数据接收成功。');
fs.writeFile("url.js",'let exitName = ' + JSON.stringify(aryCategory), err => {
if(!err) console.log("success~");
});
});
eventEmitter.emit('connection');
console.log("程序执行完毕。");