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 
  
  });