Excel2Json
Can be converted to JSON format any Excel data.
example Excel data
A | B | C | D | |
---|---|---|---|---|
1 | {} | |||
2 | _id | obj.code | obj.value:number | |
3 | ||||
4 | first | one | 1 | |
5 | second | two | 2 | |
6 |
converted to Object
_id: 'first' obj: code: 'one' value: 1 _id: 'second' obj: code: 'two' value: 2
Installation
npm install excel2json
Usage
Quick start
example sheet.xlsx
A | B | C | D | |
---|---|---|---|---|
1 | {name: 'Test'} | |||
2 | _id | obj.code | obj.value:number | |
3 | ||||
4 | first | one | 1 | |
5 | second | two | 2 | |
6 |
Sheet1
var excel2json = ; var filename = './sheet.xlsx';var sheets = 1;excel2json;
Setup
Setup options.
var excel2json = ; excel2json;
Sheet option
sheet option. setting with optionCell (default: 'A1'
name
type
key
attr_line
data_line
ref_key
Attribute
Specify the key name.
Special character
#
Use when the array.$
Use when the split array.:number
or:num
Use when the parameters of typeNumber
.:boolean
or:bool
Use when the parameters of typeBoolean
.:date
Use when the parameters of unix time.:index
Use when the array of array.
Example
An example of a complex format.
var excel2json = ; excel2json;
Contribution
- Fork it ( https://github.com/iyu/excel2json/fork )
- Create a feature branch
- Commit your changes
- Rebase your local changes against the master branch
- Run test suite with the
npm test; npm run lint
command and confirm that it passes - Create new Pull Request