Report Automation

A project at Cellmax Life for generating reports by fetching data from google sheets and filling into html templates.

Execution

Run setup.py to install the packages needed

python setup.py

Run the main funciton (make sure all the sheets are accessible)

python ReportGenerator.py

Built With

• appJar - The user interface used
• Google APIs - Used for data retrieval
• PDFKit - Used to print html to pdf
• Beautiful Soup - Used for filling in data to specific id in html files
• Matplotlib - Used for drawing the CTC count trend in the report

Authors

• Yu-Tang, Shen - Initial work