1.0.2 • Published 5 years ago
e2j v1.0.2
e2j init
npm or yarn e2j
1、Make sure you have a gulp installed
2、let's get start数组 array
| A | B | C | D | E | F |
|---|---|---|---|---|---|
| (备注 decs) | 主键 | 姓名 | 成绩 | 三好学生 | 家庭成员 |
| 类型 | int | string | object | bool | array |
| 字段 | id | name | grade | is3Good | familys |
| 1 | 小明 | {math:100,english:80} | true | [farther,mother,brother] | |
| 2 | 小红 | {math:100,english:80} | true | [farther,mother,brother] | |
| 3 | 小绿 | {math:100,english:80} | true | [farther,mother,brother] |
gulp e2j =>
[{
"id": 1,
"name": "小明",
"grade": {
"math": 100,
"english": 80
},
"is3Good": true,
"familys": ["farther", "mother", "brother"]
}, {
"id": 1,
"name": "小红",
"grade": {
"math": 100,
"english": 80
},
"is3Good": true,
"familys": ["farther", "mother", "brother"]
}, {
"id": 1,
"name": "小绿",
"grade": {
"math": 100,
"english": 80
},
"is3Good": true,
"familys": ["farther", "mother", "brother"]
}]对象 object
| A | B | C | D | E | F |
|---|---|---|---|---|---|
| (备注 decs) | 主键 | 姓名 | 成绩 | 三好学生 | 家庭成员 |
| 类型 | int | string | object | bool | array |
| \$key | id | name | grade | is3Good | familys |
| xiaoming | 1 | 小明 | {math:100,english:80} | true | [farther,mother,brother] |
| xiaohong | 2 | 小红 | {math:100,english:80} | true | [farther,mother,brother] |
| xiaolv | 3 | 小绿 | {math:100,english:80} | true | [farther,mother,brother] |
gulp e2j =>
{
"xiaoming": {
"id": 1,
"name": "小明",
"grade": {
"math": 100,
"english": 80
},
"is3Good": true,
"familys": ["farther", "mother", "brother"]
},
"xiaohong": {
"id": 1,
"name": "小红",
"grade": {
"math": 100,
"english": 80
},
"is3Good": true,
"familys": ["farther", "mother", "brother"]
},
"xiaolv": {
"id": 1,
"name": "小绿",
"grade": {
"math": 100,
"english": 80
},
"is3Good": true,
"familys": ["farther", "mother", "brother"]
}
}example =>
var e2j = require('e2j');
gulp.task('e2j', function () {
gulp.src('config/**.xlsx')
.pipe(e2j({
trace: true
}))
.pipe(rename((path) => {
path.extname = ".json";
}))
.pipe(gulp.dest('excel'))
});
gulp e2j