e2j

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