Metadata-Version: 2.1
Name: excel-generator
Version: 1.0.1
Summary: An excel generator that takes as input a JSON file. The format of the file is either list of dictionaries or a single dictionary.
Home-page: https://github.com/estuaryoss/test-libs-python/tree/master/excel_generator
Author: Catalin Dinuta
Author-email: constantin.dinuta@gmail.com
License: Apache
Platform: UNKNOWN
Classifier: Programming Language :: Python :: 3.7
Classifier: Programming Language :: Python :: 3.8
Classifier: Programming Language :: Python :: 3.9
Classifier: License :: OSI Approved :: Apache Software License
Classifier: Operating System :: OS Independent
Description-Content-Type: text/markdown
Requires-Dist: click
Requires-Dist: pyexcel
Requires-Dist: pyexcel-xls
Requires-Dist: pyexcel-xlsx
Requires-Dist: pyexcel-xlsxw
Requires-Dist: setuptools (==44.0.0)
Requires-Dist: jproperties

### Description
Excel export from json library used to support standardized testing.


## Programmatic example
```python
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
```shell
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)
```json
[
{"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

]
```

