gulp-i18n-excel2json

Export Excel files (XLSX/XLS) to json files.

• Manage multiple or single json output file.
• Manage dynamic files path.
• Manage nested i18n keys.

examples

Format of excel file :

Key	fr	de
a.b1	value-fr-a.b1	value-de-a.b1
a.b2	value-fr-a.b2	value-de-a.b2
b	value-fr-b	value-de-b
c	value-fr-c	value-de-c
d.z.y.a1	value-fr-d.z.y.a1	value-de-d.z.y.a1
d.z.y.a2	value-fr-d.z.y.a2	value-de-d.z.y.a2

output in single json by lang

fr.json :

{
    "a": {
        "b1": "value-fr-a.b1",
        "b2": "value-fr-a.b2"
    },
    "b": "value-fr-b",
    "c": "value-fr-c",
    "d": {
        "z": {
            "y": {
                "a1": "value-fr-d.z.y.a1",
                "a2": "value-fr-d.z.y.a2"
            }
        }
    }
}

de.json :

{
    "a": {
        "b1": "value-de-a.b1",
        "b2": "value-de-a.b2"
    },
    "b": "value-de-b",
    "c": "value-de-c",
    "d": {
        "z": {
            "y": {
                "a1": "value-de-d.z.y.a1",
                "a2": "value-de-d.z.y.a2"
            }
        }
    }
}

output in multiple json by lang and namespaces :

fr-a.json :

{
    "a": {
        "b1": "value-fr-a.b1",
        "b2": "value-fr-a.b2"
    }
}

...

Usage

First, install gulp-i18n-excel2json as a development dependency:

> npm install --save-dev gulp-i18n-excel2json

Then, add it to your gulpfile.js:

var i18nExcel2json = require('gulp-i18n-excel2json');

gulp.task('i18n', function() {
    gulp.src('config/**.xlsx')
        .pipe(i18nExcel2json({
            destFile : '__lng__/translation.__ns__.json',
            readable: true,
            colKey: 'A',
            colValArray: ['B', 'C'],
            rowStart: 2,
            rowHeader: 1
        }))
        .pipe(gulp.dest('build'))
});

API

i18n-excel2json([options])

options.destFile

Type: string

Default: locales/__lng__/__ns__.json

The filenames path of output.

__lng__ : replaced by current lang

__ns__: replace by current namespace (each top level of i18n keys)

options.readable

Type: boolean

Default: true

Output human-readable json files (multiple lines).

options.colKey

Type: string

Default: A

The column name from excel file representing i18n keys.

options.colValArray

Type: array[string]

Default: ['B']

List of excel columns to output each as a language.

options.rowStart

Type: number

Default: 2

Start to output json after the specified excel line.

options.rowHeader

Type: number Default: 1

Excel line representing the header with the lang key for each translation.

License

MIT © Kirakishin (fork from Chris)