An excel generator that takes as input a JSON file. The format of the file is list of dictionaries.
Project description
Description
Excel export from json library used to support standardized testing.
Programmatic example
from excel_generator.generator import Generator
json_file = "results.json"
excel_file = "Results.xls"
generator = Generator(json_file=json_file, excel_file=excel_file)
generator.generate()
Package call pypi
python -m excel_generator --infile results.json --outfile results.xls
Set details
There are 3 ways to set the input variables for the CLI:
- Add an 'environment.properties' file containing: IN_FILE=results.json\nOUT_FILE=output.xls
- Set infile and outfile using an ENV VARs. E.g. export IN_FILE=results.json && export OUT_FILE=results.xls
- Set infile and outfile using CLI options '--infile' & '--outfile'
Supported formats
List of Dict(s) - Multiple messages (example)
[
{
"testName": "exampleTest1",
"Db": "Mysql57",
"OS": "Centos7",
"logLocation": "http://logdatabase.com/exampleTest1",
"startedat": "Sun Nov 1 10:16:52 EET 2020",
"endedat": "Sun Nov 1 10:22:52 EET 2020"
},
{
"testName": "exampleTest2",
"Db": "Mysql57",
"OS": "Centos7",
"logLocation": "http://logdatabase.com/exampleTest2",
"startedat": "Sun Nov 1 10:22:52 EET 2020",
"endedat": "Sun Nov 1 10:30:52 EET 2020"
}
]
Project details
Release history Release notifications | RSS feed
Download files
Download the file for your platform. If you're not sure which to choose, learn more about installing packages.
Source Distribution
excel_generator-1.0.2.tar.gz
(4.3 kB
view hashes)
Built Distribution
Close
Hashes for excel_generator-1.0.2-py3-none-any.whl
Algorithm | Hash digest | |
---|---|---|
SHA256 | cb604b5ec3e91d3b7f91bf840d004223192f552570899161a306449e051b8069 |
|
MD5 | 8b0e5f698e654fbb9655322872bbbf9d |
|
BLAKE2b-256 | 9f73b8d28e5820030e0fb9d942cee6c761706605ce7918362475a9700a8047c1 |