0.1.1 • Published 7 years ago
tb-excel-parser v0.1.1
tb-excel-parser
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-parser
Notice
Use
exceljs
native method:const Excel = require('tb-excel-parser')
Use
tb-excel-parser
extends methods. such as, use xlsx parse methods:const Excel = require('tb-excel-parser').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-parser').xlsxParser const co = require('co') let data = 'you get from request' const excel = new ExcelParser(data, ['a', 'b'], 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())
Doc
Create constructor
const ExcelParser = require('tb-excel-parser').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