During the month of July I wrote two blog posts for the popular Practical Business Python blog. The Practical Business Python blog is one of the top 20 most popular blogs on python with about 200.000 visits per month.

The posts focus on how you can build an automation system that generates Html reports from excel files. The system uses python, jupyter, papermill, subprocess and Rclone.

Here are the links to both parts:

These posts were featured in the Python Bytes podcast (jump to 12:39):


The architecture of the automation solution and final script follow:

JupyterLab