xlsx2seed.js

xlsx to seed yamls

Install

npm:

npm install -g xlsx2seed

Usage

$ xlsx2seed

  Usage: xlsx2seed [options] <files...>

  Options:

    -h, --help                                                         output usage information
    -V, --version                                                      output the version number
    -S, --subdivide [sheet_name1:2,1:sheet_name2:2,2:sheet_name3,...]  subdivide rules
    -I, --ignore [sheet_name1,sheet_name2,...]                         ignore sheet names
    -O, --only [sheet_name1,sheet_name2:2,...]                         only sheet names
    -i, --input [path]                                                 input directory
    -o, --output [path]                                                output directory
    -d, --stdout                                                       output one sheets to stdout
    -R, --require-version [version]                                    require version (with version column)
    -v, --version-column [column_name]                                 version column
    -n, --ignore-columns [column_name1,column_name2,...]               ignore columns
    -c, --config [path]                                                config file (default: xlsx2seed.yml)
    -C, --config-content [yaml string]                                 config content

  Examples:

    # multiple files
    $ xlsx2seed -i /path/to/src -o /path/to/dst hoge.xlsx huga.xlsx

    # only foo and bar sheets / bar subdivide postfix 2
    $ xlsx2seed hoge.xlsx huga.xlsx -O foo,bar:2

    # foo subdivide prefix 1 / bar subdivide postfix 2 / baz subdivide prefix 1 and postfix 2
    $ xlsx2seed hoge.xlsx huga.xlsx -S 2:foo,bar:2,1:baz:2

    # column names row is 3 (2 in zero origin)
    $ xlsx2seed hoge.xlsx huga.xlsx -C "column_names_row: 2"

Build

git clone ...
cd xlsx2seed
npm i
gulp
npm i .

Changelog

v1.0.0

feature: require version

-R -v option.

feature: ignore columns

-n option.

BREAKING CHANGE: default ignored columns

Now there is no ignored columns. (It was "dummy" and "VERSION".)

BREAKING CHANGE: Xlsx2SeedSheet::data API

Now Xlsx2SeedSheet::data() is a method. (It was a getter property, Xlsx2SeedSheet::data.)

License

This is released under Zlib License.

This software is using libraries that is released under Apache 2.0 license.