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.
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 originalJSON
file:my_folder_name.xlsx
- also creates a
CSV
file with 1 line for each originalJSON
file:my_folder_name.csv
- if non-existent yet, a
.conf
file that is used to format theExcel
file:my_folder_name.conf
NB: the previous version of the Excel
and CSV
files are erased during the process, so be careful.
- make sure you have
Go
installed and working go get -u github.com/ninjawule/jsons2table
- run
jsons2table -h
to check this program usage
- 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)
This program is under the terms of the MIT License.
It uses code from excelize, which is BSD 3-Clause-licensed.