Django 3 Web Development Cookbook - Fourth Edition

How it works...

If you take a look at the product administration list page in the browser, you will see a new action called Export XLSX, along with the default Delete selected Products action, as shown in the following screenshot:

We use the openpyxl Python module to create an OpenOffice XML file that's compatible with Excel and other spreadsheet software.

First, a workbook is created, and the active worksheet is selected, for which we set the title to Products. Because there are common styles that we will want to use throughout the worksheet, these are set up as named styles so that they can be applied by name to each cell, as appropriate. ...