Excel (XLSX/XLS) to json. If there is a headRow specified, export each line to an object. Otherwise export each line to an array.
First, install gulp-xlsx2json
as a development dependency:
> npm install --save-dev gulp-xlsx2json
Then, add it to your gulpfile.js
:
var xlsx2json = require('gulp-xlsx2json');
gulp.task('copy', function() {
gulp.src('config/**.xlsx')
.pipe(xlsx2json({
headRow: 1,
valueRowStart: 3,
trace: true
}))
.pipe(gulp.dest('build'))
});
Type: number
Default: 1
The row number of head. (Start from 1).
Type: number
Default: 3
The start row number of values. (Start from 1)
Type: Boolean
Default: false
Whether to log each file path while convert success.
MIT © Chris