nodejs 操作execl表内容

引入node-xlsx模块儿

var xlsx = require('node-xlsx');

 

var sheets = xlsx.parse('./excle/2.xlsx');//获取到所有sheets

var sheet2 = xlsx.parse("./excle/3.xls")



 var exe1 =[]

 var exe2 =[]
 读取execle内容


sheets.forEach(function(sheet){

    for(var rowId in sheet['data']){



        var row=sheet['data'][rowId];

        var json ={

            name:row[1],

            idnumber:row[4]

        }

        exe1.push(json)

    }

});

sheet2.forEach(function(sheet){

    for(var rowId in sheet['data']){



        var row=sheet['data'][rowId];

        var jsons ={

            name:row[0],

            idnumber:row[1]

        }

        exe2.push(jsons)

    }

});

将数据写入elxel

var data = [{
        name: 'sheet1',
        data: [
            [
                'ID',
                'Name',
                'Score'
            ],
            [
                '1',
                'Michael',
                '99'

            ],
            [
                '2',
                'Jordan',
                '98'
            ]
        ]
    },
    {
        name: 'sheet2',
        data: [
            [
                'AA',
                'BB'
            ],
            [
                '23',
                '24'
            ]
        ]
    }
]
var buffer = xlsx.build(data);

// 写入文件
fs.writeFile('a.xlsx', buffer, function(err) {
    if (err) {
        console.log("Write failed: " + err);
        return;
    }

    console.log("Write completed.");
});