Django package for exporting data to Excel file with included admin integration. Note that this is not a django app.
This package uses xlwt
. Which means max 65535 rows in a file ๐.
class UserTable(Table):
id = Column(header_name="ID", width=20)
name = Column(header_name="Name", width=20)
birth_date = Column(width=20)
favorite_songs = Column(width=50, attr="get_favorite_songs")
class Meta(TableMeta):
model = User
columns = [
"id",
"name",
"birth_date",
"favorite_songs"
]
header_style = Style(bold=True, font_size=20, height=50, background_color=colors.SEA_GREEN,
font_color=colors.WHITE)
row_style = Style(bold=False, font_size=20, height=20)
none_text = "-"
class UserExcelExporter(ModelExcelExporter):
table_class = UserTable
file_name = "users"
sheet_name = "main"
style_compression = 2
include_row_number = True
exporter = UserExcelExporter()
exporter.generate(queryset=User.objects.all())
exporter.save()
- Subclass from
ExportActionMixin
and django admin'sModelAdmin
. - Define your exporter class with
excel_exporter_class
attribute in your model admin