0.1.4 • Published 7 years ago

tb-excel v0.1.4

Weekly downloads
2
License
ISC
Repository
github
Last release
7 years ago

tb-excel

Build Status NPM version

When you get excel binary data from http or a file, you can use this to parse it and get object you want

Installation

npm install tb-excel

Support

SourceparserulelimittoObject
binarysupportsupportsupportsupport
utf8+BOMsupportsupportsupportsupport
utf16supportsupportsupportsupport
filesupportnonono

Notice

  • Use exceljs native method:

      const Excel = require('tb-excel').exceljs
  • Use tb-excel extends methods. such as, use xlsx parse methods:

      const Excel = require('tb-excel').xlsxParser

Example

  • Read from url: we want get excel content not only from local files but also from others

    For Example:

    First: Use request to get data from server

      let res = request.get(downloadUrl, { encoding: null }, function(error, response, body) {
          // ……
        })
      }

    Second: We can parse some binary data which get from request:

      'use strict'
      const ExcelParser = require('tb-excel').xlsxParser
    
      const co = require('co')
    
      let data = 'you get from request'
      let rule = ['a', 'b']
      const excel = new ExcelParser(data, rule, 3)
    
      //  you can use gengerator or async, depends yourself
    
      function * parser () {
        let row = yield excel.parse()
        console.log(row) // we can get each rows content from excel
      }
      co(parser())

    Last: Format data according to you rule

    
     obj = row.toArray()
     console.log(obj)
     // [{
    		  a: '',
          b: ''
    		}]

Doc

Create constructor

  const ExcelParser = require('tb-excel').xlsxParser

  const excel = new ExcelParser(data, ['a', 'b'], 3)

Get Arrays from excel

  const excel = new ExcelParser(data)
  let ret = yield excel.parse() // ['a', 18, 'man']

Get Array Obj you want

  const rule = [
    'name',
    'age',
    'sex'
  ]

  const excel = new ExcelParser(data, rule)
  let ret = yield excel.parse()
  excel.toArray() // // { name: 'a', age: 18, sex: 'man' }

Skip rows

  const rule = [
    'name',
    'age',
    'sex'
  ]

  const skip = 1

  const excel = new ExcelParser(data, rule)

  excel.setHeaderline(skip)
  yield excel.parse()
  excel.toArray() // { age: 18, sex: 'man' }

Check if exceed limit

  const rule = [
    'name',
    'age',
    'sex'
  ]

  const excel = new ExcelParser(data, rule, 1)
  yield excel.parse()
  excel.toArray() // { name: 'a', age: 18, sex: 'man' }

  excel.isExccedLimit // true
0.1.4

7 years ago

0.1.3

7 years ago

0.1.2

7 years ago

0.1.1

7 years ago

0.1.0

7 years ago

0.0.5

7 years ago

0.0.4

7 years ago

0.0.3

7 years ago

0.0.2

7 years ago

0.0.1

7 years ago

1.0.5

7 years ago