jsons2table

jsons2table

Serialise multiple JSON files to an EXCEL and CSV file.

In order for this to work, the JSON files must have the same structure, for the most part. Slight differences are allowed though.

Content

• Content
• Principles
• Installation
• TODO
• License

Principles

Executing this command:

jsons2table /path/to/my/folder/with/json_files/my_folder_name

creates, within the given folder:

• an Excel (.xlsx) file with 1 line for each original JSON file: my_folder_name.xlsx
• also creates a CSV file with 1 line for each original JSON file: my_folder_name.csv
• if non-existent yet, a .conf file that is used to format the Excel file: my_folder_name.conf

NB: the previous version of the Excel and CSV files are erased during the process, so be careful.

Top

Installation

• make sure you have Go installed and working
• go get -u github.com/ninjawule/jsons2table
• run jsons2table -h to check this program usage

Top

TODO

• the config file generation and use, which will allow to customize the column colors, sizes, etc.
• better doc with a working example to show how that works
• CSV generation
• option to choose between CSV only / EXCEL only / both CSV & Excel
• pure library mode (being able to use jsons2table in an application)

Top

License

This program is under the terms of the MIT License.

It uses code from excelize, which is BSD 3-Clause-licensed.

Top