Presenting information in spreadsheets is not just a matter of organizing it into cells or displaying it graphically in charts, but also involves changing the format to highlight the important points about it. In this recipe, we'll see how to manipulate the format of cells to enhance the data and present it in the best way.
Working with format in Excel
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:
