This package has been deprecated

Author message:

Package no longer supported. Contact Support at https://www.npmjs.com/support for more info.

xmlsx

0.2.6 • Public • Published

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

Readme

Keywords

Package Sidebar

Install

npm i xmlsx

Weekly Downloads

1

Version

0.2.6

License

MIT

Last publish

Collaborators

  • iclae0