node 读取.xlsx文件写入文件

node读取.xlsx文件写入文件

1. node读取.xlsx文件

var fs = require('fs');
var events = require('events');
//引入node，解析.xlsx文件的模块
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)
    }
    //console.log(aryCategory)
    // 触发 data_received 事件
    eventEmitter.emit('data_received');
}

// 绑定 connection 事件处理程序
eventEmitter.on('connection', connectHandler);

// 使用匿名函数绑定 data_received 事件
eventEmitter.on('data_received', function(){
    console.log('数据接收成功。');
    //文件存放的路径，把数据解析然后储存
    fs.writeFile("url.js",'let exitName = ' + JSON.stringify(aryCategory), err => {
        if(!err) console.log("success~");
    });
});
// 触发 connection 事件
eventEmitter.emit('connection');

console.log("程序执行完毕。");