Appendix.1 Errors

sys.exit by each index.

errors = ['OK',
            'sheets link not found.', 'schema not found.', # 1, 2
            'root sheet not found.', 'Unrecognized item type were found.', # 3, 4
            'Unknown accumulator!', 'Output json has failed.', # 5, 6
            'Unsupported table filetype found.', 'setting yaml file not found']

Appendix 2. Help

$ jsonica.py -h
usage: jsonica.py [-h] [-v] [-e {python built-in codec}]  ...

generate complex structure JSON with analyzing META descripted file.

positional arguments:
                        sub-commands
    initialize (init, i)
                        create formated workbook template.
    generate (gen, g)   generate analyzed files as TEXT from META descritor
                        file. (e.g., Excel)

optional arguments:
  -h, --help            show this help message and exit
  -v, --version         show program's version number and exit
  -e {python built-in codec}, --encoding {python built-in codec}
                        Set default charactor encode. When not set this, it is
                        treated as "utf-8". see also. https://docs.python.org/3.6/library/codecs.html#standard-encodings

# initialize subcommand help
$ jsonica.py init -h
usage: jsonica.py initialize [-h] [-tx [path/to/outputfile.xlsx]]

optional arguments:
  -h, --help            show this help message and exit
  -tx [path/to/outputfile(.xlsx)], --template_xlsx [path/to/outputfile(.xlsx)]
                        This is an initialize helper option. Generate template
                        xlsx file based on same filename.yaml. **And if you
                        set this, other options are ignored.** will be
                        subcommand.

# generate subcommand help
$ jsonica.py gen -h
usage: jsonica.py generate [-h] [-v] [-i [path/to/inputfile]]
                                       [-hr tabsize] [-r [sheetname]]
                                       [-o [path/to/outputfile.json]]
                                       [-of [(csv | tsv):path/to/outputdir]]

optional arguments:
  -h, --help            show this help message and exit
  -v, --version         show program's version number and exit
  -i [path/to/inputfile], --input [path/to/inputfile]
                        Set path/to/input xlsx filename.
  -hr tabsize, --human_readable tabsize
                        set indent size by numeric value, Output humanreadable
                        json files.
  -r [sheetname], --root_sheet [sheetname]
                        set a sheetname in xlsx book have. construct json tree
                        from the sheet as root item. "root" is Default root
                        sheet name.
  -o [path/to/outputfile(.json)], --output [path/to/outputfile(.json)]
                        Output interpreted json. If this set which endswith
                        ".json" as set full filename, output jsonfile treated
                        as the name. But when not set ".json", adopt original
                        xlsx filename, like
                        path/to/outputfile/[source_METAFile_name].json (-o has
                        special filename "-" as STDOUT, and when set like "-o
                        -", all other stdout messages were masked.)
  -of [(csv | tsv):path/to/outputdir], --output_format [(csv | tsv):path/to/outputdir]
                        Output with the format, If you set this, output
                        formfiles to
                        path/to/[source_METAFile_name].xlsx/[sheetname.?sv]s
                        It'll be recommended, if you want to have
                        communication with non Tech team without any
                        gitconfiging.

Appendix 3. MindMap

mindnode(ja only)

Jsonica

to construct huge json data simply.

Appendix.1 Errors

Appendix 2. Help

Appendix 3. MindMap