Creating new sheets on an Excel spreadsheet

In this recipe, we'll demonstrate how to create a new Excel spreadsheet from scratch, and add and deal with multiple sheets.

Getting ready

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:

http://www.mrob.com/pub/film-video/topadj.html.

How to do it...

...