django admin后台定制excle导出功能，工具类给你整理好了

一写代码就开心

发布于 2021-06-17 19:52:08

8270

文章被收录于专栏：java和pythonjava和python

以上这里什么都没有，我们需要在后台配置一下

在这里写导出的方法

class ExportExcelMixin(object):
    def export_as_excel(self, request, queryset):
        meta = self.model._meta
        field_names = [field.name for field in meta.fields]

        response = HttpResponse(content_type='application/msexcel')
        response['Content-Disposition'] = f'attachment; filename={meta}.xlsx'
        wb = Workbook()
        ws = wb.active
        ws.append(field_names)
        for obj in queryset:
            for field in field_names:
                data = [f'{getattr(obj, field)}' for field in field_names]
            row = ws.append(data)

        wb.save(response)
        return response

    export_as_excel.short_description = '导出Excel'