Django 3 Web Development Cookbook - Fourth Edition

How to do it...

Admin actions are functions that take three arguments, as follows:

• The current ModelAdmin value
• The current HttpRequest value
• The QuerySet value, which contains the selected items

Perform the following steps to create a custom admin action to export a spreadsheet:

1. Create a ColumnConfig class for spreadsheet column configuration in the admin.py file of the products app, as follows:

# myproject/apps/products/admin.pyfrom openpyxl import Workbookfrom openpyxl.styles import Alignment, NamedStyle, builtinsfrom openpyxl.styles.numbers import FORMAT_NUMBERfrom openpyxl.writer.excel import save_virtual_workbookfrom django.http.response import HttpResponsefrom django.utils.translation import ugettext_lazy as _from ordered_model.admin ...