The files in this zip demonstrate some simple tricks using Python to update data in a spreadsheet. Look at produceSales.ipynb.
The idea came from Chapter 12 – Working with Excel Spreadsheets of the book Automate the Boring Stuff with Python.