In this recipe, we'll demonstrate how to create a new Excel spreadsheet from scratch, and add and deal with multiple sheets.
We will use the module openpyxl. We should install the module, adding it to our requirements.txt file as follows:
$ echo "openpyxl==2.5.4" >> requirements.txt
$ pip install -r requirements.txt
We'll store in the new file information about the movies with the most attendance. Data is extracted from here: