gulp-sheets2json

converts sheets of an excel file into a json files

Downloads in past

Stats

StarsIssuesVersionUpdatedCreatedSize
gulp-sheets2json
301.0.18 years ago8 years agoMinified + gzip package size for gulp-sheets2json in KB

Readme

Excel sheets to json converter #
  • Simple gulp plugin for converting excel sheets into json files.
+ Creates a JSON file for each sheet. The name of the file is equal to the name of the sheet (tab)
+ You can choose which sheet should be exported, by using a filter. Filters can be defined as - minimatch - expession
+ If you want to ignore some columns you can add an exclamation mark (!) at the very beginning of the column header
+ Ignores sheets which name starts with a exclamation mark (!)
+ Ignores empty sheets        

Version ###

1.0.1

Install ###

npm install gulp-sheets2json

Usage ###

```
!javascript
var gulp = require('gulp'),
s2j = require('gulp-sheets2json');
gulp.task("bulid:json", function () {
gulp.src("SampleBook.xlsx")
.pipe(s2j({ filter: "+(First|Second)" }))
// do some further stuff (transform, beautify, etc.)
.pipe(gulp.dest('.out'));
}); gulp.task("default", "bulid:json", function () {
gulp.watch("SampleBook.xlsx", ["bulid:json"])
}); ```

Dependencies ###

gulp-util, minimatch, through2, vinyl, xlsx