node-xlsx 写数据到xlsx文件中

 
 
1 var xlsx = require ( 'node-xlsx' );
2 var fs = require ( 'fs' );
3 var obj = { "worksheets" : [{ "data" : [[ "姓名" , "性别" , "年龄" ],[ "李晓龙" , "男" , "24" ]]}]};
4 var file = xlsx . build ( obj );
5 fs . writeFileSync ( 'user.xlsx' , file , 'binary' );
//node.io版
1 var nodeio = require ( 'node.io' );
2 var xlsx = require ( 'node-xlsx' );
3 var fs = require ( 'fs' );
4 var jsonData = [{ name : 'lixiaodong' , age : 24 , gender : 'm' },{ name : 'zhaoge' , age : 24 , gender : 'm' }];
5
6 exports . job = new nodeio . Job ({
7 input : false , //从服务器获取数据
8 run : function ( row ) {
9 var keyNames = [];
10 keyNames [ 0 ] = [];
11 var value = [];
12 if ( jsonData . length ){
13 for ( var key in jsonData [ 0 ]){
14 keyNames [ 0 ]. push ( key );
15 }
16 for ( var i = 0 ; i < jsonData . length ; i ++ ){
17 value [ i ] = [];
18 for ( var key in jsonData [ i ]){
19 value [ i ]. push ( jsonData [ i ][ key ]);
20 }
21 }
22 }
23 for ( var i = 0 ; i < value . length ; i ++ ){
24 keyNames [ keyNames . length ] = value [ i ];
25 }
26 console . log ( 'value:' , value );
27 console . log ( 'keyNames:' , keyNames );
28 this . emit ( keyNames );
29 },
30 output : function ( data ){
31 console . log ( 'data:' , data );
32 var obj = { "worksheets" : [{ "data" : data }]};
33 var file = xlsx . build ( obj );
34 fs . writeFileSync ( 'user.xlsx' , file , 'binary' );
35 }
36 });
  • 0
    点赞
  • 1
    收藏
    觉得还不错? 一键收藏
  • 4
    评论
评论 4
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值