excel-generator 1.0.2

An excel generator that takes as input a JSON file. The format of the file is list of dictionaries.

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"
  }
]