An excel generator that takes as input a JSON file. The format of the file is either list of dictionaries or a single dictionary.
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 test result (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", ...otherinformation},
{"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", ...otherinformation}
... other tests
]
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.1.tar.gz
(4.3 kB
view hashes)
Built Distribution
Close
Hashes for excel_generator-1.0.1-py3-none-any.whl
Algorithm | Hash digest | |
---|---|---|
SHA256 | 70833b6f365a27ac7914425815b3f9a10faa6fa6c936049d9834c228bf00a2bb |
|
MD5 | dc2fc4944065aeffb357078aada898de |
|
BLAKE2b-256 | c3ed4b539bb5df69de19ee8bfc102ccbb95fb2f11ba76f558d3fda5874435da8 |