【django】 django后台管理 导出excel表

from django.contrib import admin# Register your models here.
import xlwt
from django.http import HttpResponsefrom dal import models
# Register your models here.from openpyxl import Workbookclass FundAdmin(admin.ModelAdmin):
actions = ["export_as_excel"]
list_display = ('title', 'name','type','unit','status','create_time')
list_filter = ['title', 'name','type','unit','status','create_time',] def export_as_excel(self, request, queryset):
print("queryset",queryset)
meta = self.model._meta # 用于定义文件名, 格式为: app名.模型类名
print("meta",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() # 新建Workbook
ws = wb.active # 使用当前活动的Sheet表
ws.append(field_names) # 将模型字段名作为标题写入第一行
for obj in queryset: # 遍历选择的对象列表
print(obj)
for field in field_names: data = [f'{getattr(obj, field)}' for field in field_names] # 将模型属性值的文本格式组成列表 ws.append(data) # 写入模型属性值
wb.save(response) # 将数据存入响应内容
return response export_as_excel.short_description = '导出Excel' # 该动作在admin中的显示文字admin.site.register(models.Fund, FundAdmin)