gulp-spreadsheet2json

Export Excel (XLSX/XLS/ODS) with headers to json (only first spreadsheet in file).

ATTENTION!

I found a small bug with OpenOffice ODT files. If table has many columns, XLSX.js doesn't read all columns, but same table in XLS format work stabil!

Usage

First, install gulp-spreadsheet2json as a development dependency:

npm install --save-dev gulp-spreadsheet2json

Then, add it to your gulpfile.js:

(function() {
    'use strict';

    var gulp = require('gulp'),
        rename = require("gulp-rename"),
        xls2json = require('gulp-spreadsheet2json');

    var spreadsheets = [
            'config/**.xlsx',
            'config/**.xls',
            'config/**.ods'
        ];

    gulp.task('parse:spreadsheet', function() {
        gulp.src(spreadsheets)
            .pipe(xls2json({
                headRow: 1,
                valueRowStart: 2,
                trace: false
            }))
            .pipe(rename(function(path) {
                path.extname = ".json";
            }))
            .pipe(gulp.dest('build'));
    });

    gulp.task('default', ['parse:spreadsheet']);

}());

Input

color_name | R | G | B --- | :---: | :---: | :---: illuminant | 255 | 255 | 255 dark skin | 107 | 83 | 70 light skin | 182 | 147 | 128

Output

[
    {
        "color_name": "illuminant",
        "R": 255.00000000002,
        "G": 254.999999999984,
        "B": 254.999999999997
    },
    {
        "color_name": "dark skin",
        "R": 106.732127788008,
        "G": 82.6909148074604,
        "B": 70.141586954399
    },
    {
        "color_name": "light skin",
        "R": 182.148358411673,
        "G": 147.240481111174,
        "B": 128.262943740921
    }
]

API

spreadsheet2json([options])

Name | Type | Default | Description --- | :---: | :---: | --- headRow | number | 1 | The row number of head. (Start from 1) valueRowStart | number | 2 | The start row number of values. (Start from 1) startColumn | string | A | The start column Char of values. (Start from A) trace | Boolean | false | Whether to log each file path while convert success.

TODO

• add option for workbook.Sheets index
• add limit for rows

License

MIT