xmlsx

xmlsx

xmlsx = xml + xlsx

Method

• frozen: frozen a line (冻结某行以上)

  @type step
  @param [Number | String] - rowNumber
  

• entry: input entry (输入表格数据)

  @type step
  @param [Array[Array]] - inputData
  

• valid: set valid (数据验证)

  @type step
  @param [Array[Object]] - validData
  

• hide: hide one cell (隐藏某个cell)

  @type step
  @param [String] - hideCell
  

• output: get xlsx json (解析xlsx并输出内容)

  @type final
  @return @see entry param
  

• done: get xlsx buffer (获取设定后的xlsx)

  @type final
  @return [Buffer] xlsxBuffer
  

• getCell: get a xlsx axis (转换xy坐标为xlsx的位置)

  @type tool
  @param [Number, Number] x,y start on 0
  @return [String] cell eg:'A1'
  

• formatDate: format Date cell (将日期格式的cell值转换为Date)

  @type tool
  @param [Number|String] dateCellVal
  @return [Date] date
  

Example

Make Xlsx

var xmlsx = new Xmlsx()

xmlsx
  .entry([
    ['1', 2, '三'], 
    ['foo', 'bar'],
    [],
    ['', 'space', ],
    ['', '', '@_@']
  ])
  .frozen('5')
  .hide('A2')
  .valid([
    { A1: ['male', 'famale'] }, 
    { B5: ['JS', 'Node', '东北话'] }, 
    { 'C2:C1000': ['甜豆腐脑', '咸豆腐脑'] }
  ])
  .done(function(err, buf) {
    fs.writeFile('test.xlsx', buf)
  })

Read Xlsx

fs.readFile('test.xlsx', function(err, buf) {
  var xmlsx = new Xmlsx(buf)
  xmlsx.output()
  //-> { entry: [[...], [...], ...] }

  xmlsx.frozen().output()
  //-> { ..., frozen: '5' }

  xmlsx.valid().frozen().output()
  //-> { ..., valid: [{ A1: [ male, famale ]}] }
})

Tools

  Xmlsx.getCell(0, 0)   //-> 'A1'
  Xmlsx.getCell(1, 2)   //-> 'B3'

  Xmlsx.formatDate(42735)  //-> Sun Jan 01 2017 00:00:00 GMT+0800 (CST) (2017/1/1)

Current

• windows write data wrong